SAP ABAP Table PIQTRDEGREE (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
⤷ IS-HER-CM-AD (Application Component) Administration
⤷ PMIQ (Package) Campus Management
Basic Data
Table Category | INTTAB | Structure |
Structure | PIQTRDEGREE | Table Relationship Diagram |
Short Description | 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 | PROGRAMID | PIQTRPROGRAMID | CHAR | 12 | 0 | Registered Program | |||
4 | DEGERNFLAG | PIQTRDEGERNFLAG | PIQTRDEGERNFLAG | CHAR | 1 | 0 | Indicator: Degree or Qualification Earned | ||
5 | DEGDATE | PIQTRDEGDATE | DATS | 8 | 0 | (Anticipated) Completion Date | |||
6 | DEGEXTGRADE | PIQTRDEGEXTMARK | CHAR | 10 | 0 | External Grade Achieved in Qualification | |||
7 | DEGEXTGRADENORM | PIQTRDEGEXTGRADENORM | PIQSCALE_NORM_VAL | DEC | 8 | 2 | External Grade of Achieved Qualification (Std Value) | ||
8 | DEGEXTSCALEID | PIQSCALE_ID | PIQSCALE_ID | CHAR | 4 | 0 | Academic Scale Identification (ID) | T7PIQSCALE | |
9 | DEGMANFLAG | PIQTRDEGMANFLAG | CHAR | 1 | 0 | Overwrite Internal Grade of Qualification Manually | |||
10 | DEGINTGRADE | PIQTRDEGINTGRADE | CHAR | 10 | 0 | Internal Grade of Achieved Qualification | |||
11 | DEGINTGRADENORM | PIQTRDEGINTGRADENORM | PIQSCALE_NORM_VAL | DEC | 8 | 2 | Internal Grade of Achieved Qualification (Std Value) | ||
12 | DEGINTSCALEID | PIQSCALE_ID | PIQSCALE_ID | CHAR | 4 | 0 | Academic Scale Identification (ID) | T7PIQSCALE | |
13 | 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 | DEGEXTSCALEID | T7PIQSCALE | SCALEID | KEY | 1 | CN |
2 | PIQTRDEGREE | DEGHONORS | T7PIQTRDEGHON | DEGHONORS | KEY | 1 | CN |
3 | PIQTRDEGREE | DEGINTSCALEID | T7PIQSCALE | SCALEID | KEY | 1 | CN |
History
Last changed by/on | SAP | 20050224 |
SAP Release Created in | 463 |