SAP ABAP Table PIQTRSESSION_EXT_TXT (Text Structure for PIQTRSESSION_EXT)

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_TXT	Table Relationship Diagram
Short Description	Text Structure for PIQTRSESSION_EXT

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	Academic Session (External Transcripts)
2	SESSIONID	☐	PIQTRSESSIONID	PIQTRSESSIONID	CHAR	4	0	External Academic Session	T7PIQTREXTSES
3	SESSIONYEAR	☐	PIQTRSESSIONYEAR	PIQTRSESSIONYEAR	NUMC	4	0	Year of Registration
4	SESBEGDATE	☐	PIQTRSESBEGDATE		DATS	8	0	Start Date of Academic Session
5	SESENDDATE	☐	PIQTRSESENDDATE		DATS	8	0	End Date of Academic Session
6	SESWITHDRDATE	☐	PIQTRSESWITHDRDATE		DATS	8	0	De-registration Date
7	SESDEGREEID	☐	PIQTRDEGREEID	HROBJID	NUMC	8	0	Degree/Qualification	*
8	SESPROGRAMID	☐	PIQTRPROGRAMID		CHAR	12	0	Registered Program
9	STAGEID	☐	PIQTRSTAGEID	PIQLEVEL	NUMC	2	0	Registered Program Stage	T7PIQLEVEL
10	PROGCLASSID	☐	PIQTRPROGCLASSID	PIQPROGCLASS	CHAR	4	0	Progress Classification	T7PIQPROGCLASS
11	PROGACST	☐	PIQTRPROGACST	PIQTRPROGACST	CHAR	4	0	External Academic Standing	T7PIQTRPROGAS
12	PROGSTAT	☐	PIQPROGSTATUS	PIQPROGSTATUS	NUMC	3	0	Program Progression Status	T7PIQPROGSTATUS
13	EXTSESGPA	☐	PIQTREXTSESGPA		CHAR	10	0	External Sessional Average
14	EXTSESGPASCALE	☐	PIQTREXTSESGPASCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for Original Sessional Average	T7PIQSCALE
15	EXTSESATMCRED	☐	PIQTREXTSESATMCRED	PIQCP	QUAN	10	5	Attempted Credits Per Academic Session
16	EXTSESGRDCRED	☐	PIQTREXTSESGRDCRED	PIQCP	QUAN	10	5	Graded Credits Per Academic Session
17	EXTSESERNCRED	☐	PIQTREXTSESERNCRED	PIQCP	QUAN	10	5	Earned Credits Per Academic Session
18	EXTSESCREDTYPE	☐	PIQTREXTSESCREDTYPE	MEINS	UNIT	3	0	External Credit Type of Sessional Credits	T7PIQCP
19	.INCLUDE	☐				0	0	Texts for Structure PIQTRSESSION_EXT
20	SESSIONT	☐	PIQTRSESSIONT	TEXT20	CHAR	20	0	External Academic Session (Description)
21	DEGREESHORT	☐	PIQTRDEGREESHORT	CHAR12	CHAR	12	0	Degree/Qualification (Abbreviation)
22	DEGREESTEXT	☐	PIQTRDEGREESTEXT	TEXT40	CHAR	40	0	Degree or Qualification (Description)
23	STAGET	☐	PIQLEVELT	TEXT30	CHAR	30	0	Stage (Description)
24	PROGCLASST	☐	PIQPROGCLASST	TEXT30	CHAR	30	0	Progress Classification (Description)
25	PROGACSTT	☐	PIQTRPROGACSTT	TEXT30	CHAR	30	0	External Academic Standing (Description)
26	PROGSTATT	☐	PIQPROGSTATUST	TEXT30	CHAR	30	0	Program Progression Status (Description)
27	SESGPAT	☐	PIQTREXTSESGPATEXT	PIQSCALE_GRADETEXT	CHAR	20	0	External Sessional Average (Text)
28	SESGPASCALET	☐	PIQSCALETEXT	PIQSCALE_TEXT	CHAR	30	0	Scale (Description)
29	SESCREDTYPET	☐	PIQCPUNITT	TEXT25	CHAR	25	0	Description of Credit Type Unit

Foreign Keys

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

History

Last changed by/on	SAP	20050224
SAP Release Created in