SAP ABAP Table PIQTRHEADER_EXT_TXT (External Academic Work (Header Data with Text Fields))

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_TXT	Table Relationship Diagram
Short Description	External Academic Work (Header Data with Text Fields)

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	External Transcript (Header Data)
2	TRANS_GUID	☐	PIQTRTRANS_GUID	SYSUUID_C	CHAR	32	0	GUID - Unique ID of External Transcript
3	ISSUEDATE	☐	PIQTRISSUEDATE	DATUM	DATS	8	0	Issue Date of External Transcript
4	TRANSTYPE	☐	PIQTRTRANSTYPE	PIQTRTRANSTYPE	CHAR	4	0	Transcript Category	T7PIQTRTRANSTYP
5	ISSEO	☐	PIQTRISSEO	HROBJID	NUMC	8	0	Issuing External Organization	*
6	TRANSEO	☐	PIQTRTRANSEO	HROBJID	NUMC	8	0	Transmitting External Organization	*
7	TRSTATUS	☐	PIQREPSTATE	PIQREPSTATE	CHAR	4	0	Transcript Status	T7PIQREPSTAT
8	REGPERIODFROM	☐	PIQTRREGPERIODFROM		DATS	8	0	Start Date of Registration at External Organization
9	REGPERIODTO	☐	PIQTRREGPERIODTO		DATS	8	0	End Date of Registration at External Organization
10	RANKING	☐	PIQTRRANKING		NUMC	4	0	Rank
11	SIZEOFCLASS	☐	PIQTRSIZEOFCLASS		NUMC	4	0	Class Size
12	RETURNINDIC	☐	PIQTRRETURNINDIC	PIQTRRETURNINDIC	CHAR	4	0	Eligibility to Return	T7PIQTRRETINDIC
13	RETURNDATE	☐	PIQTRRETURNDATE		DATS	8	0	Date of Eligibility to Return
14	TOTSELFGPA	☐	PIQTRTOTSELFREPGPA		CHAR	10	0	Self-Reported Average
15	TOTSELFGPASCALE	☐	PIQTRTOTSELFGPASCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for Self-Reported Average	T7PIQSCALE
16	TOTEXTGPA1	☐	PIQTRTOTEXTGPA1		CHAR	10	0	External Average 1
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	TOTEXTGPA2SCALE	☐	PIQTRTOTEXTGPA2SCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for External Average 2	T7PIQSCALE
20	TOTEXTGPA3	☐	PIQTRTOTEXTGPA3		CHAR	10	0	External Average 3
21	TOTEXTGPA3SCALE	☐	PIQTRTOTEXTGPA3SCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for External Average 3	T7PIQSCALE
22	TOTEXTATMCRED	☐	PIQTRTOTEXTATMCRED	PIQCP	QUAN	10	5	Total Attempted Credits
23	TOTEXTGRDCRED	☐	PIQTRTOTEXTGRDCRED	PIQCP	QUAN	10	5	Total Graded Credits
24	TOTEXTERNCRED	☐	PIQTRTOTEXTERNCRED	PIQCP	QUAN	10	5	Total Earned Credits
25	TOTEXTCREDTYPE	☐	PIQTRTOTEXTCREDTYPE	MEINS	UNIT	3	0	Original Type of Total Credits	T7PIQCP
26	.INCLUDE	☐				0	0	Texts for Structure PIQTRHEADER_EXT
27	TRANSTYPET	☐	PIQTRTRANSTYPET	TEXT20	CHAR	20	0	Transcript Category (Description)
28	ISSEO_SHORT	☐	PIQTRSHORT	TEXT12	CHAR	12	0	Name of Responsible External Organization
29	ISSEO_STEXT	☐	PIQTR_ISSUEEO_STEXT	TEXT40	CHAR	40	0	Issuing External Organization (Description)
30	TRANSEO_SHORT	☐	PIQTR_TRANSEO_SHORT	TEXT12	CHAR	12	0	Transmitting External Organization (ID)
31	TRANSEO_STEXT	☐	PIQTR_TRANSEO_STEXT	TEXT40	CHAR	40	0	Transmitting External Organization (Name)
32	TRSTATUST	☐	PIQREPSTATTEXT		CHAR	15	0	Screen Field for Transcript Status
33	TOTSELFGPAT	☐	PIQTREXTGRADETEXT	PIQSCALE_GRADETEXT	CHAR	20	0	Original Grade in External Subject
34	TOTSELFGPASCALET	☐	PIQSCALETEXT	PIQSCALE_TEXT	CHAR	30	0	Scale (Description)
35	TOTEXTGPA1T	☐	PIQTREXTGRADETEXT	PIQSCALE_GRADETEXT	CHAR	20	0	Original Grade in External Subject
36	TOTEXTGPA1SCALET	☐	PIQSCALETEXT	PIQSCALE_TEXT	CHAR	30	0	Scale (Description)
37	TOTEXTGPA2T	☐	PIQTREXTGRADETEXT	PIQSCALE_GRADETEXT	CHAR	20	0	Original Grade in External Subject
38	TOTEXTGPA2SCALET	☐	PIQSCALETEXT	PIQSCALE_TEXT	CHAR	30	0	Scale (Description)
39	TOTEXTGPA3T	☐	PIQTREXTGRADETEXT	PIQSCALE_GRADETEXT	CHAR	20	0	Original Grade in External Subject
40	TOTEXTGPA3SCALET	☐	PIQSCALETEXT	PIQSCALE_TEXT	CHAR	30	0	Scale (Description)
41	TOTEXTCREDTYPET	☐	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	PIQTRHEADER_EXT_TXT	RETURNINDIC	T7PIQTRRETINDIC	RETURNINDIC		1	CN
2	PIQTRHEADER_EXT_TXT	TOTEXTCREDTYPE	T7PIQCP	CPUNIT		1	CN
3	PIQTRHEADER_EXT_TXT	TOTEXTGPA1SCALE	T7PIQSCALE	SCALEID		1	CN
4	PIQTRHEADER_EXT_TXT	TOTEXTGPA2SCALE	T7PIQSCALE	SCALEID		1	CN
5	PIQTRHEADER_EXT_TXT	TOTEXTGPA3SCALE	T7PIQSCALE	SCALEID		1	CN
6	PIQTRHEADER_EXT_TXT	TOTSELFGPASCALE	T7PIQSCALE	SCALEID		1	CN
7	PIQTRHEADER_EXT_TXT	TRANSTYPE	T7PIQTRTRANSTYP	TRANSTYPE		1	CN
8	PIQTRHEADER_EXT_TXT	TRSTATUS	T7PIQREPSTAT	REPSTATE		1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in