SAP ABAP Table PIQDBAGR_GEN (DB Table for Appraisals)

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-HER-CM-AD (Application Component) Administration
     ⤷ PMIQ (Package) Campus Management

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PIQDBAGR_GEN	Table Relationship Diagram
Short Description	DB Table for Appraisals

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	AGRID	☑	PIQAGRID	SYSUUID_C	CHAR	32	0	Appraisal ID
3	.INCLUDE	☐				0	0	Grading Information
4	GRADESYM	☐	PIQGRADESYM	PIQGRADESYM	CHAR	10	0	Grade Symbol
5	GRADE	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
6	GRADESCALE	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
7	AGRNOTRATED	☐	PIQAGRNOTRATED	PIQAGRNOTRATED	CHAR	1	0	Appraisal Grade Not Relevant
8	AGRDATE	☐	PIQAGRDATE	PIQDATE	DATS	8	0	Appraisal Date
9	AGRCOMPLETED	☐	PIQAGRCOMPLETED	PIQAGRCOMPLETED	CHAR	1	0	Appraisal Completed
10	NOTEID	☐	PIQNOTE_GUID	SYSUUID_C	CHAR	32	0	GUID - Unique Note Identifier

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQDBAGR_GEN	GRADESCALE	T7PIQSCALE	SCALEID	REF	1	CN

History

Last changed by/on	SAP	20050409
SAP Release Created in	464