SAP ABAP Table PIQGRADRECORDS_DLG (Structure for Graduation Data Record (ALV))

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	PIQGRADRECORDS_DLG	Table Relationship Diagram
Short Description	Structure for Graduation Data Record (ALV)

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	Graduation Data Record (Enhanced)
2	.INCLUDE	☐				0	0	Graduation Data Record
3	ST_OBJID	☐	PIQSTUDENT	HROBJID	NUMC	8	0	Object ID of Student	*
4	CS_OBJID	☐	PIQCSOBJID	HROBJID	NUMC	8	0	Object ID of Study Object (CS)	*
5	SC_OBJID	☐	PIQSCOBJID	HROBJID	NUMC	8	0	Program ID	*
6	GRADID	☐	PIQGRADID	SYSUUID_C	CHAR	32	0	Graduation Identification (ID)
7	STATUS	☐	PIQGRAD_STATUS	PIQGRAD_STATUS	CHAR	1	0	Graduation Status
8	.INCLUDE	☐				0	0	Graduation Data Record
9	REGDATE	☐	PIQGRAD_REGDATE	DATUM	DATS	8	0	Activity Key Date for Graduation Registration
10	GRAD_REASON	☐	PIQGRAD_REASON	PIQAPPREASON	NUMC	4	0	Activity Reason	T7PIQREASON
11	CRMNY_DATE	☐	PIQGRAD_CEREMONY_DATE	DATUM	DATS	8	0	Graduation Ceremony Date
12	CRMNY_LOCATION	☐	LOCID	HROBJID	NUMC	8	0	Business Event Location	*
13	CRMNY_BUILDING	☐	BUILD	BUILD	CHAR	8	0	Building	T777A
14	CRMNY_ROOM	☐	ROMID	HROBJID	NUMC	8	0	Room	PLOGI
15	CRMNY_BEGTIME	☐	BEGUZ	UZEIT	TIMS	6	0	Start Time
16	CRMNY_ENDTIME	☐	ENDUZ	UZEIT	TIMS	6	0	End Time
17	CRMNY_SEATNO	☐	PIQGRAD_CEREMONY_SEATNO	CHAR10	CHAR	10	0	Seat Number
18	CRMNY_CATEGORY	☐	PIQGRAD_CEREMONY_CATEGORY	PIQGRAD_CEREMONY_CATEGORY	CHAR	4	0	Graduation Ceremony Characteristic	T7PIQGRADCRMYCAT
19	CRMNY_PUBLISH	☐	PIQGRAD_CEREMONY_PUBLISH	FLAG	CHAR	1	0	Publication Permission
20	.INCLUDE	☐				0	0	Graduation Data Record (Texts)
21	REASON_TXT	☐	PIQREASONT	TEXT25	CHAR	25	0	Reason Description
22	STATUS_TXT	☐	PIQGRAD_STATUS_TXT	TEXT40	CHAR	40	0	Graduation Status (Description)
23	LOCATION_SHORT	☐	PIQLOCATION_SHORT	TEXT12	CHAR	12	0	Location (Abbreviation)
24	LOCATION_STEXT	☐	PIQLOCATION_STEXT	TEXT40	CHAR	40	0	Location Description (Personnel Planning Object)
25	BUILD_STEXT	☐	PIQBUILD_STEXT	TEXT40	CHAR	40	0	Building (Description)
26	ROOM_SHORT	☐	ROSHRT	TEXT12	CHAR	12	0	Short Name of Room
27	ROOM_STEXT	☐	ROSTEX	TEXT40	CHAR	40	0	Name of Room
28	CRMNY_CATEGORY_TXT	☐	PIQGRAD_CEREMONY_CATEGORYT	TEXT40	CHAR	40	0	Graduation Ceremony Characteristic (Description)
29	ST_NUMBER	☐	PIQSTUDENT12	PIQSTUDENT12	CHAR	12	0	Student Number
30	ST_NAME	☐	PIQSTUDENTNAME	TEXT40	CHAR	40	0	Student Name
31	SC_SHORT	☐	PIQSCSHORT	TEXT12	CHAR	12	0	Program (Abbreviation)
32	SC_STEXT	☐	PIQSCTXT	TEXT40	CHAR	40	0	Program Description
33	.INCLUDE	☐				0	0	Structure: Assessment Process (Attributes)
34	CMPR_ID	☐	PIQCMPR_GUID	SYSUUID_C	CHAR	32	0	Assessment Process Identification (ID)
35	PERYR	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	T7PIQYEAR
36	PERID	☐	PIQCMPR_PERID	PIQPERID	NUMC	3	0	Assessment Session	*
37	OFFERNO	☐	PIQEVOBOFFNO		NUMC	3	0	Scheduled Assessment Number
38	STATUS1	☐	PIQCMPR_STAT1	PIQCMPR_STAT1	CHAR	2	0	System Status (Assessment Process)	T7PIQCMPRSTAT1
39	STATUS2	☐	PIQCMPR_STAT2	PIQCMPR_STAT2	CHAR	4	0	Customer Status (Assessment Process)	T7PIQCMPRSTAT2
40	REASON	☐	PIQCMPR_REASON	PIQCMPR_REASON	CHAR	4	0	Reason for Assessment Process	T7PIQCMPR_REASON
41	ADMIS_PROFILE	☐	PIQAUDF_ID	SYSUUID_C	CHAR	32	0	Requirement Profile Identifier (ID)
42	ADMIS_RUNID	☐	PIQAUDR_ID	SYSUUID_C	CHAR	32	0	Audit ID
43	COMPL_PROFILE	☐	PIQAUDF_ID	SYSUUID_C	CHAR	32	0	Requirement Profile Identifier (ID)
44	COMPL_RUNID	☐	PIQAUDR_ID	SYSUUID_C	CHAR	32	0	Audit ID
45	GUIDTYPE	☐	PIQCMPR_GUIDTYPE	PIQGUIDTYPE	CHAR	4	0	Unique Identification Type (GUID)	*
46	GUID	☐	PIQCMPR_GUIDREF	SYSUUID_C	CHAR	32	0	Unique Key (ID)
47	.INCLUDE	☐				0	0	Assessment Process (Descriptions)
48	PERYRT	☐	PIQPERYT	TEXT20	CHAR	20	0	Academic Year (Description)
49	PERIDT	☐	PIQPERIT	TEXT20	CHAR	20	0	Academic Session (Description)
50	STAT1_TEXT	☐	PIQCMPR_STAT1_TXT	TEXT30	CHAR	30	0	System Status (Description)
51	STAT2_TEXT	☐	PIQCMPR_STAT2_TXT	TEXT30	CHAR	30	0	Customer Status (Description)
52	REASONT	☐	PIQCMPR_REASONT	TEXT40	CHAR	40	0	Reason for Assessment Process (Description)
53	.INCLUDE	☐				0	0	Qualification Conferment (Extended)
54	.INCLUDE	☐				0	0	Qualification Conferment
55	STUDENT_ID	☐	PIQSTUDENT	HROBJID	NUMC	8	0	Object ID of Student	*
56	NORMVAL	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
57	GRADESYMBOL	☐	PIQGRADESYM	PIQGRADESYM	CHAR	10	0	Grade Symbol
58	SCALE	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
59	CQNOTE	☐	PIQNOTE_GUID	SYSUUID_C	CHAR	32	0	GUID - Unique Note Identifier
60	CONF_COMMENT	☐	PIQCONFERQ_COMMENT	TEXT50	CHAR	50	0	Comment Regarding Qualification
61	CONFER_DATE	☐	PIQCONFERQ_DATE		DATS	8	0	Date of Qualification Conferment
62	AYEAR	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	T7PIQYEAR
63	APERIOD	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	T7PIQPERIOD
64	VALID_FROM	☐	PIQCONFERQ_VALID_FROM		DATS	8	0	Validity Start Date of Qualification Conferment
65	VALID_TO	☐	PIQCONFERQ_VALID_TO		DATS	8	0	Validity End Date of Qualification Conferment
66	TRANSFERRED	☐	PIQTRANSFER	PIQTRANSFER	CHAR	1	0	External Academic Work or Qualification Transferred
67	CQ_ID	☐	PIQCQOBJID	HROBJID	NUMC	8	0	Internal Qualification Identification (ID)	*
68	PERIDFORCQ	☐	PIQCONFERQ_PERIDFORCQ	PIQPERCT	NUMC	3	0	Duration of Study Required to Achieve Qualification
69	PERIDFORCQUNIT	☐	PIQCONFERQ_PERIDFORCQUNIT	PIQCONFERQ_PERIDFORCQUNIT	CHAR	1	0	Unit for Number of Periods
70	.INCLUDE	☐				0	0	Objects Referenced for Qualification Conferment
71	REFOBJ_OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
72	REFOBJ_REALO	☐	SOBID	CHAR45	CHAR	45	0	ID of Related Object
73	.INCLUDE	☐				0	0
74	COBOK	☐	PIQPEPE_COBOK	PIQPEPE_COBOK	CHAR	1	0	Conditional Booking
75	STAGE	☐	PIQLEVEL	PIQLEVEL	NUMC	2	0	Stage	*
76	REFPROC_GUIDTYPE	☐	PIQCONFERQ_REFPROC_GUIDTYPE	PIQGUIDTYPE	CHAR	4	0	Reference to a Process	T7PIQGUIDTYPE
77	REFPROC_GUID	☐	PIQCONFERQ_REFPROC_GUID	SYSUUID_C	CHAR	32	0	Process Identification (ID)
78	DIPLOMANAME	☐	PIQCONFERQ_DIPLOMANAME	TEXT80	CHAR	80	0	Diploma Name
79	FINALW_ID	☐	PIQCONFERQ_FINALW_ID	SYSUUID_C	CHAR	32	0	Module Booking ID of Individual Work
80	FINALW_TITLE	☐	PIQCONFERQ_FINALWTITLE	TEXT100	CHAR	100	0	Title of Qualifying Work
81	FINALW_LANGU	☐	PIQCONFERQ_FINALWLANGU	SPRAS	LANG	1	0	Original Language	T002
82	FINALW_TITLEALT	☐	PIQCONFERQ_FINALWTITLEALT	TEXT100	CHAR	100	0	Title of Qualifying Work in Other Language
83	FINALW_LANGUALT	☐	PIQCONFERQ_FINALWLANGUALT	SPRAS	LANG	1	0	Other Language	T002
84	ACADHONOR_SYM	☐	PIQCONFERQ_ACADHONOR_GRADESYM	PIQGRADESYM	CHAR	10	0	Academic Honors
85	ACADHONOR_GRADE	☐	PIQCONFERQ_ACADHONOR_GRADE	PIQSCALE_NORM_VAL	DEC	8	2	Academic Honors: Standard Value
86	ACADHONOR_SCALE	☐	PIQCONFERQ_ACADHONOR_SCALE	PIQSCALE_ID	CHAR	4	0	Academic Honors Scale	T7PIQSCALE
87	NOT_COMPLETED	☐	PIQCONFERQ_NOTCOMPL	PIQCONFERQ_NOTCOMPL	CHAR	1	0	Qualification Was Not Achieved
88	CQSHORT	☐	PIQCQ_SHORT	TEXT12	CHAR	12	0	Internal Qualification
89	CQSTEXT	☐	PIQCQ_STEXT	TEXT40	CHAR	40	0	Internal Qualification (Description)
90	REFOBJSHORT	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
91	REFOBJSTEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
92	ID	☐	PIQAGRID	SYSUUID_C	CHAR	32	0	Appraisal ID
93	PERIDFORCQUNITTXT	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
94	AYEARTXT	☐	PIQPERYT	TEXT20	CHAR	20	0	Academic Year (Description)
95	APERIODTXT	☐	PIQPERIT	TEXT20	CHAR	20	0	Academic Session (Description)
96	STAGETXT	☐	PIQLEVELT	TEXT30	CHAR	30	0	Stage (Description)
97	CESHORT	☐	PIQEVOB_SHORT	TEXT12	CHAR	12	0	Assessment (Identifier)
98	CESTEXT	☐	PIQEVOB_STEXT	TEXT40	CHAR	40	0	Assessment (Description)
99	STATUS1ADD	☐	PIQCMPR_STAT1_TXT	TEXT30	CHAR	30	0	System Status (Description)
100	ICON_STATOFFERADD	☐	PIQCMPR_ICONSTATUSOFFER	TEXT35	CHAR	35	0	Process Status
101	ICON_ENQUEUE	☐	PIQCMPR_ICONENQUEUE	TEXT35	CHAR	35	0	Lock (Icon)
102	ADM_PROF_ICON	☐	PIQCMPR_ADM_PROF_ICON	TEXT35	CHAR	35	0	Admission Profile for Assessment Process (Icon)
103	ADM_RUN_ICON	☐	PIQCMPR_ADM_RUN_ICON	TEXT35	CHAR	35	0	Admission Run for Assessment Process (Icon)
104	COM_PROF_ICON	☐	PIQCMPR_COM_PROF_ICON	TEXT35	CHAR	35	0	Completion Profile for Assessment Process (Icon)
105	COM_RUN_ICON	☐	PIQCMPR_COM_RUN_ICON	TEXT35	CHAR	35	0	Completion Run for Assessment Process (Icon)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQGRADRECORDS_DLG	ACADHONOR_SCALE	T7PIQSCALE	SCALEID
2	PIQGRADRECORDS_DLG	APERIOD	T7PIQPERIOD	PERID
3	PIQGRADRECORDS_DLG	AYEAR	T7PIQYEAR	PERYR
4	PIQGRADRECORDS_DLG	CRMNY_BUILDING	T777A	BUILD
5	PIQGRADRECORDS_DLG	CRMNY_CATEGORY	T7PIQGRADCRMYCAT	CATEGORY
6	PIQGRADRECORDS_DLG	CRMNY_ROOM	PLOGI	OBJID
7	PIQGRADRECORDS_DLG	FINALW_LANGU	T002	SPRAS
8	PIQGRADRECORDS_DLG	FINALW_LANGUALT	T002	SPRAS
9	PIQGRADRECORDS_DLG	GRAD_REASON	T7PIQREASON	REASON
10	PIQGRADRECORDS_DLG	PERYR	T7PIQYEAR	PERYR
11	PIQGRADRECORDS_DLG	REASON	T7PIQCMPR_REASON	REASON
12	PIQGRADRECORDS_DLG	REFPROC_GUIDTYPE	T7PIQGUIDTYPE	TYPE
13	PIQGRADRECORDS_DLG	SCALE	T7PIQSCALE	SCALEID
14	PIQGRADRECORDS_DLG	STATUS1	T7PIQCMPRSTAT1	STATUS1	KEY	1	CN
15	PIQGRADRECORDS_DLG	STATUS2	T7PIQCMPRSTAT2	STATUS2	KEY	1	CN

History

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