SAP ABAP Table PIQTRDEGREE_EXT_TXT (Text Structure for PIQTRDEGREE_EXT)

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_EXT_TXT	Table Relationship Diagram
Short Description	Text Structure for PIQTRDEGREE_EXT

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	Degree/Qualification (Ext. Transcripts)
2	DEGREENR	☐	PIQTRDEGREENR		NUMC	2	0	Number of Degree/Qualification
3	DEGREEID	☐	PIQTRDEGREEID	HROBJID	NUMC	8	0	Degree/Qualification	*
4	PROGRAMID	☐	PIQTRPROGRAMID		CHAR	12	0	Registered Program
5	DEGERNFLAG	☐	PIQTRDEGERNFLAG	PIQTRDEGERNFLAG	CHAR	1	0	Indicator: Degree or Qualification Earned
6	DEGDATE	☐	PIQTRDEGDATE		DATS	8	0	(Anticipated) Completion Date
7	DEGEXTGRADE	☐	PIQTRDEGEXTMARK		CHAR	10	0	External Grade Achieved in Qualification
8	DEGEXTSCALEID	☐	PIQTREXTGRADESCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for Original Grade	T7PIQSCALE
9	DEGHONORS	☐	PIQTRDEGHONORS	PIQTRDEGHONORS	CHAR	4	0	Academic Honors in Qualification	T7PIQTRDEGHON
10	.INCLUDE	☐				0	0	Texts for Structure PIQTRDEGREE_EXT
11	DEGREESHORT	☐	PIQTRDEGREESHORT	CHAR12	CHAR	12	0	Degree/Qualification (Abbreviation)
12	DEGREESTEXT	☐	PIQTRDEGREESTEXT	TEXT40	CHAR	40	0	Degree or Qualification (Description)
13	PROGRAMSHORT	☐	PIQSCSHORT	TEXT12	CHAR	12	0	Program (Abbreviation)
14	PROGRAMSTEXT	☐	PIQSCTXT	TEXT40	CHAR	40	0	Program Description
15	DEGEXTGRADETEXT	☐	PIQTRDEGEXTGRADETEXT	PIQSCALE_GRADETEXT	CHAR	20	0	External Grade of Achieved Qualification (Description)
16	DEGEXTGRADESCALET	☐	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	PIQTRDEGREE_EXT_TXT	DEGEXTSCALEID	T7PIQSCALE	SCALEID		1	CN
2	PIQTRDEGREE_EXT_TXT	DEGHONORS	T7PIQTRDEGHON	DEGHONORS		1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in