SAP ABAP Table PIQCORR_STRU_CMS1_EXT_TR_H (External Transcripts of Student)

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	PIQCORR_STRU_CMS1_EXT_TR_H	Table Relationship Diagram
Short Description	External Transcripts of Student

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	WA_EXT_TR_H	☐	PIQTRHEADER_EXT		STRU	0	0
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
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
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
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
16	TOTEXTGPA1	☐	PIQTRTOTEXTGPA1		CHAR	10	0	External Average 1
17	TOTEXTGPA1SCALE	☐	PIQTRTOTEXTGPA1SCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for External Average 1
18	TOTEXTGPA2	☐	PIQTRTOTEXTGPA2		CHAR	10	0	External Average 2
19	TOTEXTGPA2SCALE	☐	PIQTRTOTEXTGPA2SCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for External Average 2
20	TOTEXTGPA3	☐	PIQTRTOTEXTGPA3		CHAR	10	0	External Average 3
21	TOTEXTGPA3SCALE	☐	PIQTRTOTEXTGPA3SCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for External Average 3
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
26	WA_EXT_TR_HT	☐	PIQTRHEADER_EXT_T		STRU	0	0
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
42	T_FREETEXT	☐	PIQCORR_TAB_CMS1_FREETEXT		TTYP	0	0
43	T_CODNOTE	☐	PIQCORR_TAB_CMS1_CODNOTE		TTYP	0	0
44	T_SESSION	☐	PIQCORR_TAB_CMS1_SESSION		TTYP	0	0
45	T_SPEC	☐	PIQCORR_TAB_CMS1_SPEC		TTYP	0	0
46	T_DEG	☐	PIQCORR_TAB_CMS1_DEG		TTYP	0	0
47	T_COURSE	☐	PIQCORR_TAB_CMS1_COURSE		TTYP	0	0

History

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