SAP ABAP Table PIQED464_D (Display Structure for Equivalency Determination)

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	PIQED464_D	Table Relationship Diagram
Short Description	Display Structure for Equivalency Determination

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	Display Structure for Subjects from Transcripts
2	ISSEO_SU	☐	PIQTRISSEO	HROBJID	NUMC	8	0	Issuing External Organization	*
3	ISSEOT_SU	☐	PIQEONAME	TEXT40	CHAR	40	0	Name of External Organization
4	TRANS_GUID_SU	☐	PIQTRTRANS_GUID	SYSUUID_C	CHAR	32	0	GUID - Unique ID of External Transcript
5	TRTYPE_SU	☐	PIQTRTRANSTYPE	PIQTRTRANSTYPE	CHAR	4	0	Transcript Category	*
6	TRTYPET_SU	☐	PIQTRTRANSTYPET	TEXT20	CHAR	20	0	Transcript Category (Description)
7	.INCLUDE	☐				0	0	Display Structure for External Subject Data
8	COURSEID	☐	PIQTRCOURSEID	HROBJID	NUMC	8	0	Registered Subject	*
9	COURSESHORT	☐	PIQTRCOURSESHORT	TEXT12	CHAR	12	0	Registered Subject (Abbreviation)
10	COURSESTEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
11	EXTGRADE	☐	PIQTREXTGRADE		CHAR	10	0	Original Grade in External Subject
12	EXTGRADETEXT	☐	PIQTREXTGRADETEXT	PIQSCALE_GRADETEXT	CHAR	20	0	Original Grade in External Subject
13	EXTGRADENORM	☐	PIQTREXTGRADENORM	PIQSCALE_NORM_VAL	DEC	8	2	Original Grade per Subject (Standard Value)
14	EXTGRADESCALE	☐	PIQTREXTGRADESCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for Original Grade	T7PIQSCALE
15	GRADEMANFLAG	☐	PIQTRGRADEMANFLAG		CHAR	1	0	Overwrite Converted Original Grade of External Subject
16	INTGRADE	☐	PIQTRINTGRADE		CHAR	10	0	Original Grade in External Subject on Internal Grading Scale
17	INTGRADETEXT	☐	PIQTRINTGRADETEXT	PIQSCALE_GRADETEXT	CHAR	20	0	Original Grade Per Subject In Internal Grading Scale (Text)
18	INTGRADENORM	☐	PIQTRINTGRADENORM	PIQSCALE_NORM_VAL	DEC	8	2	Converted Grade per Subject (Standard Value)
19	INTGRADESCALE	☐	PIQTRINTGRADESCALE	PIQSCALE_ID	CHAR	4	0	Internal Grading Scale for Converted Grade per Subject	T7PIQSCALE
20	COREPEATFLAG	☐	PIQTRCOREPEATFLAG		CHAR	1	0	Indicator: Repeated Subject
21	HONORSINDIC	☐	PIQTRHONORSINDIC		CHAR	1	0	Indicator: Honors Subject
22	EXTCOATMCRED	☐	PIQTREXTCOATMCRED	PIQCP	QUAN	10	5	Attempted Credits in External Subject
23	EXTCOGRDCRED	☐	PIQTREXTCOGRDCRED	PIQCP	QUAN	10	5	Graded Credits in External Subject
24	EXTCOERNCRED	☐	PIQTREXTCOERNCRED	PIQCP	QUAN	10	5	Earned Credits in External Subject
25	EXTCOCREDTYPE	☐	PIQTREXTCOCREDTYPE	MEINS	UNIT	3	0	Original Credit Type of External Subject	T7PIQCP
26	COCREDMANFLAG	☐	PIQTRCOCREDMANFLAG		CHAR	1	0	Overwrite Converted Credits Per External Subject Manually
27	INTCOATMCRED	☐	PIQTRINTCOATMCRED	PIQCP	QUAN	10	5	Attempted Credits in Ext. Subject in Internal Credit Type
28	INTCOGRDCRED	☐	PIQTRINTCOGRDCRED	PIQCP	QUAN	10	5	Graded Credits in Ext. Subject in Internal Credit Type
29	INTCOERNCRED	☐	PIQTRINTCOERNCRED	PIQCP	QUAN	10	5	Earned Credits in Ext. Subject in Internal Credit Type
30	INTCOCREDTYPE	☐	PIQTRINTCOCREDTYPE	MEINS	UNIT	3	0	Internal Credit Type	*
31	BASFORCOCRED	☐	PIQTRBASFORCOCRED	PIQTRBASFORCRED	CHAR	4	0	Basis for Accomplished Credits	T7PIQTRBASFORCP
32	COREFLAG	☐	PIQTRCOREFLAG		CHAR	1	0	Indicator for Core Subject
33	COWITHDRDATE	☐	PIQTRCOWITHDRDATE		DATS	8	0	Date of Withdrawal
34	COSESID	☐	PIQTRCOSESID	PIQTRSESSIONID	CHAR	4	0	Session In Which External Subject Was Taken	T7PIQTREXTSES
35	COSESYEAR	☐	PIQTRSESSIONYEAR	PIQTRSESSIONYEAR	NUMC	4	0	Year of Registration
36	COBEGDATE	☐	PIQTRCOBEGDATE		DATS	8	0	Start Date of Subject
37	COENDDATE	☐	PIQTRCOENDDATE		DATS	8	0	End Date of Subject
38	MARK	☐	PIQFLAG	FLAG	CHAR	1	0	General Indicator
39	INTSCALET	☐	PIQSCALE_TEXT	PIQSCALE_TEXT	CHAR	30	0	Academic Scale (Description)
40	INTCPUNITT	☐	PIQCPUNITT	TEXT25	CHAR	25	0	Description of Credit Type Unit
41	EXTSCALET	☐	PIQSCALE_TEXT	PIQSCALE_TEXT	CHAR	30	0	Academic Scale (Description)
42	EXTCPUNITT	☐	PIQCPUNITT	TEXT25	CHAR	25	0	Description of Credit Type Unit
43	AGMID	☐	PIQEDAGMID	SYSUUID_C	CHAR	32	0	ID of Transfer Regulation for External Achievement
44	AGMTEXT	☐	PIQEDAGMTEXT	TEXT40	CHAR	40	0	Transfer Regulation for External Achievement (Description)
45	.INCLUDE	☐				0	0	Display Structure for SMs in ED
46	MODULEID	☐	PIQMODULE	HROBJID	NUMC	8	0	Module ID (Object Type SM)	*
47	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
48	ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
49	SHORT	☐	PIQSMSHORT	TEXT12	CHAR	12	0	Module (Abbreviation)
50	STEXT	☐	PIQSMSTEXT	TEXT40	CHAR	40	0	Module (Description)
51	SCALE	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	*
52	SCALET	☐	PIQSCALE_TEXT	PIQSCALE_TEXT	CHAR	30	0	Academic Scale (Description)
53	CPMIN	☐	PIQCPMIN	PIQCP	QUAN	10	5	Minimum Credit Value
54	CPOPT	☐	PIQCPOPT	PIQCP	QUAN	10	5	Optimum Credit Value
55	CPMAX	☐	PIQCPMAX	PIQCP	QUAN	10	5	Maximum Credit Value
56	CPUNIT	☐	PIQCPUNIT	MEINS	UNIT	3	0	Unit of Measurement for Credits	*
57	CPUNITT	☐	PIQCPUNITT	TEXT25	CHAR	25	0	Description of Credit Type Unit
58	DISZIP	☐	PIQSMDISZIP	PIQSMDISZIP	CHAR	16	0	Discipline	*
59	DISZIPT	☐	PIQSMDISZIPT	TEXT100	CHAR	100	0	Discipline (Description)
60	SEVERITY	☐	PIQSMSEVRITY	PIQSEVERITY	NUMC	4	0	Academic Level of Module	*
61	SEVERITYT	☐	PIQSMSEVRITYT	TEXT40	CHAR	40	0	Academic Level of Module (Description)
62	COL	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
63	T_COL	☐	LVC_T_SCOL		TTYP	0	0
64	T_EDIT	☐	LVC_T_STYL		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQED464_D	BASFORCOCRED	T7PIQTRBASFORCP	BASISFORCP	KEY	1	CN
2	PIQED464_D	COSESID	T7PIQTREXTSES	SESSIONID	KEY	1	CN
3	PIQED464_D	EXTCOCREDTYPE	T7PIQCP	CPUNIT	KEY	1	CN
4	PIQED464_D	EXTGRADESCALE	T7PIQSCALE	SCALEID	KEY	1	CN
5	PIQED464_D	INTGRADESCALE	T7PIQSCALE	SCALEID	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in