SAP ABAP Table PIQRULESTSC (Relationship Data for Student and Program)

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	PIQRULESTSC	Table Relationship Diagram
Short Description	Relationship Data for Student and Program

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	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
2	ISTAT	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	*
3	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
4	ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
5	AYEAR	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	T7PIQYEAR
6	PERID	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	T7PIQPERIOD
7	ACLEVEL	☐	PIQLEVEL	PIQLEVEL	NUMC	2	0	Stage	T7PIQLEVEL
8	CHOICE_NO	☐	PIQCHOICE_NO	PIQCHOICE_NO	NUMC	2	0	Program Choice	T7PIQCHOICES
9	PARTT	☐	PIQPARTT	XFELD	CHAR	1	0	Indicator: Part-Time Study
10	REGDATE	☐	PIQREGPERDATE	DATUM	DATS	8	0	Activity Key Date for Sessional Registration
11	DERDATE	☐	PIQDERDATE	DATUM	DATS	8	0	Activity Key Date of De-registration
12	ENDDA_DEREG	☐	PIQENDDA_DEREG	DATUM	DATS	8	0	End Date of Program Registration
13	COPDATE	☐	PIQPROC_KEY_DATE	DATUM	DATS	8	0	Activity Key Date (General)
14	DEREGCANCDATE	☐	PIQREGCANCDATE	DATUM	DATS	8	0	Cancellation Date (Registration)
15	REASON	☐	PIQLEAREASON	PIQAPPREASON	NUMC	4	0	Leave of Absence Reason	*
16	DERREASON	☐	PIQDERREASON	PIQAPPREASON	NUMC	4	0	De-registration Reason	*
17	COPREASON	☐	PIQCOP_REASON	PIQAPPREASON	NUMC	4	0	Reason for Change of Program	*
18	DEREGCANCREASON	☐	PIQREGCANCREASON	PIQAPPREASON	NUMC	4	0	Cancellation Reason (For Registration)	*
19	REGAPPTYPE	☐	PIQPROCESS_BEG	PIQPROCESS	CHAR	4	0	Activity for Program Registration	*
20	DERAPPTYPE	☐	PIQPROCESS_END	PIQPROCESS	CHAR	4	0	Activity for De-registration from Program	*
21	APPTYPE	☐	PIQAPPTYPE_503	PIQPROCESS	CHAR	4	0	Activity for Sessional Registration (OBSOLETE)	*
22	ENRCATEG	☐	PIQENRCATEG	PIQENRCATEG	CHAR	2	0	Registration Type	T7PIQENRCATEG
23	DEGREE_SEEK	☐	PIQDEGREE_SEEK	XFELD	CHAR	1	0	Degree Seeking (Indicator)
24	PROGCLASS	☐	PIQPROGCLASS	PIQPROGCLASS	CHAR	4	0	Progress Classification	T7PIQPROGCLASS
25	PERCT	☐	PIQPERCT	PIQPERCT	NUMC	3	0	Completed Length of Study
26	PRIOX	☐	PIQCSPRIOX	CHAR2	CHAR	2	0	Program Priority (In Period)
27	REGCLASS	☐	PIQREGCLASS	PIQREGCLASS	CHAR	2	0	Registration Classification	*
28	MAIN_ACTIVITY	☐	PIQPROCESS	PIQPROCESS	CHAR	4	0	Activity	*
29	OLD_PROGRAM_OBJID	☐	PIQSCOBJID	HROBJID	NUMC	8	0	Program ID	*
30	NEW_PROGRAM_BEGDA	☐	PIQCOP_NEW_SC_BEGDA	DATUM	DATS	8	0	Change of Program: Start Date of New Program
31	SESS_REGISTS_TRANSFER	☐	PIQREGPERIODREGIST	PIQREGPERIODREGIST	CHAR	1	0	Create Sessional Registration
32	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQRULESTSC	ACLEVEL	T7PIQLEVEL	ACLEVEL
2	PIQRULESTSC	AYEAR	T7PIQYEAR	PERYR
3	PIQRULESTSC	CHOICE_NO	T7PIQCHOICES	CHOICE_NO
4	PIQRULESTSC	ENRCATEG	T7PIQENRCATEG	ENRCATEG
5	PIQRULESTSC	PERID	T7PIQPERIOD	PERID	REF
6	PIQRULESTSC	PLVAR	T778P	PLVAR		1	CN
7	PIQRULESTSC	PROGCLASS	T7PIQPROGCLASS	PROGCLASS

History

Last changed by/on	SAP	20050224
SAP Release Created in	462