SAP ABAP Table PIQTRSESSION_D (Display Structure for Academic Session Data of EO)

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	PIQTRSESSION_D	Table Relationship Diagram
Short Description	Display Structure for Academic Session Data of EO

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	SESSIONID	☐	PIQTRSESSIONID	PIQTRSESSIONID	CHAR	4	0	External Academic Session	T7PIQTREXTSES
2	SESSIONYEAR	☐	PIQTRSESSIONYEAR	PIQTRSESSIONYEAR	NUMC	4	0	Year of Registration
3	SESBEGDATE	☐	PIQTRSESBEGDATE		DATS	8	0	Start Date of Academic Session
4	SESENDDATE	☐	PIQTRSESENDDATE		DATS	8	0	End Date of Academic Session
5	SESWITHDRDATE	☐	PIQTRSESWITHDRDATE		DATS	8	0	De-registration Date
6	SESDEGREEID	☐	PIQTRDEGREEID	HROBJID	NUMC	8	0	Degree/Qualification	*
7	DEGREESHORT	☐	PIQTRDEGREESHORT	CHAR12	CHAR	12	0	Degree/Qualification (Abbreviation)
8	DEGREESTEXT	☐	PIQTRDEGREESTEXT	TEXT40	CHAR	40	0	Degree or Qualification (Description)
9	SESPROGRAMID	☐	PIQTRPROGRAMID		CHAR	12	0	Registered Program
10	STAGEID	☐	PIQLEVEL	PIQLEVEL	NUMC	2	0	Stage	T7PIQLEVEL
11	PROGCLASSID	☐	PIQPROGCLASS	PIQPROGCLASS	CHAR	4	0	Progress Classification	T7PIQPROGCLASS
12	PROGACST	☐	PIQTRPROGACST	PIQTRPROGACST	CHAR	4	0	External Academic Standing	T7PIQTRPROGAS
13	PROGSTAT	☐	PIQPROGSTATUS	PIQPROGSTATUS	NUMC	3	0	Program Progression Status	T7PIQPROGSTATUS
14	EXTSESGPA	☐	PIQTREXTSESGPA		CHAR	10	0	External Sessional Average
15	EXTSESGPATEXT	☐	PIQTREXTSESGPATEXT	PIQSCALE_GRADETEXT	CHAR	20	0	External Sessional Average (Text)
16	EXTSESGPANORM	☐	PIQTREXTSESGPANORM	PIQSCALE_NORM_VAL	DEC	8	2	Original Sessional Average Standard Value)
17	EXTSESGPASCALE	☐	PIQTREXTSESGPASCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for Original Sessional Average	T7PIQSCALE
18	SESGPAMANFLAG	☐	TRPIQSESGPAMANFLAG		CHAR	1	0	Overwrite Internal Sessional Average Manually
19	INTSESGPA	☐	PIQTRINTSESGPA		CHAR	10	0	Internal Sessional Average
20	INTSESGPATEXT	☐	PIQTRINTSESGPATEXT	PIQSCALE_GRADETEXT	CHAR	20	0	Internal Sessional Average (Text)
21	INTSESGPANORM	☐	PIQTRINTSESGPANORM	PIQSCALE_NORM_VAL	DEC	8	2	Internal Sessional Average (Standard Value)
22	INTSESGPASCALE	☐	PIQTRINTSESGPASCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for Internal Sessional Average	T7PIQSCALE
23	EXTSESATMCRED	☐	PIQTREXTSESATMCRED	PIQCP	QUAN	10	5	Attempted Credits Per Academic Session
24	EXTSESGRDCRED	☐	PIQTREXTSESGRDCRED	PIQCP	QUAN	10	5	Graded Credits Per Academic Session
25	EXTSESERNCRED	☐	PIQTREXTSESERNCRED	PIQCP	QUAN	10	5	Earned Credits Per Academic Session
26	EXTSESCREDTYPE	☐	PIQTREXTSESCREDTYPE	MEINS	UNIT	3	0	External Credit Type of Sessional Credits	T7PIQCP
27	SESCREDMANFLAG	☐	PIQTRSESCREDMANFLAG		CHAR	1	0	Overwrite Converted Sessional Credits Manually
28	INTSESATMCRED	☐	PIQTRINTSESATMCRED	PIQCP	QUAN	10	5	Attempted Credits Per Session In Internal Credit Type
29	INTSESGRDCRED	☐	PIQTRINTSESGRDCRED	PIQCP	QUAN	10	5	Graded Credits Per Session In Internal Credit Type
30	INTSESERNCRED	☐	PIQTRINTSESERNCRED	PIQCP	QUAN	10	5	Earned Credits Per Session In Internal Credit Type
31	INTSESCREDTYPE	☐	PIQTRINTSESCREDTYPE	MEINS	UNIT	3	0	Credit Type of Converted Sessional Credits	*
32	MARK	☐	FLAG	FLAG	CHAR	1	0	General Flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQTRSESSION_D	EXTSESCREDTYPE	T7PIQCP	CPUNIT	KEY	1	CN
2	PIQTRSESSION_D	EXTSESGPASCALE	T7PIQSCALE	SCALEID	KEY	1	CN
3	PIQTRSESSION_D	INTSESGPASCALE	T7PIQSCALE	SCALEID	KEY	1	CN
4	PIQTRSESSION_D	PROGACST	T7PIQTRPROGAS	PROGACST
5	PIQTRSESSION_D	PROGCLASSID	T7PIQPROGCLASS	PROGCLASS	KEY	1	CN
6	PIQTRSESSION_D	PROGSTAT	T7PIQPROGSTATUS	PROGSTATUS	KEY	1	CN
7	PIQTRSESSION_D	SESSIONID	T7PIQTREXTSES	SESSIONID	KEY	1	CN
8	PIQTRSESSION_D	STAGEID	T7PIQLEVEL	ACLEVEL	KEY	1	CN

History

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