SAP ABAP Table PIQTRDEGREE_D (Display Structure for External Academic Qualifications)

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	PIQTRDEGREE_D	Table Relationship Diagram
Short Description	Display Structure for External Academic Qualifications

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	DEGREENR	☐	PIQTRDEGREENR		NUMC	2	0	Number of Degree/Qualification
2	DEGREEID	☐	PIQTRDEGREEID	HROBJID	NUMC	8	0	Degree/Qualification	*
3	DEGREESHORT	☐	PIQTRDEGREESHORT	CHAR12	CHAR	12	0	Degree/Qualification (Abbreviation)
4	DEGREESTEXT	☐	PIQTRDEGREESTEXT	TEXT40	CHAR	40	0	Degree or Qualification (Description)
5	PROGRAMID	☐	PIQTRPROGRAMID		CHAR	12	0	Registered Program
6	DEGERNFLAG	☐	PIQTRDEGERNFLAG	PIQTRDEGERNFLAG	CHAR	1	0	Indicator: Degree or Qualification Earned
7	DEGDATE	☐	PIQTRDEGDATE		DATS	8	0	(Anticipated) Completion Date
8	DEGEXTGRADE	☐	PIQTRDEGEXTMARK		CHAR	10	0	External Grade Achieved in Qualification
9	DEGEXTGRADETEXT	☐	PIQTRDEGEXTGRADETEXT	PIQSCALE_GRADETEXT	CHAR	20	0	External Grade of Achieved Qualification (Description)
10	DEGEXTGRADENORM	☐	PIQTRDEGEXTGRADENORM	PIQSCALE_NORM_VAL	DEC	8	2	External Grade of Achieved Qualification (Std Value)
11	DEGEXTSCALEID	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
12	DEGMANFLAG	☐	PIQTRDEGMANFLAG		CHAR	1	0	Overwrite Internal Grade of Qualification Manually
13	DEGINTGRADE	☐	PIQTRDEGINTGRADE		CHAR	10	0	Internal Grade of Achieved Qualification
14	DEGINTGRADETEXT	☐	PIQTRDEGINTGRADETEXT	PIQSCALE_GRADETEXT	CHAR	20	0	Internal Grade of Achieved Qualification (Text)
15	DEGINTGRADENORM	☐	PIQTRDEGINTGRADENORM	PIQSCALE_NORM_VAL	DEC	8	2	Internal Grade of Achieved Qualification (Std Value)
16	DEGINTSCALEID	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
17	DEGHONORS	☐	PIQTRDEGHONORS	PIQTRDEGHONORS	CHAR	4	0	Academic Honors in Qualification	T7PIQTRDEGHON

Foreign Keys

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

History

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