SAP ABAP Table PIQAGR_FINAL_BUFFER (Final Appraisal Buffer Tables (Student, Module, Appraisal))

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_FINAL_BUFFER	Table Relationship Diagram
Short Description	Final Appraisal Buffer Tables (Student, Module, Appraisal)

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	Buffer Structure for Final Appraisal
2	.INCLUDE	☐				0	0	Transfer Structure for Final Appraisal
3	AGRID	☐	PIQAGRID	SYSUUID_C	CHAR	32	0	Appraisal ID
4	.INCLUDE	☐				0	0	Final Appraisal
5	AGRSTAT	☐	PIQAGRSTAT	PIQAGRSTAT	CHAR	5	0	Appraisal Status	*
6	AYEAR	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	*
7	APERIOD	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	*
8	.INCLUDE	☐				0	0	Appraisal Validity
9	AGRBEGDA	☐	PIQAGRBEGDA	PIQDATE	DATS	8	0	Start of Appraisal Validity
10	AGRENDDA	☐	PIQAGRENDDA	PIQDATE	DATS	8	0	End of Appraisal Validity
11	AGRDATEE	☐	PIQAGRDATEE	PIQDATE	DATS	8	0	Earliest Appraisal Date
12	AGRDATEL	☐	PIQAGRDATEL	PIQDATE	DATS	8	0	Latest Appraisal Date
13	.INCLUDE	☐				0	0	Grading Information
14	GRADESYM	☐	PIQGRADESYM	PIQGRADESYM	CHAR	10	0	Grade Symbol
15	GRADE	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
16	GRADESCALE	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
17	AGRNOTRATED	☐	PIQAGRNOTRATED	PIQAGRNOTRATED	CHAR	1	0	Appraisal Grade Not Relevant
18	AGRDATE	☐	PIQAGRDATE	PIQDATE	DATS	8	0	Appraisal Date
19	AGRCOMPLETED	☐	PIQAGRCOMPLETED	PIQAGRCOMPLETED	CHAR	1	0	Appraisal Completed
20	NOTEID	☐	PIQNOTE_GUID	SYSUUID_C	CHAR	32	0	GUID - Unique Note Identifier
21	.INCLU-TXT	☐				0	0	Appraisal (Description)
22	AGRIDTXT	☐	PIQAGRID	SYSUUID_C	CHAR	32	0	Appraisal ID
23	.INCLUDE	☐				0	0	Appraisal (Description)
24	LANGUTXT	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
25	AGRTEXTTXT	☐	PIQAGRTEXT	TEXT50	CHAR	50	0	Appraisal (Description)
26	.INCLU-APE	☐				0	0	Appraisee
27	OTYPEAPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
28	REALOAPE	☐	REALO	CHAR45	CHAR	45	0	Extended Object ID
29	PLVARAPE	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
30	.INCLU-ASG	☐				0	0	Appraised Object
31	AGRPLVARASG	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
32	AGROTYPEASG	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
33	AGRREALOASG	☐	REALO	CHAR45	CHAR	45	0	Extended Object ID
34	INFTYASG	☐	INFOTYP	INFOTYP	CHAR	4	0	Infotype	T777D
35	RSIGNASG	☐	RSIGN	RSIGN	CHAR	1	0	Relationship Specification
36	RELATASG	☐	RELAT	RELAT	CHAR	3	0	Relationship Between Objects	T778V
37	ISTATASG	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	T778S
38	PRIOXASG	☐	PRIOX	CHAR2	CHAR	2	0	Priority
39	BEGDAASG	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
40	ENDDAASG	☐	ENDDATUM	DATUM	DATS	8	0	End Date
41	VARYFASG	☐	VARYF	CHAR10	CHAR	10	0	Variation Field for File PLOG
42	SEQNRASG	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
43	SCLASASG	☐	SCLAS	OTYPE	CHAR	2	0	Type of Related Object	T778O
44	SOBIDASG	☐	SOBID	CHAR45	CHAR	45	0	ID of Related Object
45	MODREG_IDASG	☐	PIQMODREG_ID	SYSUUID_C	CHAR	32	0	Module Booking Identification
46	.INCLU-APR	☐				0	0	Appraiser
47	OTYPEAPR	☐	PIQAGR_APPSER_TYPE	OTYPE	CHAR	2	0	Object Type of the Appraiser	T778O
48	REALOAPR	☐	PIQAGR_APPSER_ID	CHAR45	CHAR	45	0	Identification (ID) of the Appraiser
49	PLVARAPR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
50	.INCLU-FOL	☐				0	0	Appraisal Additional Data
51	CPATTEMPFOL	☐	PIQCPATTEMP	PIQCP	QUAN	10	5	Attempted Credits
52	CPEARNEDFOL	☐	PIQCPEARNED	PIQCP	QUAN	10	5	Earned Credits
53	CPGRADEDFOL	☐	PIQCPGRADED	PIQCP	QUAN	10	5	Graded Credits
54	CPUNITFOL	☐	PIQCPUNIT	MEINS	UNIT	3	0	Unit of Measurement for Credits	*
55	.INCLUDE	☐				0	0
56	.INCLUDE	☐				0	0	Grading Scale Description
57	GRADESCALET	☐	PIQSCALE_TEXT	PIQSCALE_TEXT	CHAR	30	0	Academic Scale (Description)
58	.INCLUDE	☐				0	0	Organizational Unit Name
59	ORGUNIT	☐	PIQAGRORGUNIT	CHAR40	CHAR	40	0	Organizational Unit
60	.INCLUDE	☐				0	0	Program Description
61	STUDY	☐	PIQAGRSTUDEY	CHAR40	CHAR	40	0	Program
62	.INCLUDE	☐				0	0	Student Information for Appraisal
63	STUDENTNUMBER	☐	PIQSTUDENT12	PIQSTUDENT12	CHAR	12	0	Student Number
64	STUDENTNAME	☐	STEXT	TEXT40	CHAR	40	0	Object Name
65	FIRST_NAME	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
66	LAST_NAME	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
67	PERSIDNO	☐	PIQ_PRDNI	CHAR20	CHAR	20	0	Identification Number
68	NAME_AT_BIRTH	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
69	.INCLUDE	☐				0	0	BAPI Structure for Student: Org. Unit (Text Fields)
70	ASSIGNED_ORGUNIT	☐	PIQSTORGUNIT_ASSIGNED	HROBJID	NUMC	8	0	Assigned Organizational Unit of Student	*
71	ASSIGNED_ORGUNIT_TXT	☐	PIQSTORGTX	TEXT40	CHAR	40	0	Name of the Student's Organizational Unit
72	ASSIGNED_ORGUNIT_SHT	☐	PIQSTORGSHT	TEXT12	CHAR	12	0	Organizational Unit of Student (Abbreviation)
73	.INCLUDE	☐				0	0	Program/Study (Short and Long Texts)
74	.INCLUDE	☐				0	0	Program/Study/Student
75	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	*
76	ST_OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
77	ST_OBJID	☐	PIQST_OBJID	HROBJID	NUMC	8	0	Object ID of Student	*
78	CS_OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
79	CS_OBJID	☐	PIQCSOBJID	HROBJID	NUMC	8	0	Object ID of Study Object (CS)	*
80	SC_OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
81	SC_OBJID	☐	PIQSCOBJID	HROBJID	NUMC	8	0	Program ID	*
82	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
83	ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
84	PRIOX	☐	PIQCSPRIOX	CHAR2	CHAR	2	0	Program Priority (In Period)
85	SC_SHORT	☐	PIQSCSRK	CHAR12	CHAR	12	0	Program of Study
86	SC_STEXT	☐	PIQSCTXT	TEXT40	CHAR	40	0	Program Description
87	.INCLUDE	☐				0	0	Additional Data for Relationship 506
88	SMSTATUS	☐	PIQSMSTATUS	PIQSMSTATUS	NUMC	2	0	Module Booking Status	T7PIQSMSTAT
89	STORREASON	☐	PIQSTORREASON	PIQSTORREASON	CHAR	4	0	Cancellation Reason	T7PIQWITHDRAWN
90	STORDATE	☐	PIQSTORDATE	PIQSTORDATE	DATS	8	0	Cancellation Date
91	CPATTEMP	☐	PIQCPATTEMP	PIQCP	QUAN	10	5	Attempted Credits
92	CPGAINED	☐	PIQCPGAINED	PIQCP	QUAN	10	5	Earned Credits
93	CPUNIT	☐	PIQCPUNIT	MEINS	UNIT	3	0	Unit of Measurement for Credits	T006
94	NORM_VAL	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
95	BOOKDATE	☐	PIQDATE	DATUM	DATS	8	0	Booking Date
96	BOOKTIME	☐	PIQWAITL_TIME	TIME	TIMS	6	0	Booking Time
97	SMRATING	☐	PIQSMRATING	PIQSMRATING	CHAR	3	0	Alternative Assessment Method for Module	T7PIQSMRATING
98	CHARGEFREE	☐	PIQCHARGE	PIQCHARGE	CHAR	1	0	Free of Charge
99	TRANSFERFLAG	☐	PIQTRANSFER	PIQTRANSFER	CHAR	1	0	External Academic Work or Qualification Transferred
100	PACKNUMBER	☐	PIQSLNUM	HROBJID	NUMC	8	0	Event Package	*
101	VARID	☐	PIQVARID	PIQVARID	CHAR	2	0	Session Variant	T7PIQVARY
102	PERID	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	T7PIQPERIOD
103	PERYR	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	T7PIQYEAR
104	ALT_SCALEID	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
105	ID	☐	PIQMODREG_ID	SYSUUID_C	CHAR	32	0	Module Booking Identification
106	BOOKREASON	☐	PIQBOOKREASON	PIQBOOKREASON	CHAR	4	0	Module Booking Reason	T7PIQBOOKREASON
107	ANNULMENT	☐	PIQMODREG_ANNULMENT	PIQMODREG_ANNULMENT	CHAR	1	0	Exclusion Indicator for Module Bookings	T7PIQ_MR_ANNUL
108	LOCKFLAG	☐	PIQAWLOCKFLAG	FLAG	CHAR	1	0	Change Lock
109	COBOK	☐	PIQPEPE_COBOK	PIQPEPE_COBOK	CHAR	1	0	Conditional Booking
110	.INCLUDE	☐				0	0
111	GRADINGSCALET	☐	PIQSCALE_TEXT	PIQSCALE_TEXT	CHAR	30	0	Academic Scale (Description)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQAGR_FINAL_BUFFER	AGROTYPEASG	T778O	OTYPE	REF	1	CN
2	PIQAGR_FINAL_BUFFER	AGRPLVARASG	T778P	PLVAR	REF	1	CN
3	PIQAGR_FINAL_BUFFER	ALT_SCALEID	T7PIQSCALE	SCALEID
4	PIQAGR_FINAL_BUFFER	ANNULMENT	T7PIQ_MR_ANNUL	ANNULMENT
5	PIQAGR_FINAL_BUFFER	BOOKREASON	T7PIQBOOKREASON	BOOKREASON
6	PIQAGR_FINAL_BUFFER	CPUNIT	T006	MSEHI
7	PIQAGR_FINAL_BUFFER	GRADESCALE	T7PIQSCALE	SCALEID	REF	1	CN
8	PIQAGR_FINAL_BUFFER	INFTYASG	T777D	INFTY	REF	1	CN
9	PIQAGR_FINAL_BUFFER	ISTATASG	T778S	ISTAT	REF	1	CN
10	PIQAGR_FINAL_BUFFER	LANGUTXT	T002	SPRAS		1	CN
11	PIQAGR_FINAL_BUFFER	OTYPEAPE	T778O	OTYPE	REF	1	CN
12	PIQAGR_FINAL_BUFFER	OTYPEAPR	T778O	OTYPE	REF	1	CN
13	PIQAGR_FINAL_BUFFER	PERID	T7PIQPERIOD	PERID		1	CN
14	PIQAGR_FINAL_BUFFER	PERYR	T7PIQYEAR	PERYR	KEY	1	CN
15	PIQAGR_FINAL_BUFFER	PLVARAPE	T778P	PLVAR	REF	1	CN
16	PIQAGR_FINAL_BUFFER	PLVARAPR	T778P	PLVAR	REF	1	CN
17	PIQAGR_FINAL_BUFFER	RELATASG	T778V	RELAT	REF	1	CN
18	PIQAGR_FINAL_BUFFER	SCLASASG	T778O	OTYPE
19	PIQAGR_FINAL_BUFFER	SMRATING	T7PIQSMRATING	SMRATING
20	PIQAGR_FINAL_BUFFER	SMSTATUS	T7PIQSMSTAT	SMSTATUS
21	PIQAGR_FINAL_BUFFER	STORREASON	T7PIQWITHDRAWN	STORREASON
22	PIQAGR_FINAL_BUFFER	VARID	T7PIQVARY	VARID	KEY	1	CN

History

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