SAP ABAP Table PIQAGR_TERM_BUFFER (Interim 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_TERM_BUFFER	Table Relationship Diagram
Short Description	Interim 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	.INCLU-BTR	☐				0	0	Buffer Structure for Interim Appraisal
2	.INCLU-TRM	☐				0	0	Transfer Structure for Interim Appraisal
3	AGRIDTRMBTR	☐	PIQAGRID	SYSUUID_C	CHAR	32	0	Appraisal ID
4	AGRSUBTYPTRMBTR	☐	PIQAGRSUBTYP	PIQAGRSUBTYP	NUMC	4	0	Appraisal Type (Obsolete)	*
5	FINAGRIDTRMBTR	☐	PIQAGRID	SYSUUID_C	CHAR	32	0	Appraisal ID
6	.INCLUDE	☐				0	0	Part Appraisal
7	.INCLUDE	☐				0	0	Appraisal Validity
8	AGRBEGDATRMBTR	☐	PIQAGRBEGDA	PIQDATE	DATS	8	0	Start of Appraisal Validity
9	AGRENDDATRMBTR	☐	PIQAGRENDDA	PIQDATE	DATS	8	0	End of Appraisal Validity
10	AGRDATEETRMBTR	☐	PIQAGRDATEE	PIQDATE	DATS	8	0	Earliest Appraisal Date
11	AGRDATELTRMBTR	☐	PIQAGRDATEL	PIQDATE	DATS	8	0	Latest Appraisal Date
12	.INCLUDE	☐				0	0	Grading Information
13	GRADESYMTRMBTR	☐	PIQGRADESYM	PIQGRADESYM	CHAR	10	0	Grade Symbol
14	GRADETRMBTR	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
15	GRADESCALETRMBTR	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
16	AGRNOTRATEDTRMBTR	☐	PIQAGRNOTRATED	PIQAGRNOTRATED	CHAR	1	0	Appraisal Grade Not Relevant
17	AGRDATETRMBTR	☐	PIQAGRDATE	PIQDATE	DATS	8	0	Appraisal Date
18	AGRCOMPLETEDTRMBTR	☐	PIQAGRCOMPLETED	PIQAGRCOMPLETED	CHAR	1	0	Appraisal Completed
19	NOTEIDTRMBTR	☐	PIQNOTE_GUID	SYSUUID_C	CHAR	32	0	GUID - Unique Note Identifier
20	.INCLU-TXT	☐				0	0	Appraisal (Description)
21	AGRIDTXTBTR	☐	PIQAGRID	SYSUUID_C	CHAR	32	0	Appraisal ID
22	.INCLUDE	☐				0	0	Appraisal (Description)
23	LANGUTXTBTR	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
24	AGRTEXTTXTBTR	☐	PIQAGRTEXT	TEXT50	CHAR	50	0	Appraisal (Description)
25	.INCLU-APS	☐				0	0	Appraiser
26	OTYPEAPSBTR	☐	PIQAGR_APPSER_TYPE	OTYPE	CHAR	2	0	Object Type of the Appraiser	T778O
27	REALOAPSBTR	☐	PIQAGR_APPSER_ID	CHAR45	CHAR	45	0	Identification (ID) of the Appraiser
28	PLVARAPSBTR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
29	.INCLU-STD	☐				0	0	Student Information for Appraisal
30	STUDENTNUMBERSTD	☐	PIQSTUDENT12	PIQSTUDENT12	CHAR	12	0	Student Number
31	STUDENTNAMESTD	☐	STEXT	TEXT40	CHAR	40	0	Object Name
32	FIRST_NAMESTD	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
33	LAST_NAMESTD	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
34	PERSIDNOSTD	☐	PIQ_PRDNI	CHAR20	CHAR	20	0	Identification Number
35	NAME_AT_BIRTHSTD	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
36	.INCLUDE	☐				0	0	BAPI Structure for Student: Org. Unit (Text Fields)
37	ASSIGNED_ORGUNITSTD	☐	PIQSTORGUNIT_ASSIGNED	HROBJID	NUMC	8	0	Assigned Organizational Unit of Student	*
38	ASSIGNED_ORGUNIT_TXTSTD	☐	PIQSTORGTX	TEXT40	CHAR	40	0	Name of the Student's Organizational Unit
39	ASSIGNED_ORGUNIT_SHTSTD	☐	PIQSTORGSHT	TEXT12	CHAR	12	0	Organizational Unit of Student (Abbreviation)
40	.INCLUDE	☐				0	0	Program/Study (Short and Long Texts)
41	.INCLUDE	☐				0	0	Program/Study/Student
42	PLVARSTD	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	*
43	ST_OTYPESTD	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
44	ST_OBJIDSTD	☐	PIQST_OBJID	HROBJID	NUMC	8	0	Object ID of Student	*
45	CS_OTYPESTD	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
46	CS_OBJIDSTD	☐	PIQCSOBJID	HROBJID	NUMC	8	0	Object ID of Study Object (CS)	*
47	SC_OTYPESTD	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
48	SC_OBJIDSTD	☐	PIQSCOBJID	HROBJID	NUMC	8	0	Program ID	*
49	BEGDASTD	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
50	ENDDASTD	☐	ENDDATUM	DATUM	DATS	8	0	End Date
51	PRIOXSTD	☐	PIQCSPRIOX	CHAR2	CHAR	2	0	Program Priority (In Period)
52	SC_SHORTSTD	☐	PIQSCSRK	CHAR12	CHAR	12	0	Program of Study
53	SC_STEXTSTD	☐	PIQSCTXT	TEXT40	CHAR	40	0	Program Description
54	.INCLU-ASG	☐				0	0	Appraised Object
55	AGRPLVARASG	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
56	AGROTYPEASG	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
57	AGRREALOASG	☐	REALO	CHAR45	CHAR	45	0	Extended Object ID
58	INFTYASG	☐	INFOTYP	INFOTYP	CHAR	4	0	Infotype	T777D
59	RSIGNASG	☐	RSIGN	RSIGN	CHAR	1	0	Relationship Specification
60	RELATASG	☐	RELAT	RELAT	CHAR	3	0	Relationship Between Objects	T778V
61	ISTATASG	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	T778S
62	PRIOXASG	☐	PRIOX	CHAR2	CHAR	2	0	Priority
63	BEGDAASG	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
64	ENDDAASG	☐	ENDDATUM	DATUM	DATS	8	0	End Date
65	VARYFASG	☐	VARYF	CHAR10	CHAR	10	0	Variation Field for File PLOG
66	SEQNRASG	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
67	SCLASASG	☐	SCLAS	OTYPE	CHAR	2	0	Type of Related Object	T778O
68	SOBIDASG	☐	SOBID	CHAR45	CHAR	45	0	ID of Related Object
69	MODREG_IDASG	☐	PIQMODREG_ID	SYSUUID_C	CHAR	32	0	Module Booking Identification
70	.INCLU-506	☐				0	0	Additional Data for Relationship 506
71	SMSTATUS506	☐	PIQSMSTATUS	PIQSMSTATUS	NUMC	2	0	Module Booking Status	T7PIQSMSTAT
72	STORREASON506	☐	PIQSTORREASON	PIQSTORREASON	CHAR	4	0	Cancellation Reason	T7PIQWITHDRAWN
73	STORDATE506	☐	PIQSTORDATE	PIQSTORDATE	DATS	8	0	Cancellation Date
74	CPATTEMP506	☐	PIQCPATTEMP	PIQCP	QUAN	10	5	Attempted Credits
75	CPGAINED506	☐	PIQCPGAINED	PIQCP	QUAN	10	5	Earned Credits
76	CPUNIT506	☐	PIQCPUNIT	MEINS	UNIT	3	0	Unit of Measurement for Credits	T006
77	NORM_VAL506	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
78	BOOKDATE506	☐	PIQDATE	DATUM	DATS	8	0	Booking Date
79	BOOKTIME506	☐	PIQWAITL_TIME	TIME	TIMS	6	0	Booking Time
80	SMRATING506	☐	PIQSMRATING	PIQSMRATING	CHAR	3	0	Alternative Assessment Method for Module	T7PIQSMRATING
81	CHARGEFREE506	☐	PIQCHARGE	PIQCHARGE	CHAR	1	0	Free of Charge
82	TRANSFERFLAG506	☐	PIQTRANSFER	PIQTRANSFER	CHAR	1	0	External Academic Work or Qualification Transferred
83	PACKNUMBER506	☐	PIQSLNUM	HROBJID	NUMC	8	0	Event Package	*
84	VARID506	☐	PIQVARID	PIQVARID	CHAR	2	0	Session Variant	T7PIQVARY
85	PERID506	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	T7PIQPERIOD
86	PERYR506	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	T7PIQYEAR
87	ALT_SCALEID506	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
88	ID506	☐	PIQMODREG_ID	SYSUUID_C	CHAR	32	0	Module Booking Identification
89	BOOKREASON506	☐	PIQBOOKREASON	PIQBOOKREASON	CHAR	4	0	Module Booking Reason	T7PIQBOOKREASON
90	ANNULMENT506	☐	PIQMODREG_ANNULMENT	PIQMODREG_ANNULMENT	CHAR	1	0	Exclusion Indicator for Module Bookings	T7PIQ_MR_ANNUL
91	LOCKFLAG506	☐	PIQAWLOCKFLAG	FLAG	CHAR	1	0	Change Lock
92	COBOK506	☐	PIQPEPE_COBOK	PIQPEPE_COBOK	CHAR	1	0	Conditional Booking
93	.INCLUDE	☐				0	0
94	GRADINGSCALET	☐	PIQSCALE_TEXT	PIQSCALE_TEXT	CHAR	30	0	Academic Scale (Description)
95	PIQFLAG	☐	PIQAGRFLAG	CHAR01	CHAR	1	0	Indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQAGR_TERM_BUFFER	AGROTYPEASG	T778O	OTYPE	REF	1	CN
2	PIQAGR_TERM_BUFFER	AGRPLVARASG	T778P	PLVAR	REF	1	CN
3	PIQAGR_TERM_BUFFER	ALT_SCALEID506	T7PIQSCALE	SCALEID
4	PIQAGR_TERM_BUFFER	ANNULMENT506	T7PIQ_MR_ANNUL	ANNULMENT
5	PIQAGR_TERM_BUFFER	BOOKREASON506	T7PIQBOOKREASON	BOOKREASON
6	PIQAGR_TERM_BUFFER	CPUNIT506	T006	MSEHI
7	PIQAGR_TERM_BUFFER	GRADESCALETRMBTR	T7PIQSCALE	SCALEID	REF	1	CN
8	PIQAGR_TERM_BUFFER	INFTYASG	T777D	INFTY	REF	1	CN
9	PIQAGR_TERM_BUFFER	ISTATASG	T778S	ISTAT	REF	1	CN
10	PIQAGR_TERM_BUFFER	LANGUTXTBTR	T002	SPRAS		1	CN
11	PIQAGR_TERM_BUFFER	OTYPEAPSBTR	T778O	OTYPE	REF	1	CN
12	PIQAGR_TERM_BUFFER	PERID506	T7PIQPERIOD	PERID		1	CN
13	PIQAGR_TERM_BUFFER	PERYR506	T7PIQYEAR	PERYR	KEY	1	CN
14	PIQAGR_TERM_BUFFER	PLVARAPSBTR	T778P	PLVAR	REF	1	CN
15	PIQAGR_TERM_BUFFER	RELATASG	T778V	RELAT	REF	1	CN
16	PIQAGR_TERM_BUFFER	SCLASASG	T778O	OTYPE
17	PIQAGR_TERM_BUFFER	SMRATING506	T7PIQSMRATING	SMRATING
18	PIQAGR_TERM_BUFFER	SMSTATUS506	T7PIQSMSTAT	SMSTATUS
19	PIQAGR_TERM_BUFFER	STORREASON506	T7PIQWITHDRAWN	STORREASON
20	PIQAGR_TERM_BUFFER	VARID506	T7PIQVARY	VARID	KEY	1	CN

History

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