SAP ABAP Table PIQTRSESSION (Academic Session Data of External Organization)

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	Table Relationship Diagram
Short Description	Academic Session Data of External Organization

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	SESPROGRAMID	☐	PIQTRPROGRAMID		CHAR	12	0	Registered Program
8	STAGEID	☐	PIQTRSTAGEID	PIQLEVEL	NUMC	2	0	Registered Program Stage	T7PIQLEVEL
9	PROGCLASSID	☐	PIQTRPROGCLASSID	PIQPROGCLASS	CHAR	4	0	Progress Classification	T7PIQPROGCLASS
10	PROGACST	☐	PIQTRPROGACST	PIQTRPROGACST	CHAR	4	0	External Academic Standing	T7PIQTRPROGAS
11	PROGSTAT	☐	PIQPROGSTATUS	PIQPROGSTATUS	NUMC	3	0	Program Progression Status	T7PIQPROGSTATUS
12	EXTSESGPA	☐	PIQTREXTSESGPA		CHAR	10	0	External Sessional Average
13	EXTSESGPANORM	☐	PIQTREXTSESGPANORM	PIQSCALE_NORM_VAL	DEC	8	2	Original Sessional Average Standard Value)
14	EXTSESGPASCALE	☐	PIQTREXTSESGPASCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for Original Sessional Average	T7PIQSCALE
15	SESGPAMANFLAG	☐	TRPIQSESGPAMANFLAG		CHAR	1	0	Overwrite Internal Sessional Average Manually
16	INTSESGPA	☐	PIQTRINTSESGPA		CHAR	10	0	Internal Sessional Average
17	INTSESGPANORM	☐	PIQTRINTSESGPANORM	PIQSCALE_NORM_VAL	DEC	8	2	Internal Sessional Average (Standard Value)
18	INTSESGPASCALE	☐	PIQTRINTSESGPASCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for Internal Sessional Average	T7PIQSCALE
19	EXTSESATMCRED	☐	PIQTREXTSESATMCRED	PIQCP	QUAN	10	5	Attempted Credits Per Academic Session
20	EXTSESGRDCRED	☐	PIQTREXTSESGRDCRED	PIQCP	QUAN	10	5	Graded Credits Per Academic Session
21	EXTSESERNCRED	☐	PIQTREXTSESERNCRED	PIQCP	QUAN	10	5	Earned Credits Per Academic Session
22	EXTSESCREDTYPE	☐	PIQTREXTSESCREDTYPE	MEINS	UNIT	3	0	External Credit Type of Sessional Credits	T7PIQCP
23	SESCREDMANFLAG	☐	PIQTRSESCREDMANFLAG		CHAR	1	0	Overwrite Converted Sessional Credits Manually
24	INTSESATMCRED	☐	PIQTRINTSESATMCRED	PIQCP	QUAN	10	5	Attempted Credits Per Session In Internal Credit Type
25	INTSESGRDCRED	☐	PIQTRINTSESGRDCRED	PIQCP	QUAN	10	5	Graded Credits Per Session In Internal Credit Type
26	INTSESERNCRED	☐	PIQTRINTSESERNCRED	PIQCP	QUAN	10	5	Earned Credits Per Session In Internal Credit Type
27	INTSESCREDTYPE	☐	PIQTRINTSESCREDTYPE	MEINS	UNIT	3	0	Credit Type of Converted Sessional Credits	T7PIQCP

Foreign Keys

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

History

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