SAP ABAP Table PIQEDRUN_EXT_W (External Academic Achievement in ED Run)

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	PIQEDRUN_EXT_W	Table Relationship Diagram
Short Description	External Academic Achievement in ED Run

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	ED Run GUID
2	GUIDTYPE	☐	PIQGUIDTYPE	PIQGUIDTYPE	CHAR	4	0	Identifier Type (GUID)	*
3	GUID	☐	PIQEDGUID	PIQPROC_DOCID	CHAR	32	0	Equivalency Identifier (ID)	*
4	.INCLUDE	☐				0	0	External Academic Achievement in Equivalency Set
5	GRP	☐	PIQEDGROUP	CHAR2	CHAR	2	0	Academic Work Grouping
6	AGMID	☐	PIQEDAGMID	SYSUUID_C	CHAR	32	0	ID of Transfer Regulation for External Achievement
7	.INCLUDE	☐				0	0	Activity Document: Equivalency - External Acad. Work
8	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
9	OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
10	COREPEATFLAG	☐	PIQTRCOREPEATFLAG		CHAR	1	0	Indicator: Repeated Subject
11	HONORSINDIC	☐	PIQTRHONORSINDIC		CHAR	1	0	Indicator: Honors Subject
12	EXTGRADESYM	☐	PIQEDEXTGRADETR	PIQGRADESYM	CHAR	10	0	External Grade
13	EXTGRADE	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
14	EXTGRADESCALE	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	*
15	GRADEMANFLAG	☐	PIQTRGRADEMANFLAG		CHAR	1	0	Overwrite Converted Original Grade of External Subject
16	INTGRADESYM	☐	PIQEDINTGRADETR	PIQGRADESYM	CHAR	10	0	Internal Grade
17	INTGRADE	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
18	INTGRADESCALE	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
19	EXTCOATMCRED	☐	PIQTREXTCOATMCRED	PIQCP	QUAN	10	5	Attempted Credits in External Subject
20	EXTCOGRDCRED	☐	PIQTREXTCOGRDCRED	PIQCP	QUAN	10	5	Graded Credits in External Subject
21	EXTCOERNCRED	☐	PIQTREXTCOERNCRED	PIQCP	QUAN	10	5	Earned Credits in External Subject
22	EXTCOCREDTYPE	☐	PIQTREXTCOCREDTYPE	MEINS	UNIT	3	0	Original Credit Type of External Subject	*
23	COCREDMANFLAG	☐	PIQTRCOCREDMANFLAG		CHAR	1	0	Overwrite Converted Credits Per External Subject Manually
24	INTCOATMCRED	☐	PIQTRINTCOATMCRED	PIQCP	QUAN	10	5	Attempted Credits in Ext. Subject in Internal Credit Type
25	INTCOGRDCRED	☐	PIQTRINTCOGRDCRED	PIQCP	QUAN	10	5	Graded Credits in Ext. Subject in Internal Credit Type
26	INTCOERNCRED	☐	PIQTRINTCOERNCRED	PIQCP	QUAN	10	5	Earned Credits in Ext. Subject in Internal Credit Type
27	INTCOCREDTYPE	☐	PIQTRINTCOCREDTYPE	MEINS	UNIT	3	0	Internal Credit Type	*
28	BASFORCOCRED	☐	PIQTRBASFORCOCRED	PIQTRBASFORCRED	CHAR	4	0	Basis for Accomplished Credits	*
29	COWITHDRDATE	☐	PIQTRCOWITHDRDATE		DATS	8	0	Date of Withdrawal
30	COSESID	☐	PIQTRCOSESID	PIQTRSESSIONID	CHAR	4	0	Session In Which External Subject Was Taken	*
31	COSESYEAR	☐	PIQTRCOSESYEAR	PIQTRSESSIONYEAR	NUMC	4	0	Year In Which Subject Was Taken
32	COBEGDATE	☐	PIQTRCOBEGDATE		DATS	8	0	Start Date of Subject
33	COENDDATE	☐	PIQTRCOENDDATE		DATS	8	0	End Date of Subject
34	AWSTATUS	☐	PIQEDEXTAWSTATUS	PIQEDAWSTATUS	CHAR	1	0	Status of External Academic Work or Qualification
35	EQCONFERDATE	☐	PIQTRDEGDATE		DATS	8	0	(Anticipated) Completion Date
36	.INCLUDE	☐				0	0	Equivalency Activity Document - Text Fields
37	SHORT	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
38	STEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
39	OTYPET	☐	PIQEDOTYPE_EXT_TEXT	TEXT25	CHAR	25	0	Object Type of External Academic Achievement (Description)
40	SCALEINT	☐	PIQSCALETEXT	PIQSCALE_TEXT	CHAR	30	0	Scale (Description)
41	SCALEEXT	☐	PIQSCALETEXT	PIQSCALE_TEXT	CHAR	30	0	Scale (Description)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQEDRUN_EXT_W	INTGRADESCALE	T7PIQSCALE	SCALEID
2	PIQEDRUN_EXT_W	OTYPE	T778O	OTYPE

History

Last changed by/on	SAP	20060920
SAP Release Created in