SAP ABAP Table PIQTR_SULIST_VSR (List of External Subjects)

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	PIQTR_SULIST_VSR	Table Relationship Diagram
Short Description	List of External Subjects

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	TRANS_GUID_HD	☐	PIQTRTRANS_GUID	SYSUUID_C	CHAR	32	0	GUID - Unique ID of External Transcript
2	ISSEO_HD	☐	PIQTRISSEO	HROBJID	NUMC	8	0	Issuing External Organization	*
3	TRANSTYPE_HD	☐	PIQTRTRANSTYPE	PIQTRTRANSTYPE	CHAR	4	0	Transcript Category	*
4	TRSTATUS_HD	☐	PIQREPSTATE	PIQREPSTATE	CHAR	4	0	Transcript Status	*
5	ISSUE_DATE	☐	BEGDA	DATUM	DATS	8	0	Start Date
6	VALID_DATE	☐	ENDDA	DATUM	DATS	8	0	End Date
7	.INCLU-_SU	☐				0	0	External Subject Data
8	COURSEID_SU	☐	PIQTRCOURSEID	HROBJID	NUMC	8	0	Registered Subject	*
9	EXTGRADE_SU	☐	PIQTREXTGRADE		CHAR	10	0	Original Grade in External Subject
10	EXTGRADENORM_SU	☐	PIQTREXTGRADENORM	PIQSCALE_NORM_VAL	DEC	8	2	Original Grade per Subject (Standard Value)
11	EXTGRADESCALE_SU	☐	PIQTREXTGRADESCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for Original Grade	T7PIQSCALE
12	GRADEMANFLAG_SU	☐	PIQTRGRADEMANFLAG		CHAR	1	0	Overwrite Converted Original Grade of External Subject
13	INTGRADE_SU	☐	PIQTRINTGRADE		CHAR	10	0	Original Grade in External Subject on Internal Grading Scale
14	INTGRADENORM_SU	☐	PIQTRINTGRADENORM	PIQSCALE_NORM_VAL	DEC	8	2	Converted Grade per Subject (Standard Value)
15	INTGRADESCALE_SU	☐	PIQTRINTGRADESCALE	PIQSCALE_ID	CHAR	4	0	Internal Grading Scale for Converted Grade per Subject	T7PIQSCALE
16	COREPEATFLAG_SU	☐	PIQTRCOREPEATFLAG		CHAR	1	0	Indicator: Repeated Subject
17	HONORSINDIC_SU	☐	PIQTRHONORSINDIC		CHAR	1	0	Indicator: Honors Subject
18	EXTCOATMCRED_SU	☐	PIQTREXTCOATMCRED	PIQCP	QUAN	10	5	Attempted Credits in External Subject
19	EXTCOGRDCRED_SU	☐	PIQTREXTCOGRDCRED	PIQCP	QUAN	10	5	Graded Credits in External Subject
20	EXTCOERNCRED_SU	☐	PIQTREXTCOERNCRED	PIQCP	QUAN	10	5	Earned Credits in External Subject
21	EXTCOCREDTYPE_SU	☐	PIQTREXTCOCREDTYPE	MEINS	UNIT	3	0	Original Credit Type of External Subject	T7PIQCP
22	COCREDMANFLAG_SU	☐	PIQTRCOCREDMANFLAG		CHAR	1	0	Overwrite Converted Credits Per External Subject Manually
23	INTCOATMCRED_SU	☐	PIQTRINTCOATMCRED	PIQCP	QUAN	10	5	Attempted Credits in Ext. Subject in Internal Credit Type
24	INTCOGRDCRED_SU	☐	PIQTRINTCOGRDCRED	PIQCP	QUAN	10	5	Graded Credits in Ext. Subject in Internal Credit Type
25	INTCOERNCRED_SU	☐	PIQTRINTCOERNCRED	PIQCP	QUAN	10	5	Earned Credits in Ext. Subject in Internal Credit Type
26	INTCOCREDTYPE_SU	☐	PIQTRINTCOCREDTYPE	MEINS	UNIT	3	0	Internal Credit Type	T7PIQCP
27	BASFORCOCRED_SU	☐	PIQTRBASFORCOCRED	PIQTRBASFORCRED	CHAR	4	0	Basis for Accomplished Credits	T7PIQTRBASFORCP
28	COREFLAG_SU	☐	PIQTRCOREFLAG		CHAR	1	0	Indicator for Core Subject
29	COWITHDRDATE_SU	☐	PIQTRCOWITHDRDATE		DATS	8	0	Date of Withdrawal
30	COSESID_SU	☐	PIQTRCOSESID	PIQTRSESSIONID	CHAR	4	0	Session In Which External Subject Was Taken	T7PIQTREXTSES
31	COSESYEAR_SU	☐	PIQTRCOSESYEAR	PIQTRSESSIONYEAR	NUMC	4	0	Year In Which Subject Was Taken
32	COBEGDATE_SU	☐	PIQTRCOBEGDATE		DATS	8	0	Start Date of Subject
33	COENDDATE_SU	☐	PIQTRCOENDDATE		DATS	8	0	End Date of Subject

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQTR_SULIST_VSR	BASFORCOCRED_SU	T7PIQTRBASFORCP	BASISFORCP	KEY	1	CN
2	PIQTR_SULIST_VSR	COSESID_SU	T7PIQTREXTSES	SESSIONID	KEY	1	CN
3	PIQTR_SULIST_VSR	EXTCOCREDTYPE_SU	T7PIQCP	CPUNIT	KEY	1	CN
4	PIQTR_SULIST_VSR	EXTGRADESCALE_SU	T7PIQSCALE	SCALEID	KEY	1	CN
5	PIQTR_SULIST_VSR	INTCOCREDTYPE_SU	T7PIQCP	CPUNIT	KEY	1	CN
6	PIQTR_SULIST_VSR	INTGRADESCALE_SU	T7PIQSCALE	SCALEID	KEY	1	CN

History

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