SAP ABAP Table PIQEDEXTQUAL_D (Display Structure for Ext. Qualifications 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	PIQEDEXTQUAL_D	Table Relationship Diagram
Short Description	Display Structure for Ext. Qualifications 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_EQ	☐	PIQTRISSEO	HROBJID	NUMC	8	0	Issuing External Organization	*
2	ISSEOT_EQ	☐	PIQEONAME	TEXT40	CHAR	40	0	Name of External Organization
3	TRANS_GUID_EQ	☐	PIQTRTRANS_GUID	SYSUUID_C	CHAR	32	0	GUID - Unique ID of External Transcript
4	TRTYPE_EQ	☐	PIQTRTRANSTYPE	PIQTRTRANSTYPE	CHAR	4	0	Transcript Category	*
5	TRTYPET_EQ	☐	PIQTRTRANSTYPET	TEXT20	CHAR	20	0	Transcript Category (Description)
6	.INCLUDE	☐				0	0	Display Structure for External Academic Qualifications
7	DEGREENR	☐	PIQTRDEGREENR		NUMC	2	0	Number of Degree/Qualification
8	DEGREEID	☐	PIQTRDEGREEID	HROBJID	NUMC	8	0	Degree/Qualification	*
9	DEGREESHORT	☐	PIQTRDEGREESHORT	CHAR12	CHAR	12	0	Degree/Qualification (Abbreviation)
10	DEGREESTEXT	☐	PIQTRDEGREESTEXT	TEXT40	CHAR	40	0	Degree or Qualification (Description)
11	PROGRAMID	☐	PIQTRPROGRAMID		CHAR	12	0	Registered Program
12	DEGERNFLAG	☐	PIQTRDEGERNFLAG	PIQTRDEGERNFLAG	CHAR	1	0	Indicator: Degree or Qualification Earned
13	DEGDATE	☐	PIQTRDEGDATE		DATS	8	0	(Anticipated) Completion Date
14	DEGEXTGRADE	☐	PIQTRDEGEXTMARK		CHAR	10	0	External Grade Achieved in Qualification
15	DEGEXTGRADETEXT	☐	PIQTRDEGEXTGRADETEXT	PIQSCALE_GRADETEXT	CHAR	20	0	External Grade of Achieved Qualification (Description)
16	DEGEXTGRADENORM	☐	PIQTRDEGEXTGRADENORM	PIQSCALE_NORM_VAL	DEC	8	2	External Grade of Achieved Qualification (Std Value)
17	DEGEXTSCALEID	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
18	DEGMANFLAG	☐	PIQTRDEGMANFLAG		CHAR	1	0	Overwrite Internal Grade of Qualification Manually
19	DEGINTGRADE	☐	PIQTRDEGINTGRADE		CHAR	10	0	Internal Grade of Achieved Qualification
20	DEGINTGRADETEXT	☐	PIQTRDEGINTGRADETEXT	PIQSCALE_GRADETEXT	CHAR	20	0	Internal Grade of Achieved Qualification (Text)
21	DEGINTGRADENORM	☐	PIQTRDEGINTGRADENORM	PIQSCALE_NORM_VAL	DEC	8	2	Internal Grade of Achieved Qualification (Std Value)
22	DEGINTSCALEID	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
23	DEGHONORS	☐	PIQTRDEGHONORS	PIQTRDEGHONORS	CHAR	4	0	Academic Honors in Qualification	T7PIQTRDEGHON
24	INTSCALET	☐	PIQSCALE_TEXT	PIQSCALE_TEXT	CHAR	30	0	Academic Scale (Description)
25	EXTSCALET	☐	PIQSCALE_TEXT	PIQSCALE_TEXT	CHAR	30	0	Academic Scale (Description)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQEDEXTQUAL_D	DEGEXTSCALEID	T7PIQSCALE	SCALEID	KEY	1	CN
2	PIQEDEXTQUAL_D	DEGHONORS	T7PIQTRDEGHON	DEGHONORS	KEY	1	CN
3	PIQEDEXTQUAL_D	DEGINTSCALEID	T7PIQSCALE	SCALEID	KEY	1	CN

History

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