SAP ABAP Table PIQAGR_BUFF_APPRAISAL (Appraisal Buffer Structure)

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	INTTAB	Structure
Structure	PIQAGR_BUFF_APPRAISAL	Table Relationship Diagram
Short Description	Appraisal Buffer Structure

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Program Description
2	STUDY	☐	PIQAGRSTUDEY	CHAR40	CHAR	40	0	Program
3	.INCLUDE	☐				0	0	Grading Scale Description
4	GRADESCALET	☐	PIQSCALE_TEXT	PIQSCALE_TEXT	CHAR	30	0	Academic Scale (Description)
5	.INCLUDE	☐				0	0	Appraisal
6	AGRID	☐	PIQAGRID	SYSUUID_C	CHAR	32	0	Appraisal ID
7	.INCLUDE	☐				0	0	Appraisal: Administration Data
8	ATTNO	☐	PIQAGR_ATTNO	NUM03	NUMC	3	0	Repetition Attempt Number
9	AGRTYPE	☐	PIQAGRTYPE	PIQAGRTYPE	NUMC	4	0	Appraisal Type	T7PIQAGR_TYPE
10	AGRSTAT	☐	PIQAGRSTAT	PIQAGRSTAT	CHAR	5	0	Appraisal Status	T7PIQAGRC_STAT
11	ARCH_STATUS	☐	PIQAGR_ARCH_STATUS	PIQAGR_ARCH_STATUS	CHAR	1	0	Appraisal Archiving Status
12	AGRREMARK	☐	PIQAGRREMARK	PIQAGRREMARK	CHAR	2	0	Appraisal Remark	*
13	AYEAR	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	T7PIQYEAR
14	APERIOD	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	T7PIQPERIOD
15	.INCLUDE	☐				0	0	Appraisal Validity
16	AGRBEGDA	☐	PIQAGRBEGDA	PIQDATE	DATS	8	0	Start of Appraisal Validity
17	AGRENDDA	☐	PIQAGRENDDA	PIQDATE	DATS	8	0	End of Appraisal Validity
18	AGRDATEE	☐	PIQAGRDATEE	PIQDATE	DATS	8	0	Earliest Appraisal Date
19	AGRDATEL	☐	PIQAGRDATEL	PIQDATE	DATS	8	0	Latest Appraisal Date
20	.INCLUDE	☐				0	0	Appraisal Relationship Information
21	AGRWEIGHT	☐	PIQAGRWEIGHT	PIQAGRWEIGHT	DEC	5	2	Appraisal Weighting
22	UPAGRID	☐	PIQAGRID	SYSUUID_C	CHAR	32	0	Appraisal ID	PIQDBAGR_GEN
23	.INCLUDE	☐				0	0	Grading Information
24	GRADESYM	☐	PIQGRADESYM	PIQGRADESYM	CHAR	10	0	Grade Symbol
25	GRADE	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
26	GRADESCALE	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
27	AGRNOTRATED	☐	PIQAGRNOTRATED	PIQAGRNOTRATED	CHAR	1	0	Appraisal Grade Not Relevant
28	AGRDATE	☐	PIQAGRDATE	PIQDATE	DATS	8	0	Appraisal Date
29	AGRCOMPLETED	☐	PIQAGRCOMPLETED	PIQAGRCOMPLETED	CHAR	1	0	Appraisal Completed
30	NOTEID	☐	PIQNOTE_GUID	SYSUUID_C	CHAR	32	0	GUID - Unique Note Identifier
31	.INCLU-TXT	☐				0	0	Appraisal (Description)
32	AGRIDTXT	☐	PIQAGRID	SYSUUID_C	CHAR	32	0	Appraisal ID
33	.INCLUDE	☐				0	0	Appraisal (Description)
34	LANGUTXT	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
35	AGRTEXTTXT	☐	PIQAGRTEXT	TEXT50	CHAR	50	0	Appraisal (Description)
36	.INCLU-APE	☐				0	0	Appraisee
37	OTYPEAPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
38	REALOAPE	☐	REALO	CHAR45	CHAR	45	0	Extended Object ID
39	PLVARAPE	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
40	.INCLU-ASG	☐				0	0	Appraised Object
41	AGRPLVARASG	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
42	AGROTYPEASG	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
43	AGRREALOASG	☐	REALO	CHAR45	CHAR	45	0	Extended Object ID
44	INFTYASG	☐	INFOTYP	INFOTYP	CHAR	4	0	Infotype	T777D
45	RSIGNASG	☐	RSIGN	RSIGN	CHAR	1	0	Relationship Specification
46	RELATASG	☐	RELAT	RELAT	CHAR	3	0	Relationship Between Objects	T778V
47	ISTATASG	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	T778S
48	PRIOXASG	☐	PRIOX	CHAR2	CHAR	2	0	Priority
49	BEGDAASG	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
50	ENDDAASG	☐	ENDDATUM	DATUM	DATS	8	0	End Date
51	VARYFASG	☐	VARYF	CHAR10	CHAR	10	0	Variation Field for File PLOG
52	SEQNRASG	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
53	SCLASASG	☐	SCLAS	OTYPE	CHAR	2	0	Type of Related Object	T778O
54	SOBIDASG	☐	SOBID	CHAR45	CHAR	45	0	ID of Related Object
55	MODREG_IDASG	☐	PIQMODREG_ID	SYSUUID_C	CHAR	32	0	Module Booking Identification
56	.INCLU-APR	☐				0	0	Appraiser (Functions)
57	SEQNRAPR	☐	PIQAGR_FUNC_SEQNR	PIQSEQNR	NUMC	3	0	Sequence Number of Function
58	.INCLUDE	☐				0	0	Appraiser
59	OTYPEAPR	☐	PIQAGR_APPSER_TYPE	OTYPE	CHAR	2	0	Object Type of the Appraiser	T778O
60	REALOAPR	☐	PIQAGR_APPSER_ID	CHAR45	CHAR	45	0	Identification (ID) of the Appraiser
61	PLVARAPR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
62	FUNCTIONAPR	☐	PIQAGR_APPFUNCTION	PIQAGR_APPFUNCTION	CHAR	4	0	Function Exercised (Abbreviation	*
63	.INCLU-FOL	☐				0	0	Appraisal Additional Data
64	CPATTEMPFOL	☐	PIQCPATTEMP	PIQCP	QUAN	10	5	Attempted Credits
65	CPEARNEDFOL	☐	PIQCPEARNED	PIQCP	QUAN	10	5	Earned Credits
66	CPGRADEDFOL	☐	PIQCPGRADED	PIQCP	QUAN	10	5	Graded Credits
67	CPUNITFOL	☐	PIQCPUNIT	MEINS	UNIT	3	0	Unit of Measurement for Credits	*
68	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQAGR_BUFF_APPRAISAL	AGROTYPEASG	T778O	OTYPE	REF	1	CN
2	PIQAGR_BUFF_APPRAISAL	AGRPLVARASG	T778P	PLVAR	REF	1	CN
3	PIQAGR_BUFF_APPRAISAL	AGRSTAT	T7PIQAGRC_STAT	AGRSTAT
4	PIQAGR_BUFF_APPRAISAL	AGRTYPE	T7PIQAGR_TYPE	AGRTYPE
5	PIQAGR_BUFF_APPRAISAL	APERIOD	T7PIQPERIOD	PERID
6	PIQAGR_BUFF_APPRAISAL	AYEAR	T7PIQYEAR	PERYR
7	PIQAGR_BUFF_APPRAISAL	GRADESCALE	T7PIQSCALE	SCALEID	REF	1	CN
8	PIQAGR_BUFF_APPRAISAL	INFTYASG	T777D	INFTY	REF	1	CN
9	PIQAGR_BUFF_APPRAISAL	ISTATASG	T778S	ISTAT	REF	1	CN
10	PIQAGR_BUFF_APPRAISAL	LANGUTXT	T002	SPRAS		1	CN
11	PIQAGR_BUFF_APPRAISAL	OTYPEAPE	T778O	OTYPE	REF	1	CN
12	PIQAGR_BUFF_APPRAISAL	OTYPEAPR	T778O	OTYPE	REF	1	CN
13	PIQAGR_BUFF_APPRAISAL	PLVARAPE	T778P	PLVAR	REF	1	CN
14	PIQAGR_BUFF_APPRAISAL	PLVARAPR	T778P	PLVAR	REF	1	CN
15	PIQAGR_BUFF_APPRAISAL	RELATASG	T778V	RELAT	REF	1	CN
16	PIQAGR_BUFF_APPRAISAL	SCLASASG	T778O	OTYPE
17	PIQAGR_BUFF_APPRAISAL	UPAGRID	PIQDBAGR_GEN	AGRID

History

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