SAP ABAP Table PIQ_STUDENTLDB_STUDIES (Admission Data for Logical Database RHIQ_STUDENT_LDB)

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	PIQ_STUDENTLDB_STUDIES	Table Relationship Diagram
Short Description	Admission Data for Logical Database RHIQ_STUDENT_LDB

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	Admission: Structure for Admission Application
2	.INCLUDE	☐				0	0	Admission: Application Key
3	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	*
4	ST_OBJID	☐	PIQSTUDENT	HROBJID	NUMC	8	0	Object ID of Student	*
5	CS_OBJID	☐	PIQCSOBJID	HROBJID	NUMC	8	0	Object ID of Study Object (CS)	*
6	SC_OBJID	☐	PIQSCOBJID	HROBJID	NUMC	8	0	Program ID	*
7	BEGDA	☐	PIQ_BEGDA	DATUM	DATS	8	0	Valid-From Date
8	ENDDA	☐	PIQ_ENDDA	DATUM	DATS	8	0	Valid-To Date
9	ISTAT	☐	PIQADMSTATE	PIQADMSTATE	CHAR	1	0	Admission Application Status
10	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
11	.INCLUDE	☐				0	0	Additional Relationship Data
12	CHOICE_NO	☐	PIQCHOICE_NO	PIQCHOICE_NO	NUMC	2	0	Program Choice	*
13	ADM_AYEAR	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	*
14	ADM_PERID	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	*
15	ADM_ACLEVEL	☐	PIQLEVEL	PIQLEVEL	NUMC	2	0	Stage	*
16	ADM_PROGCLASS	☐	PIQPROGCLASS	PIQPROGCLASS	CHAR	4	0	Progress Classification	*
17	ADM_PARTT	☐	PIQPARTT	XFELD	CHAR	1	0	Indicator: Part-Time Study
18	ADM_CATEG	☐	PIQADM_CATEG	PIQADM_CATEG	CHAR	2	0	Admission Category	*
19	ADM_ENRCATEG	☐	PIQENRCATEG	PIQENRCATEG	CHAR	2	0	Registration Type	*
20	ADM_CODE	☐	PIQADMCODE	CHAR12	CHAR	12	0	Admission Code
21	ADM_PERCT	☐	PIQPERCT	PIQPERCT	NUMC	3	0	Completed Length of Study
22	ADM_QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	*
23	ADM_STATUS_SUP	☐	PIQADMSTSUP	PIQPROCESSSTSUP	CHAR	4	0	Status Supplement
24	ADM_DEC	☐	PIQADM_DEC	DATS	DATS	8	0	Decision Date of Rejection or Admission
25	ADM_RECPT	☐	PIQADM_RECPT	DATS	DATS	8	0	Date of Admission Application Receipt
26	ADM_WITH_DECL	☐	PIQADM_WITH_DECL	DATS	DATS	8	0	Date of Withdrawal or Declination
27	ADM_GUID	☐	PIQADM_GUID	SYSUUID_C	CHAR	32	0	Unique Key (GUID) of the Admission
28	COKEY	☐	COKEY_KK	COKEY_KK	CHAR	36	0	Correspondence key
29	.INCLUDE	☐				0	0
30	.INCLUDE	☐				0	0	Data on Start of Study Segment
31	BEG_PROCESS	☐	PIQPROCESS_BEG	PIQPROCESS	CHAR	4	0	Activity for Program Registration	*
32	BEG_REASON	☐	PIQPROCREASON	PIQAPPREASON	NUMC	4	0	Activity Reason	*
33	BEG_KEY_DATE	☐	PIQREGDATE	DATUM	DATS	8	0	Activity Key Date for Start of Study Segment
34	.INCLUDE	☐				0	0	Data on End of Study Segment
35	END_PROCESS	☐	PIQPROCESS_END	PIQPROCESS	CHAR	4	0	Activity for De-registration from Program	*
36	END_REASON	☐	PIQDERREASON	PIQAPPREASON	NUMC	4	0	De-registration Reason	*
37	END_KEY_DATE	☐	PIQDERDATE	DATUM	DATS	8	0	Activity Key Date of De-registration
38	.INCLUDE	☐				0	0	Program Data
39	VARID	☐	PIQVARID	PIQVARID	CHAR	2	0	Session Variant	T7PIQVARY
40	ACLEVELVAR	☐	PIQLEVELVAR	PIQLEVELVAR	CHAR	2	0	Program Plan	*
41	OPTLENGTH	☐	PIQLENGTH	PIQLENGTH	NUMC	4	0	Program Duration
42	MAXLENGTH	☐	PIQLENGTHMAX	PIQLENGTH	NUMC	4	0	Maximum Program Duration
43	TIMEUNIT	☐	PIQTIMEUNIT	PIQTIMEUNIT	NUMC	2	0	Time Unit for Program Duration	T7PIQTIMEUNIT
44	RESTRICTED	☐	PIQRESTRICTED	PIQRESTRICTED	CHAR	1	0	Indicator: Admission Restricted
45	FULLTPARTT	☐	PIQFULLTPARTT	PIQFULLTPARTT	CHAR	1	0	Full-Time/Part-Time Indicator for Program
46	GRPVAR	☐	PIQSCCGVAR	PIQSCCGVAR	NUMC	3	0	Module Group Variant for Program	T7PIQSC_CGVAR
47	PROGCVAR	☐	PIQPROGC_VAR	PIQPROGC_VAR	CHAR	4	0	Program Type	T7PIQPROGCVAR
48	ASSPROC	☐	PIQADM_ASSPROC	FLAG	CHAR	1	0	Use Assessment Process
49	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQ_STUDENTLDB_STUDIES	GRPVAR	T7PIQSC_CGVAR	GRPVAR		1	CN
2	PIQ_STUDENTLDB_STUDIES	PROGCVAR	T7PIQPROGCVAR	PROGC_VAR
3	PIQ_STUDENTLDB_STUDIES	TIMEUNIT	T7PIQTIMEUNIT	TIMEUNIT
4	PIQ_STUDENTLDB_STUDIES	VARID	T7PIQVARY	VARID		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in