SAP ABAP Table PIQSTREG (Student: Registrations)

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	PIQSTREG	Table Relationship Diagram
Short Description	Student: Registrations

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	Student: Structure for Registration Data (Read Modules)
2	ST_OBJID	☐	PIQSTUDENT	HROBJID	NUMC	8	0	Object ID of Student	*
3	CS_OBJID	☐	PIQCSOBJID	HROBJID	NUMC	8	0	Object ID of Study Object (CS)	*
4	SC_OBJID	☐	PIQSCOBJID	HROBJID	NUMC	8	0	Program ID	*
5	CS_PRIOX	☐	PIQCSPRIOX	CHAR2	CHAR	2	0	Program Priority (In Period)
6	APPTYPE	☐	NUSED4	CHAR4	CHAR	4	0	Reserved field/unused field of length 4
7	BEGDA	☐	PIQ_BEGDA	DATUM	DATS	8	0	Valid-From Date
8	ENDDA	☐	PIQ_ENDDA	DATUM	DATS	8	0	Valid-To Date
9	PERYR	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	T7PIQYEARPRD
10	PERID	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	T7PIQYEARPRD
11	ACLEVEL	☐	PIQLEVEL	PIQLEVEL	NUMC	2	0	Stage	T7PIQLEVPERVAR
12	REGDATE	☐	PIQREGPERDATE	DATUM	DATS	8	0	Activity Key Date for Sessional Registration
13	PARTT	☐	PIQPARTT	XFELD	CHAR	1	0	Indicator: Part-Time Study
14	REG_APPTYPE	☐	NUSED4	CHAR4	CHAR	4	0	Reserved field/unused field of length 4
15	LEAVE_REASON	☐	PIQLEAREASON	PIQAPPREASON	NUMC	4	0	Leave of Absence Reason	*
16	FEEFL	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
17	PERCT	☐	PIQPERCT	PIQPERCT	NUMC	3	0	Completed Length of Study
18	APPREASON	☐	PIQNUSED_NUMC4	NUMC4	NUMC	4	0	Unused Field (NUMC4)
19	PROGCLASS	☐	NUSED4	CHAR4	CHAR	4	0	Reserved field/unused field of length 4	*
20	ENRCATEG	☐	PIQENRCATEG	PIQENRCATEG	CHAR	2	0	Registration Type	T7PIQENRCATEG
21	PR_STATUS	☐	PIQREG_PERIODSTATUS	PIQREG_PERIODSTATUS	CHAR	1	0	Sessional Registration Status
22	PRS_STATE	☐	PIQREG_PRS_STATE	PIQHS_STATE	CHAR	1	0	Sessional Registration Status Specification
23	REGCLASS	☐	PIQREGCLASS	PIQREGCLASS	CHAR	2	0	Registration Classification	T7PIQREGCLASS
24	CANCPROCESS	☐	PIQREGCANCPROCESS	PIQPROCESS	CHAR	4	0	Cancellation Activity (For Registration)	*
25	CANCREASON	☐	PIQREGCANCREASON	PIQAPPREASON	NUMC	4	0	Cancellation Reason (For Registration)	*
26	CANCDATE	☐	PIQREGCANCDATE	DATUM	DATS	8	0	Cancellation Date (Registration)
27	.INCLUDE	☐				0	0	Student: Display Fields for Re-registration
28	STUDENT12	☐	PIQSTUDENT12	PIQSTUDENT12	CHAR	12	0	Student Number
29	ST_STEXT	☐	PIQSTDTX	TEXT40	CHAR	40	0	Student's Name (Sortable)
30	SC_SHORT	☐	PIQSCSRK	CHAR12	CHAR	12	0	Program of Study
31	SC_STEXT	☐	PIQSCTXT	TEXT40	CHAR	40	0	Program Description
32	O_OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
33	O_OBJID	☐	PIQOOBJID	HROBJID	NUMC	8	0	Object ID of Organizational Unit	*
34	O_SEARK	☐	PIQO_SRK	CHAR12	CHAR	12	0	Search Term for Organizational Unit
35	O_SHORT	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
36	O_STEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
37	PERYT	☐	PIQPERYT	TEXT20	CHAR	20	0	Academic Year (Description)
38	PERIT	☐	PIQPERIT	TEXT20	CHAR	20	0	Academic Session (Description)
39	ACLEVELT	☐	PIQLEVELT	TEXT30	CHAR	30	0	Stage (Description)
40	REGSTATUSQF	☐	PIQREGSTATUSQF	PIQICON_QF	CHAR	37	0	Icon for Status or Specification (Sessional Registration)
41	REGSTATUS	☐	PIQREGSTATUS	ICON	CHAR	4	0	Icon for Status or Specification (Sessional Registration)	*
42	ACLEVELVAR	☐	PIQLEVELVAR	PIQLEVELVAR	CHAR	2	0	Program Plan	*
43	VARID	☐	PIQVARID	PIQVARID	CHAR	2	0	Session Variant	*
44	VARIDUNIT	☐	PIQVARIDUNIT	PIQVARIDUNIT	NUMC	2	0	Primary Unit for Session Variant
45	LEAVE_REASONT	☐	PIQREASONT	TEXT25	CHAR	25	0	Reason Description
46	LEAVE	☐	PIQLEAVE	XFELD	CHAR	1	0	Indicator: Student on Leave of Absence
47	ACTST	☐	PIQREREG	XFELD	CHAR	1	0	Indicator: Student is Registered
48	RESTRICTED	☐	PIQRESTRICTED	PIQRESTRICTED	CHAR	1	0	Indicator: Admission Restricted
49	PROGCLASST	☐	PIQPROGCLASST	TEXT30	CHAR	30	0	Progress Classification (Description)
50	PROGCVAR	☐	PIQPROGC_VAR	PIQPROGC_VAR	CHAR	4	0	Program Type	*
51	ENRCATEGT	☐	PIQENRCATEGT	TEXT30	CHAR	30	0	Registration Type (Description)
52	DEGREE_SEEK	☐	PIQDEGREE_SEEK	XFELD	CHAR	1	0	Degree Seeking (Indicator)
53	CSFIRST	☐	PIQCSFIRST	XFELD	CHAR	1	0	Indicator: Main Program
54	CSOTHER	☐	PIQCSOTHER	XFELD	CHAR	1	0	Indicator: Additional program
55	REGCLASST	☐	PIQREGCLASST	TEXT30	CHAR	30	0	Registration Classification Description
56	CANCEL_PROCESST	☐	PIQPROCESS2T	TEXT40	CHAR	40	0	Activity (Description)
57	CANCEL_REASONT	☐	PIQREASONT	TEXT25	CHAR	25	0	Reason Description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQSTREG	ACLEVEL	T7PIQLEVPERVAR	ACLEVEL	KEY
2	PIQSTREG	ENRCATEG	T7PIQENRCATEG	ENRCATEG
3	PIQSTREG	PERID	T7PIQYEARPRD	PERID		1	CN
4	PIQSTREG	PERYR	T7PIQYEARPRD	PERYR		1	CN
5	PIQSTREG	REGCLASS	T7PIQREGCLASS	REGCLASS

History

Last changed by/on	SAP	20050224
SAP Release Created in