SAP ABAP Table PIQTRHEADER (Transcripts (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	Table Relationship Diagram
Short Description	Transcripts (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	TRANSTYPE	☐	PIQTRTRANSTYPE	PIQTRTRANSTYPE	CHAR	4	0	Transcript Category	T7PIQTRTRANSTYP
3	ISSEO	☐	PIQTRISSEO	HROBJID	NUMC	8	0	Issuing External Organization	*
4	TRANSEO	☐	PIQTRTRANSEO	HROBJID	NUMC	8	0	Transmitting External Organization	*
5	TRSTATUS	☐	PIQREPSTATE	PIQREPSTATE	CHAR	4	0	Transcript Status	T7PIQREPSTAT
6	REGPERIODFROM	☐	PIQTRREGPERIODFROM		DATS	8	0	Start Date of Registration at External Organization
7	REGPERIODTO	☐	PIQTRREGPERIODTO		DATS	8	0	End Date of Registration at External Organization
8	RANKING	☐	PIQTRRANKING		NUMC	4	0	Rank
9	SIZEOFCLASS	☐	PIQTRSIZEOFCLASS		NUMC	4	0	Class Size
10	RETURNINDIC	☐	PIQTRRETURNINDIC	PIQTRRETURNINDIC	CHAR	4	0	Eligibility to Return	T7PIQTRRETINDIC
11	RETURNDATE	☐	PIQTRRETURNDATE		DATS	8	0	Date of Eligibility to Return
12	TOTSELFGPA	☐	PIQTRTOTSELFREPGPA		CHAR	10	0	Self-Reported Average
13	TOTSELFGPANORM	☐	PIQTRTOTSELFGPANORM	PIQSCALE_NORM_VAL	DEC	8	2	Self-Reported Average (Standard Value)
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	TOTEXTGPA1NORM	☐	PIQTRTOTEXTGPA1NORM	PIQSCALE_NORM_VAL	DEC	8	2	External Average 1 (Standard Value)
17	TOTEXTGPA1SCALE	☐	PIQTRTOTEXTGPA1SCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for External Average 1	T7PIQSCALE
18	TOTEXTGPA2	☐	PIQTRTOTEXTGPA2		CHAR	10	0	External Average 2
19	TOTEXTGPA2NORM	☐	PIQTRTOTEXTGPA2NORM	PIQSCALE_NORM_VAL	DEC	8	2	External Average 2 (Standard Value)
20	TOTEXTGPA2SCALE	☐	PIQTRTOTEXTGPA2SCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for External Average 2	T7PIQSCALE
21	TOTEXTGPA3	☐	PIQTRTOTEXTGPA3		CHAR	10	0	External Average 3
22	TOTEXTGPA3NORM	☐	PIQTRTOTEXTGPA3NORM	PIQSCALE_NORM_VAL	DEC	8	2	External Average 3 (Standard Value)
23	TOTEXTGPA3SCALE	☐	PIQTRTOTEXTGPA3SCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for External Average 3	T7PIQSCALE
24	CALCGPAMANFLAG	☐	PIQTRCALCGPAMANFLAG		CHAR	1	0	Overwrite Calculated Average Manually
25	TOTCALCGPA	☐	PIQTRTOTCALCGPA		CHAR	10	0	Calculated Average
26	TOTCALCGPANORM	☐	PIQTRTOTCALCGPANORM	PIQSCALE_NORM_VAL	DEC	8	2	Calculated Average (Standard Value)
27	TOTCALCGPASCALE	☐	PIQTRTOTCALCGPASCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for Calculated Average	T7PIQSCALE
28	TOTEXTATMCRED	☐	PIQTRTOTEXTATMCRED	PIQCP	QUAN	10	5	Total Attempted Credits
29	TOTEXTGRDCRED	☐	PIQTRTOTEXTGRDCRED	PIQCP	QUAN	10	5	Total Graded Credits
30	TOTEXTERNCRED	☐	PIQTRTOTEXTERNCRED	PIQCP	QUAN	10	5	Total Earned Credits
31	TOTEXTCREDTYPE	☐	PIQTRTOTEXTCREDTYPE	MEINS	UNIT	3	0	Original Type of Total Credits	T7PIQCP
32	TOTCREDMANFLAG	☐	PIQTRTOTCREDMANFLAG		CHAR	1	0	Overwrite Converted Credits Manually
33	TOTINTATMCRED	☐	PIQTRTOTINTATMCRED	PIQCP	QUAN	10	5	Total Attempted Credits In Internal Credit Type
34	TOTINTGRDCRED	☐	PIQTRTOTINTGRDCRED	PIQCP	QUAN	10	5	Total Graded Credits In Internal Credit Type
35	TOTINTERNCRED	☐	PIQTRTOTINTERNCRED	PIQCP	QUAN	10	5	Total Earned Credits In Internal Credit Type
36	TOTINTCREDTYPE	☐	PIQTRTOTINTCREDTYPE	MEINS	UNIT	3	0	Converted Credit Type	T7PIQCP

Foreign Keys

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

History

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