SAP ABAP Table PIQTRSESSION_EXT (Academic Session (External Transcripts))

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_EXT	Table Relationship Diagram
Short Description	Academic Session (External Transcripts)

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	EXTSESGPASCALE	☐	PIQTREXTSESGPASCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for Original Sessional Average	T7PIQSCALE
14	EXTSESATMCRED	☐	PIQTREXTSESATMCRED	PIQCP	QUAN	10	5	Attempted Credits Per Academic Session
15	EXTSESGRDCRED	☐	PIQTREXTSESGRDCRED	PIQCP	QUAN	10	5	Graded Credits Per Academic Session
16	EXTSESERNCRED	☐	PIQTREXTSESERNCRED	PIQCP	QUAN	10	5	Earned Credits Per Academic Session
17	EXTSESCREDTYPE	☐	PIQTREXTSESCREDTYPE	MEINS	UNIT	3	0	External Credit Type of Sessional Credits	T7PIQCP

Foreign Keys

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

History

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