SAP ABAP Table PIQTRHEADER_EXT (External Transcript (Header Data))

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	PIQTRHEADER_EXT	Table Relationship Diagram
Short Description	External Transcript (Header Data)

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	TRANS_GUID	☐	PIQTRTRANS_GUID	SYSUUID_C	CHAR	32	0	GUID - Unique ID of External Transcript
2	ISSUEDATE	☐	PIQTRISSUEDATE	DATUM	DATS	8	0	Issue Date of External Transcript
3	TRANSTYPE	☐	PIQTRTRANSTYPE	PIQTRTRANSTYPE	CHAR	4	0	Transcript Category	T7PIQTRTRANSTYP
4	ISSEO	☐	PIQTRISSEO	HROBJID	NUMC	8	0	Issuing External Organization	*
5	TRANSEO	☐	PIQTRTRANSEO	HROBJID	NUMC	8	0	Transmitting External Organization	*
6	TRSTATUS	☐	PIQREPSTATE	PIQREPSTATE	CHAR	4	0	Transcript Status	T7PIQREPSTAT
7	REGPERIODFROM	☐	PIQTRREGPERIODFROM		DATS	8	0	Start Date of Registration at External Organization
8	REGPERIODTO	☐	PIQTRREGPERIODTO		DATS	8	0	End Date of Registration at External Organization
9	RANKING	☐	PIQTRRANKING		NUMC	4	0	Rank
10	SIZEOFCLASS	☐	PIQTRSIZEOFCLASS		NUMC	4	0	Class Size
11	RETURNINDIC	☐	PIQTRRETURNINDIC	PIQTRRETURNINDIC	CHAR	4	0	Eligibility to Return	T7PIQTRRETINDIC
12	RETURNDATE	☐	PIQTRRETURNDATE		DATS	8	0	Date of Eligibility to Return
13	TOTSELFGPA	☐	PIQTRTOTSELFREPGPA		CHAR	10	0	Self-Reported Average
14	TOTSELFGPASCALE	☐	PIQTRTOTSELFGPASCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for Self-Reported Average	T7PIQSCALE
15	TOTEXTGPA1	☐	PIQTRTOTEXTGPA1		CHAR	10	0	External Average 1
16	TOTEXTGPA1SCALE	☐	PIQTRTOTEXTGPA1SCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for External Average 1	T7PIQSCALE
17	TOTEXTGPA2	☐	PIQTRTOTEXTGPA2		CHAR	10	0	External Average 2
18	TOTEXTGPA2SCALE	☐	PIQTRTOTEXTGPA2SCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for External Average 2	T7PIQSCALE
19	TOTEXTGPA3	☐	PIQTRTOTEXTGPA3		CHAR	10	0	External Average 3
20	TOTEXTGPA3SCALE	☐	PIQTRTOTEXTGPA3SCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for External Average 3	T7PIQSCALE
21	TOTEXTATMCRED	☐	PIQTRTOTEXTATMCRED	PIQCP	QUAN	10	5	Total Attempted Credits
22	TOTEXTGRDCRED	☐	PIQTRTOTEXTGRDCRED	PIQCP	QUAN	10	5	Total Graded Credits
23	TOTEXTERNCRED	☐	PIQTRTOTEXTERNCRED	PIQCP	QUAN	10	5	Total Earned Credits
24	TOTEXTCREDTYPE	☐	PIQTRTOTEXTCREDTYPE	MEINS	UNIT	3	0	Original Type of Total Credits	T7PIQCP

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQTRHEADER_EXT	RETURNINDIC	T7PIQTRRETINDIC	RETURNINDIC		1	CN
2	PIQTRHEADER_EXT	TOTEXTCREDTYPE	T7PIQCP	CPUNIT		1	CN
3	PIQTRHEADER_EXT	TOTEXTGPA1SCALE	T7PIQSCALE	SCALEID		1	CN
4	PIQTRHEADER_EXT	TOTEXTGPA2SCALE	T7PIQSCALE	SCALEID		1	CN
5	PIQTRHEADER_EXT	TOTEXTGPA3SCALE	T7PIQSCALE	SCALEID		1	CN
6	PIQTRHEADER_EXT	TOTSELFGPASCALE	T7PIQSCALE	SCALEID		1	CN
7	PIQTRHEADER_EXT	TRANSTYPE	T7PIQTRTRANSTYP	TRANSTYPE		1	CN
8	PIQTRHEADER_EXT	TRSTATUS	T7PIQREPSTAT	REPSTATE		1	CN

History

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