SAP ABAP Table PIQEDTC_SYSTEM_DISP (System-Based 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	PIQEDTC_SYSTEM_DISP	Table Relationship Diagram
Short Description	System-Based 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	.INCLU-_EX	☐				0	0	Actvty Document: Equivalency - Ext. Acad. Work with Group
2	.INCLUDE	☐				0	0	Actvty Document: Equivalency - Ext. Acad. Work with Group
3	GRP_EX	☐	PIQEDGROUP	CHAR2	CHAR	2	0	Academic Work Grouping
4	.INCLUDE	☐				0	0	Activity Document: Equivalency - External Acad. Work
5	OTYPE_EX	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
6	OBJID_EX	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
7	COREPEATFLAG_EX	☐	PIQTRCOREPEATFLAG		CHAR	1	0	Indicator: Repeated Subject
8	HONORSINDIC_EX	☐	PIQTRHONORSINDIC		CHAR	1	0	Indicator: Honors Subject
9	EXTGRADESYM_EX	☐	PIQEDEXTGRADETR	PIQGRADESYM	CHAR	10	0	External Grade
10	EXTGRADE_EX	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
11	EXTGRADESCALE_EX	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	*
12	GRADEMANFLAG_EX	☐	PIQTRGRADEMANFLAG		CHAR	1	0	Overwrite Converted Original Grade of External Subject
13	INTGRADESYM_EX	☐	PIQEDINTGRADETR	PIQGRADESYM	CHAR	10	0	Internal Grade
14	INTGRADE_EX	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
15	INTGRADESCALE_EX	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
16	EXTCOATMCRED_EX	☐	PIQTREXTCOATMCRED	PIQCP	QUAN	10	5	Attempted Credits in External Subject
17	EXTCOGRDCRED_EX	☐	PIQTREXTCOGRDCRED	PIQCP	QUAN	10	5	Graded Credits in External Subject
18	EXTCOERNCRED_EX	☐	PIQTREXTCOERNCRED	PIQCP	QUAN	10	5	Earned Credits in External Subject
19	EXTCOCREDTYPE_EX	☐	PIQTREXTCOCREDTYPE	MEINS	UNIT	3	0	Original Credit Type of External Subject	*
20	COCREDMANFLAG_EX	☐	PIQTRCOCREDMANFLAG		CHAR	1	0	Overwrite Converted Credits Per External Subject Manually
21	INTCOATMCRED_EX	☐	PIQTRINTCOATMCRED	PIQCP	QUAN	10	5	Attempted Credits in Ext. Subject in Internal Credit Type
22	INTCOGRDCRED_EX	☐	PIQTRINTCOGRDCRED	PIQCP	QUAN	10	5	Graded Credits in Ext. Subject in Internal Credit Type
23	INTCOERNCRED_EX	☐	PIQTRINTCOERNCRED	PIQCP	QUAN	10	5	Earned Credits in Ext. Subject in Internal Credit Type
24	INTCOCREDTYPE_EX	☐	PIQTRINTCOCREDTYPE	MEINS	UNIT	3	0	Internal Credit Type	*
25	BASFORCOCRED_EX	☐	PIQTRBASFORCOCRED	PIQTRBASFORCRED	CHAR	4	0	Basis for Accomplished Credits	*
26	COWITHDRDATE_EX	☐	PIQTRCOWITHDRDATE		DATS	8	0	Date of Withdrawal
27	COSESID_EX	☐	PIQTRCOSESID	PIQTRSESSIONID	CHAR	4	0	Session In Which External Subject Was Taken	*
28	COSESYEAR_EX	☐	PIQTRCOSESYEAR	PIQTRSESSIONYEAR	NUMC	4	0	Year In Which Subject Was Taken
29	COBEGDATE_EX	☐	PIQTRCOBEGDATE		DATS	8	0	Start Date of Subject
30	COENDDATE_EX	☐	PIQTRCOENDDATE		DATS	8	0	End Date of Subject
31	AWSTATUS_EX	☐	PIQEDEXTAWSTATUS	PIQEDAWSTATUS	CHAR	1	0	Status of External Academic Work or Qualification
32	EQCONFERDATE_EX	☐	PIQTRDEGDATE		DATS	8	0	(Anticipated) Completion Date
33	.INCLUDE	☐				0	0	Equivalency Activity Document - Text Fields
34	SHORT_EX	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
35	STEXT_EX	☐	STEXT	TEXT40	CHAR	40	0	Object Name
36	OTYPET_EX	☐	PIQEDOTYPE_EXT_TEXT	TEXT25	CHAR	25	0	Object Type of External Academic Achievement (Description)
37	SCALEINT_EX	☐	PIQSCALETEXT	PIQSCALE_TEXT	CHAR	30	0	Scale (Description)
38	SCALEEXT_EX	☐	PIQSCALETEXT	PIQSCALE_TEXT	CHAR	30	0	Scale (Description)
39	.INCLUDE	☐				0	0	Equivalency Determination: Icons for Academic Work
40	OTYPE_ICON_EX	☐	PIQOTYPE_ICON	PIQICON_QF	CHAR	37	0	Object Type Icon
41	DETAIL_ICON_EX	☐	PIQEDDETAIL_ICON	PIQICON_QF	CHAR	37	0	Icon: External Work Details
42	.INCLU-_IN	☐				0	0	Activity Document (ED): Internal Academic Work with Group
43	.INCLUDE	☐				0	0	ED Activity Document: Internal Academic Work with Group
44	GRP_IN	☐	PIQEDGROUP	CHAR2	CHAR	2	0	Academic Work Grouping
45	.INCLUDE	☐				0	0	ED Activity Document: Internal Academic Work
46	OTYPE_IN	☐	PIQEDINTOTYPE	PIQED_INTOTYPE	CHAR	2	0	Object Type of Internal Academic Achievement
47	OBJID_IN	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
48	GRADESYM_IN	☐	PIQGRADESYM	PIQGRADESYM	CHAR	10	0	Grade Symbol
49	GRADE_IN	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
50	GRADESCALE_IN	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
51	.INCLUDE	☐				0	0	Credits
52	CPATTEMP_IN	☐	PIQCPATTEMP	PIQCP	QUAN	10	5	Attempted Credits
53	CPEARNED_IN	☐	PIQCPEARNED	PIQCP	QUAN	10	5	Earned Credits
54	CPGRADED_IN	☐	PIQCPGRADED	PIQCP	QUAN	10	5	Graded Credits
55	CPUNIT_IN	☐	PIQCPUNIT	MEINS	UNIT	3	0	Unit of Measurement for Credits	T7PIQCP
56	PROGC_VAR_IN	☐	PIQPROGC_VAR	PIQPROGC_VAR	CHAR	4	0	Program Type	T7PIQPROGCVAR
57	SC_OBJID_IN	☐	PIQSCOBJID	HROBJID	NUMC	8	0	Program ID	*
58	TRANSFERBOOKID_IN	☐	PIQEDTRANSFERID	SYSUUID_C	CHAR	32	0	Relationship Identifier (ID)
59	AWSTATUS_IN	☐	PIQEDINTAWSTATUS	PIQEDAWSTATUS	CHAR	1	0	Status of Internal Academic Work or Qualification
60	PERYR_IN	☐	PIQEDINTYEAR	PIQPERYR	NUMC	4	0	Assigned Academic Year of Internal Academic Work/Qualif.	T7PIQYEAR
61	PERID_IN	☐	PIQEDINTSESSION	PIQPERID	NUMC	3	0	Assigned Academic Session of Internal Academic Work/Qualif.	T7PIQPERIOD
62	AGRBEGDA_IN	☐	PIQAGRBEGDA	PIQDATE	DATS	8	0	Start of Appraisal Validity
63	AGRENDDA_IN	☐	PIQAGRENDDA	PIQDATE	DATS	8	0	End of Appraisal Validity
64	.INCLUDE	☐				0	0	Structure for Internal Work: Icons
65	DEL_ICON_IN	☐	PIQEDDELICON	PIQICON_QF	CHAR	37	0	Icon: Delete Internal Academic Work or Qualification
66	.INCLUDE	☐				0	0	Equivalency Determination: Icons for Academic Work
67	OTYPE_ICON_IN	☐	PIQOTYPE_ICON	PIQICON_QF	CHAR	37	0	Object Type Icon
68	DETAIL_ICON_IN	☐	PIQEDDETAIL_ICON	PIQICON_QF	CHAR	37	0	Icon: External Work Details
69	.INCLUDE	☐				0	0	Internal Academic Work (Texts)
70	SHORT_IN	☐	PIQEDINT_SHORT	TEXT12	CHAR	12	0	Internal Academic Achievement (Abbreviation)
71	STEXT_IN	☐	STEXT	TEXT40	CHAR	40	0	Object Name
72	OTYPET_IN	☐	PIQEDOTYPE_INT_TEXT	TEXT25	CHAR	25	0	Object Type of Internal Work/Qualification (Description)
73	SCALET_IN	☐	PIQSCALETEXT	PIQSCALE_TEXT	CHAR	30	0	Scale (Description)
74	PROGC_VART_IN	☐	PIQPROGC_VART	TEXT30	CHAR	30	0	Program Type (Description)
75	GRADESYMT_IN	☐	PIQSCALE_GRADETEXT	PIQSCALE_GRADETEXT	CHAR	20	0	Scale Value (Description)
76	.INCLUDE	☐				0	0	Icons for Equiv. Determination: Work Area for Table Control
77	CUT_CONN_ICON	☐	PIQEDCUTCONNECTION_ICON	PIQICON_QF	CHAR	37	0	Icon: Remove Grouping
78	NOTE_ICON	☐	PIQEDNOTE_ICON	PIQICON_QF	CHAR	37	0	Icon: Note for an Equivalency
79	INTAWSTATUS_ICON	☐	PIQEDINTAWSTATUS_ICON	PIQICON_QF	CHAR	37	0	Symbol for Internal Academic Work/Qualification Status
80	EXTAWSTATUS_ICON	☐	PIQEDEXTAWSTATUS_ICON	PIQICON_QF	CHAR	37	0	Symbol for External Academic Work/Qualification Status
81	AGMID	☐	PIQEDAGMID	SYSUUID_C	CHAR	32	0	ID of Transfer Regulation for External Achievement

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQEDTC_SYSTEM_DISP	CPUNIT_IN	T7PIQCP	CPUNIT	KEY	1	CN
2	PIQEDTC_SYSTEM_DISP	GRADESCALE_IN	T7PIQSCALE	SCALEID
3	PIQEDTC_SYSTEM_DISP	INTGRADESCALE_EX	T7PIQSCALE	SCALEID
4	PIQEDTC_SYSTEM_DISP	OTYPE_EX	T778O	OTYPE
5	PIQEDTC_SYSTEM_DISP	PERID_IN	T7PIQPERIOD	PERID
6	PIQEDTC_SYSTEM_DISP	PERYR_IN	T7PIQYEAR	PERYR
7	PIQEDTC_SYSTEM_DISP	PROGC_VAR_IN	T7PIQPROGCVAR	PROGC_VAR

History

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