SAP ABAP Table PIQAGR_APPRAISAL_BUFFER (Appraisal Buffer Table)

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_APPRAISAL_BUFFER	Table Relationship Diagram
Short Description	Appraisal Buffer Table

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	INDX	☐	PIQAGRLFNR	INT4	INT4	10	0	Sequence Number
2	.INCLUDE	☐				0	0	Structure for Calculation Status Display (Appraisal)
3	ICON_RESULT	☐	PIQAGR_ICONRESULT	CHAR35	CHAR	35	0	Result Origin (Icon)
4	VALUE_RESULT	☐	PIQAGR_VALUERESULT	NUMC1	NUMC	1	0	Result Value
5	ICON_CALCULATION	☐	PIQAGR_ICON_CALCULATION	CHAR35	CHAR	35	0	Degree of Reliability (Icon)
6	VALUE_CALCULATION	☐	PIQAGR_VALUECALCULATION	NUMC1	NUMC	1	0	Calculation Status
7	ICON_LOCK	☐	PIQAGR_ICONLOCK	CHAR35	CHAR	35	0	Calculation Lock (Icon)
8	VALUE_LOCK	☐	PIQAGR_LOCK	NUMC1	NUMC	1	0	Calculation Lock
9	.INCLUDE	☐				0	0	Student Information for Appraisal
10	STUDENTNUMBER	☐	PIQSTUDENT12	PIQSTUDENT12	CHAR	12	0	Student Number
11	STUDENTNAME	☐	STEXT	TEXT40	CHAR	40	0	Object Name
12	FIRST_NAME	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
13	LAST_NAME	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
14	PERSIDNO	☐	PIQ_PRDNI	CHAR20	CHAR	20	0	Identification Number
15	NAME_AT_BIRTH	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
16	.INCLUDE	☐				0	0	BAPI Structure for Student: Org. Unit (Text Fields)
17	ASSIGNED_ORGUNIT	☐	PIQSTORGUNIT_ASSIGNED	HROBJID	NUMC	8	0	Assigned Organizational Unit of Student	*
18	ASSIGNED_ORGUNIT_TXT	☐	PIQSTORGTX	TEXT40	CHAR	40	0	Name of the Student's Organizational Unit
19	ASSIGNED_ORGUNIT_SHT	☐	PIQSTORGSHT	TEXT12	CHAR	12	0	Organizational Unit of Student (Abbreviation)
20	.INCLUDE	☐				0	0	Program/Study (Short and Long Texts)
21	.INCLUDE	☐				0	0	Program/Study/Student
22	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	*
23	ST_OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
24	ST_OBJID	☐	PIQST_OBJID	HROBJID	NUMC	8	0	Object ID of Student	*
25	CS_OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
26	CS_OBJID	☐	PIQCSOBJID	HROBJID	NUMC	8	0	Object ID of Study Object (CS)	*
27	SC_OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
28	SC_OBJID	☐	PIQSCOBJID	HROBJID	NUMC	8	0	Program ID	*
29	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
30	ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
31	PRIOX	☐	PIQCSPRIOX	CHAR2	CHAR	2	0	Program Priority (In Period)
32	SC_SHORT	☐	PIQSCSRK	CHAR12	CHAR	12	0	Program of Study
33	SC_STEXT	☐	PIQSCTXT	TEXT40	CHAR	40	0	Program Description
34	.INCLUDE	☐				0	0	Appraisal Buffer Structure
35	.INCLUDE	☐				0	0	Program Description
36	STUDY	☐	PIQAGRSTUDEY	CHAR40	CHAR	40	0	Program
37	.INCLUDE	☐				0	0	Grading Scale Description
38	GRADESCALET	☐	PIQSCALE_TEXT	PIQSCALE_TEXT	CHAR	30	0	Academic Scale (Description)
39	.INCLUDE	☐				0	0	Appraisal
40	AGRID	☐	PIQAGRID	SYSUUID_C	CHAR	32	0	Appraisal ID
41	.INCLUDE	☐				0	0	Appraisal: Administration Data
42	ATTNO	☐	PIQAGR_ATTNO	NUM03	NUMC	3	0	Repetition Attempt Number
43	AGRTYPE	☐	PIQAGRTYPE	PIQAGRTYPE	NUMC	4	0	Appraisal Type	T7PIQAGR_TYPE
44	AGRSTAT	☐	PIQAGRSTAT	PIQAGRSTAT	CHAR	5	0	Appraisal Status	T7PIQAGRC_STAT
45	ARCH_STATUS	☐	PIQAGR_ARCH_STATUS	PIQAGR_ARCH_STATUS	CHAR	1	0	Appraisal Archiving Status
46	AGRREMARK	☐	PIQAGRREMARK	PIQAGRREMARK	CHAR	2	0	Appraisal Remark	*
47	AYEAR	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	T7PIQYEAR
48	APERIOD	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	T7PIQPERIOD
49	.INCLUDE	☐				0	0	Appraisal Validity
50	AGRBEGDA	☐	PIQAGRBEGDA	PIQDATE	DATS	8	0	Start of Appraisal Validity
51	AGRENDDA	☐	PIQAGRENDDA	PIQDATE	DATS	8	0	End of Appraisal Validity
52	AGRDATEE	☐	PIQAGRDATEE	PIQDATE	DATS	8	0	Earliest Appraisal Date
53	AGRDATEL	☐	PIQAGRDATEL	PIQDATE	DATS	8	0	Latest Appraisal Date
54	.INCLUDE	☐				0	0	Appraisal Relationship Information
55	AGRWEIGHT	☐	PIQAGRWEIGHT	PIQAGRWEIGHT	DEC	5	2	Appraisal Weighting
56	UPAGRID	☐	PIQAGRID	SYSUUID_C	CHAR	32	0	Appraisal ID	PIQDBAGR_GEN
57	.INCLUDE	☐				0	0	Grading Information
58	GRADESYM	☐	PIQGRADESYM	PIQGRADESYM	CHAR	10	0	Grade Symbol
59	GRADE	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
60	GRADESCALE	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
61	AGRNOTRATED	☐	PIQAGRNOTRATED	PIQAGRNOTRATED	CHAR	1	0	Appraisal Grade Not Relevant
62	AGRDATE	☐	PIQAGRDATE	PIQDATE	DATS	8	0	Appraisal Date
63	AGRCOMPLETED	☐	PIQAGRCOMPLETED	PIQAGRCOMPLETED	CHAR	1	0	Appraisal Completed
64	NOTEID	☐	PIQNOTE_GUID	SYSUUID_C	CHAR	32	0	GUID - Unique Note Identifier
65	.INCLU-TXT	☐				0	0	Appraisal (Description)
66	AGRIDTXT	☐	PIQAGRID	SYSUUID_C	CHAR	32	0	Appraisal ID
67	.INCLUDE	☐				0	0	Appraisal (Description)
68	LANGUTXT	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
69	AGRTEXTTXT	☐	PIQAGRTEXT	TEXT50	CHAR	50	0	Appraisal (Description)
70	.INCLU-APE	☐				0	0	Appraisee
71	OTYPEAPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
72	REALOAPE	☐	REALO	CHAR45	CHAR	45	0	Extended Object ID
73	PLVARAPE	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
74	.INCLU-ASG	☐				0	0	Appraised Object
75	AGRPLVARASG	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
76	AGROTYPEASG	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
77	AGRREALOASG	☐	REALO	CHAR45	CHAR	45	0	Extended Object ID
78	INFTYASG	☐	INFOTYP	INFOTYP	CHAR	4	0	Infotype	T777D
79	RSIGNASG	☐	RSIGN	RSIGN	CHAR	1	0	Relationship Specification
80	RELATASG	☐	RELAT	RELAT	CHAR	3	0	Relationship Between Objects	T778V
81	ISTATASG	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	T778S
82	PRIOXASG	☐	PRIOX	CHAR2	CHAR	2	0	Priority
83	BEGDAASG	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
84	ENDDAASG	☐	ENDDATUM	DATUM	DATS	8	0	End Date
85	VARYFASG	☐	VARYF	CHAR10	CHAR	10	0	Variation Field for File PLOG
86	SEQNRASG	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
87	SCLASASG	☐	SCLAS	OTYPE	CHAR	2	0	Type of Related Object	T778O
88	SOBIDASG	☐	SOBID	CHAR45	CHAR	45	0	ID of Related Object
89	MODREG_IDASG	☐	PIQMODREG_ID	SYSUUID_C	CHAR	32	0	Module Booking Identification
90	.INCLU-APR	☐				0	0	Appraiser (Functions)
91	SEQNRAPR	☐	PIQAGR_FUNC_SEQNR	PIQSEQNR	NUMC	3	0	Sequence Number of Function
92	.INCLUDE	☐				0	0	Appraiser
93	OTYPEAPR	☐	PIQAGR_APPSER_TYPE	OTYPE	CHAR	2	0	Object Type of the Appraiser	T778O
94	REALOAPR	☐	PIQAGR_APPSER_ID	CHAR45	CHAR	45	0	Identification (ID) of the Appraiser
95	PLVARAPR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
96	FUNCTIONAPR	☐	PIQAGR_APPFUNCTION	PIQAGR_APPFUNCTION	CHAR	4	0	Function Exercised (Abbreviation	*
97	.INCLU-FOL	☐				0	0	Appraisal Additional Data
98	CPATTEMPFOL	☐	PIQCPATTEMP	PIQCP	QUAN	10	5	Attempted Credits
99	CPEARNEDFOL	☐	PIQCPEARNED	PIQCP	QUAN	10	5	Earned Credits
100	CPGRADEDFOL	☐	PIQCPGRADED	PIQCP	QUAN	10	5	Graded Credits
101	CPUNITFOL	☐	PIQCPUNIT	MEINS	UNIT	3	0	Unit of Measurement for Credits	*
102	.INCLUDE	☐				0	0
103	AGRSTATTEXT	☐	PIQAGRSTATTEXT	TEXT30	CHAR	30	0	Appraisal Status (Description)
104	AGRREMARKTEXT	☐	PIQAGRREMARKTEXT	TEXT35	CHAR	35	0	Appraisal Remark (Description)
105	.INCLUDE	☐				0	0	Additional Data for Relationship 506
106	SMSTATUS	☐	PIQSMSTATUS	PIQSMSTATUS	NUMC	2	0	Module Booking Status	T7PIQSMSTAT
107	STORREASON	☐	PIQSTORREASON	PIQSTORREASON	CHAR	4	0	Cancellation Reason	T7PIQWITHDRAWN
108	STORDATE	☐	PIQSTORDATE	PIQSTORDATE	DATS	8	0	Cancellation Date
109	CPATTEMP	☐	PIQCPATTEMP	PIQCP	QUAN	10	5	Attempted Credits
110	CPGAINED	☐	PIQCPGAINED	PIQCP	QUAN	10	5	Earned Credits
111	CPUNIT	☐	PIQCPUNIT	MEINS	UNIT	3	0	Unit of Measurement for Credits	T006
112	NORM_VAL	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
113	BOOKDATE	☐	PIQDATE	DATUM	DATS	8	0	Booking Date
114	BOOKTIME	☐	PIQWAITL_TIME	TIME	TIMS	6	0	Booking Time
115	SMRATING	☐	PIQSMRATING	PIQSMRATING	CHAR	3	0	Alternative Assessment Method for Module	T7PIQSMRATING
116	CHARGEFREE	☐	PIQCHARGE	PIQCHARGE	CHAR	1	0	Free of Charge
117	TRANSFERFLAG	☐	PIQTRANSFER	PIQTRANSFER	CHAR	1	0	External Academic Work or Qualification Transferred
118	PACKNUMBER	☐	PIQSLNUM	HROBJID	NUMC	8	0	Event Package	*
119	VARID	☐	PIQVARID	PIQVARID	CHAR	2	0	Session Variant	T7PIQVARY
120	PERID	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	T7PIQPERIOD
121	PERYR	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	T7PIQYEAR
122	ALT_SCALEID	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
123	ID	☐	PIQMODREG_ID	SYSUUID_C	CHAR	32	0	Module Booking Identification
124	BOOKREASON	☐	PIQBOOKREASON	PIQBOOKREASON	CHAR	4	0	Module Booking Reason	T7PIQBOOKREASON
125	ANNULMENT	☐	PIQMODREG_ANNULMENT	PIQMODREG_ANNULMENT	CHAR	1	0	Exclusion Indicator for Module Bookings	T7PIQ_MR_ANNUL
126	LOCKFLAG	☐	PIQAWLOCKFLAG	FLAG	CHAR	1	0	Change Lock
127	COBOK	☐	PIQPEPE_COBOK	PIQPEPE_COBOK	CHAR	1	0	Conditional Booking
128	.INCLUDE	☐				0	0
129	SMSTATUST	☐	PIQSMSTATUST	TEXT25	CHAR	25	0	Module Booking Status (Description)
130	SMRATINGT	☐	PIQSMRATINGT	PIQSMRATINGT	CHAR	40	0	Alternative Assessment Method for Module (Description)
131	PUSHNOTES	☐	PIQAGRPUSHNOTES	CHAR30	CHAR	30	0	Notes
132	GRADESUM	☐	QUAN1	MENG8	QUAN	15	3	Quantity
133	PIQFLAG	☐	PIQAGRFLAG	CHAR01	CHAR	1	0	Indicator
134	SUBTYPTERM	☐	PIQAGRSUBTYP	PIQAGRSUBTYP	NUMC	4	0	Appraisal Type (Obsolete)
135	LFNR	☐	PIQAGRLFNR	INT4	INT4	10	0	Sequence Number
136	REFINDX	☐	PIQAGRLFNR	INT4	INT4	10	0	Sequence Number
137	ICONATTNO	☐	PIQAGR_ICONATTNO	CHAR35	CHAR	35	0	Repetition Attempt (Icon)
138	ICONCOBOK	☐	PIQAGR_ICONCOBOK	TEXT35	CHAR	35	0	Conditional Booking (Icon)
139	GRADETEXT	☐	PIQSCALE_GRADETEXT	PIQSCALE_GRADETEXT	CHAR	20	0	Scale Value (Description)
140	APPSERTEXT	☐	PIQAGR_APPSER_TXT	TEXT50	CHAR	50	0	Name of Appraiser

Foreign Keys

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

History

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