SAP ABAP Table PIQEDCOURSE_D (Display Structure for Subjects from Transcripts)

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	PIQEDCOURSE_D	Table Relationship Diagram
Short Description	Display Structure for Subjects from Transcripts

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	ISSEO_SU	☐	PIQTRISSEO	HROBJID	NUMC	8	0	Issuing External Organization	*
2	ISSEOT_SU	☐	PIQEONAME	TEXT40	CHAR	40	0	Name of External Organization
3	TRANS_GUID_SU	☐	PIQTRTRANS_GUID	SYSUUID_C	CHAR	32	0	GUID - Unique ID of External Transcript
4	TRTYPE_SU	☐	PIQTRTRANSTYPE	PIQTRTRANSTYPE	CHAR	4	0	Transcript Category	*
5	TRTYPET_SU	☐	PIQTRTRANSTYPET	TEXT20	CHAR	20	0	Transcript Category (Description)
6	.INCLUDE	☐				0	0	Display Structure for External Subject Data
7	COURSEID	☐	PIQTRCOURSEID	HROBJID	NUMC	8	0	Registered Subject	*
8	COURSESHORT	☐	PIQTRCOURSESHORT	TEXT12	CHAR	12	0	Registered Subject (Abbreviation)
9	COURSESTEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
10	EXTGRADE	☐	PIQTREXTGRADE		CHAR	10	0	Original Grade in External Subject
11	EXTGRADETEXT	☐	PIQTREXTGRADETEXT	PIQSCALE_GRADETEXT	CHAR	20	0	Original Grade in External Subject
12	EXTGRADENORM	☐	PIQTREXTGRADENORM	PIQSCALE_NORM_VAL	DEC	8	2	Original Grade per Subject (Standard Value)
13	EXTGRADESCALE	☐	PIQTREXTGRADESCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for Original Grade	T7PIQSCALE
14	GRADEMANFLAG	☐	PIQTRGRADEMANFLAG		CHAR	1	0	Overwrite Converted Original Grade of External Subject
15	INTGRADE	☐	PIQTRINTGRADE		CHAR	10	0	Original Grade in External Subject on Internal Grading Scale
16	INTGRADETEXT	☐	PIQTRINTGRADETEXT	PIQSCALE_GRADETEXT	CHAR	20	0	Original Grade Per Subject In Internal Grading Scale (Text)
17	INTGRADENORM	☐	PIQTRINTGRADENORM	PIQSCALE_NORM_VAL	DEC	8	2	Converted Grade per Subject (Standard Value)
18	INTGRADESCALE	☐	PIQTRINTGRADESCALE	PIQSCALE_ID	CHAR	4	0	Internal Grading Scale for Converted Grade per Subject	T7PIQSCALE
19	COREPEATFLAG	☐	PIQTRCOREPEATFLAG		CHAR	1	0	Indicator: Repeated Subject
20	HONORSINDIC	☐	PIQTRHONORSINDIC		CHAR	1	0	Indicator: Honors Subject
21	EXTCOATMCRED	☐	PIQTREXTCOATMCRED	PIQCP	QUAN	10	5	Attempted Credits in External Subject
22	EXTCOGRDCRED	☐	PIQTREXTCOGRDCRED	PIQCP	QUAN	10	5	Graded Credits in External Subject
23	EXTCOERNCRED	☐	PIQTREXTCOERNCRED	PIQCP	QUAN	10	5	Earned Credits in External Subject
24	EXTCOCREDTYPE	☐	PIQTREXTCOCREDTYPE	MEINS	UNIT	3	0	Original Credit Type of External Subject	T7PIQCP
25	COCREDMANFLAG	☐	PIQTRCOCREDMANFLAG		CHAR	1	0	Overwrite Converted Credits Per External Subject Manually
26	INTCOATMCRED	☐	PIQTRINTCOATMCRED	PIQCP	QUAN	10	5	Attempted Credits in Ext. Subject in Internal Credit Type
27	INTCOGRDCRED	☐	PIQTRINTCOGRDCRED	PIQCP	QUAN	10	5	Graded Credits in Ext. Subject in Internal Credit Type
28	INTCOERNCRED	☐	PIQTRINTCOERNCRED	PIQCP	QUAN	10	5	Earned Credits in Ext. Subject in Internal Credit Type
29	INTCOCREDTYPE	☐	PIQTRINTCOCREDTYPE	MEINS	UNIT	3	0	Internal Credit Type	*
30	BASFORCOCRED	☐	PIQTRBASFORCOCRED	PIQTRBASFORCRED	CHAR	4	0	Basis for Accomplished Credits	T7PIQTRBASFORCP
31	COREFLAG	☐	PIQTRCOREFLAG		CHAR	1	0	Indicator for Core Subject
32	COWITHDRDATE	☐	PIQTRCOWITHDRDATE		DATS	8	0	Date of Withdrawal
33	COSESID	☐	PIQTRCOSESID	PIQTRSESSIONID	CHAR	4	0	Session In Which External Subject Was Taken	T7PIQTREXTSES
34	COSESYEAR	☐	PIQTRSESSIONYEAR	PIQTRSESSIONYEAR	NUMC	4	0	Year of Registration
35	COBEGDATE	☐	PIQTRCOBEGDATE		DATS	8	0	Start Date of Subject
36	COENDDATE	☐	PIQTRCOENDDATE		DATS	8	0	End Date of Subject
37	MARK	☐	PIQFLAG	FLAG	CHAR	1	0	General Indicator
38	INTSCALET	☐	PIQSCALE_TEXT	PIQSCALE_TEXT	CHAR	30	0	Academic Scale (Description)
39	INTCPUNITT	☐	PIQCPUNITT	TEXT25	CHAR	25	0	Description of Credit Type Unit
40	EXTSCALET	☐	PIQSCALE_TEXT	PIQSCALE_TEXT	CHAR	30	0	Academic Scale (Description)
41	EXTCPUNITT	☐	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	PIQEDCOURSE_D	BASFORCOCRED	T7PIQTRBASFORCP	BASISFORCP	KEY	1	CN
2	PIQEDCOURSE_D	COSESID	T7PIQTREXTSES	SESSIONID	KEY	1	CN
3	PIQEDCOURSE_D	EXTCOCREDTYPE	T7PIQCP	CPUNIT	KEY	1	CN
4	PIQEDCOURSE_D	EXTGRADESCALE	T7PIQSCALE	SCALEID	KEY	1	CN
5	PIQEDCOURSE_D	INTGRADESCALE	T7PIQSCALE	SCALEID	KEY	1	CN

History

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