SAP ABAP Table PIQEDRUN_TR_HEADER (ED Run Header with Related Transcript)

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	PIQEDRUN_TR_HEADER	Table Relationship Diagram
Short Description	ED Run Header with Related Transcript

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	ED Run Header
2	.INCLUDE	☐				0	0	ED Run GUID
3	GUIDTYPE	☐	PIQGUIDTYPE	PIQGUIDTYPE	CHAR	4	0	Identifier Type (GUID)	*
4	GUID	☐	PIQEDGUID	PIQPROC_DOCID	CHAR	32	0	Equivalency Identifier (ID)	*
5	.INCLUDE	☐				0	0	ED Activity Document: Header Data
6	STATUS	☐	PIQEDDBSTATUS	PIQEDDBSTATUS	CHAR	1	0	Equivalency Status
7	NOTE	☐	PIQNOTE_GUID	SYSUUID_C	CHAR	32	0	GUID - Unique Note Identifier
8	TEXT	☐	PIQEDTEXT	TEXT40	CHAR	40	0	User-Specific Text for Non System-Based Equivalency
9	.INCLUDE	☐				0	0	Transcripts (Header Data)
10	TRANS_GUID	☐	PIQTRTRANS_GUID	SYSUUID_C	CHAR	32	0	GUID - Unique ID of External Transcript
11	TRANSTYPE	☐	PIQTRTRANSTYPE	PIQTRTRANSTYPE	CHAR	4	0	Transcript Category	T7PIQTRTRANSTYP
12	ISSEO	☐	PIQTRISSEO	HROBJID	NUMC	8	0	Issuing External Organization	*
13	TRANSEO	☐	PIQTRTRANSEO	HROBJID	NUMC	8	0	Transmitting External Organization	*
14	TRSTATUS	☐	PIQREPSTATE	PIQREPSTATE	CHAR	4	0	Transcript Status	T7PIQREPSTAT
15	REGPERIODFROM	☐	PIQTRREGPERIODFROM		DATS	8	0	Start Date of Registration at External Organization
16	REGPERIODTO	☐	PIQTRREGPERIODTO		DATS	8	0	End Date of Registration at External Organization
17	RANKING	☐	PIQTRRANKING		NUMC	4	0	Rank
18	SIZEOFCLASS	☐	PIQTRSIZEOFCLASS		NUMC	4	0	Class Size
19	RETURNINDIC	☐	PIQTRRETURNINDIC	PIQTRRETURNINDIC	CHAR	4	0	Eligibility to Return	T7PIQTRRETINDIC
20	RETURNDATE	☐	PIQTRRETURNDATE		DATS	8	0	Date of Eligibility to Return
21	TOTSELFGPA	☐	PIQTRTOTSELFREPGPA		CHAR	10	0	Self-Reported Average
22	TOTSELFGPANORM	☐	PIQTRTOTSELFGPANORM	PIQSCALE_NORM_VAL	DEC	8	2	Self-Reported Average (Standard Value)
23	TOTSELFGPASCALE	☐	PIQTRTOTSELFGPASCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for Self-Reported Average	T7PIQSCALE
24	TOTEXTGPA1	☐	PIQTRTOTEXTGPA1		CHAR	10	0	External Average 1
25	TOTEXTGPA1NORM	☐	PIQTRTOTEXTGPA1NORM	PIQSCALE_NORM_VAL	DEC	8	2	External Average 1 (Standard Value)
26	TOTEXTGPA1SCALE	☐	PIQTRTOTEXTGPA1SCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for External Average 1	T7PIQSCALE
27	TOTEXTGPA2	☐	PIQTRTOTEXTGPA2		CHAR	10	0	External Average 2
28	TOTEXTGPA2NORM	☐	PIQTRTOTEXTGPA2NORM	PIQSCALE_NORM_VAL	DEC	8	2	External Average 2 (Standard Value)
29	TOTEXTGPA2SCALE	☐	PIQTRTOTEXTGPA2SCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for External Average 2	T7PIQSCALE
30	TOTEXTGPA3	☐	PIQTRTOTEXTGPA3		CHAR	10	0	External Average 3
31	TOTEXTGPA3NORM	☐	PIQTRTOTEXTGPA3NORM	PIQSCALE_NORM_VAL	DEC	8	2	External Average 3 (Standard Value)
32	TOTEXTGPA3SCALE	☐	PIQTRTOTEXTGPA3SCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for External Average 3	T7PIQSCALE
33	CALCGPAMANFLAG	☐	PIQTRCALCGPAMANFLAG		CHAR	1	0	Overwrite Calculated Average Manually
34	TOTCALCGPA	☐	PIQTRTOTCALCGPA		CHAR	10	0	Calculated Average
35	TOTCALCGPANORM	☐	PIQTRTOTCALCGPANORM	PIQSCALE_NORM_VAL	DEC	8	2	Calculated Average (Standard Value)
36	TOTCALCGPASCALE	☐	PIQTRTOTCALCGPASCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for Calculated Average	T7PIQSCALE
37	TOTEXTATMCRED	☐	PIQTRTOTEXTATMCRED	PIQCP	QUAN	10	5	Total Attempted Credits
38	TOTEXTGRDCRED	☐	PIQTRTOTEXTGRDCRED	PIQCP	QUAN	10	5	Total Graded Credits
39	TOTEXTERNCRED	☐	PIQTRTOTEXTERNCRED	PIQCP	QUAN	10	5	Total Earned Credits
40	TOTEXTCREDTYPE	☐	PIQTRTOTEXTCREDTYPE	MEINS	UNIT	3	0	Original Type of Total Credits	T7PIQCP
41	TOTCREDMANFLAG	☐	PIQTRTOTCREDMANFLAG		CHAR	1	0	Overwrite Converted Credits Manually
42	TOTINTATMCRED	☐	PIQTRTOTINTATMCRED	PIQCP	QUAN	10	5	Total Attempted Credits In Internal Credit Type
43	TOTINTGRDCRED	☐	PIQTRTOTINTGRDCRED	PIQCP	QUAN	10	5	Total Graded Credits In Internal Credit Type
44	TOTINTERNCRED	☐	PIQTRTOTINTERNCRED	PIQCP	QUAN	10	5	Total Earned Credits In Internal Credit Type
45	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	PIQEDRUN_TR_HEADER	RETURNINDIC	T7PIQTRRETINDIC	RETURNINDIC	KEY	1	CN
2	PIQEDRUN_TR_HEADER	TOTCALCGPASCALE	T7PIQSCALE	SCALEID	KEY	1	CN
3	PIQEDRUN_TR_HEADER	TOTEXTCREDTYPE	T7PIQCP	CPUNIT	KEY	1	CN
4	PIQEDRUN_TR_HEADER	TOTEXTGPA1SCALE	T7PIQSCALE	SCALEID	KEY	1	CN
5	PIQEDRUN_TR_HEADER	TOTEXTGPA2SCALE	T7PIQSCALE	SCALEID	KEY	1	CN
6	PIQEDRUN_TR_HEADER	TOTEXTGPA3SCALE	T7PIQSCALE	SCALEID	KEY	1	CN
7	PIQEDRUN_TR_HEADER	TOTINTCREDTYPE	T7PIQCP	CPUNIT	KEY	1	CN
8	PIQEDRUN_TR_HEADER	TOTSELFGPASCALE	T7PIQSCALE	SCALEID	KEY	1	CN
9	PIQEDRUN_TR_HEADER	TRANSTYPE	T7PIQTRTRANSTYP	TRANSTYPE		1	CN
10	PIQEDRUN_TR_HEADER	TRSTATUS	T7PIQREPSTAT	REPSTATE		1	CN

History

Last changed by/on	SAP	20060920
SAP Release Created in