SAP ABAP Table PIQTRSESSION_EXT (Academic Session (External Transcripts))
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 | PIQTRSESSION_EXT | Table Relationship Diagram |
Short Description | Academic Session (External 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 | SESSIONID | PIQTRSESSIONID | PIQTRSESSIONID | CHAR | 4 | 0 | External Academic Session | T7PIQTREXTSES | |
2 | SESSIONYEAR | PIQTRSESSIONYEAR | PIQTRSESSIONYEAR | NUMC | 4 | 0 | Year of Registration | ||
3 | SESBEGDATE | PIQTRSESBEGDATE | DATS | 8 | 0 | Start Date of Academic Session | |||
4 | SESENDDATE | PIQTRSESENDDATE | DATS | 8 | 0 | End Date of Academic Session | |||
5 | SESWITHDRDATE | PIQTRSESWITHDRDATE | DATS | 8 | 0 | De-registration Date | |||
6 | SESDEGREEID | PIQTRDEGREEID | HROBJID | NUMC | 8 | 0 | Degree/Qualification | * | |
7 | SESPROGRAMID | PIQTRPROGRAMID | CHAR | 12 | 0 | Registered Program | |||
8 | STAGEID | PIQTRSTAGEID | PIQLEVEL | NUMC | 2 | 0 | Registered Program Stage | T7PIQLEVEL | |
9 | PROGCLASSID | PIQTRPROGCLASSID | PIQPROGCLASS | CHAR | 4 | 0 | Progress Classification | T7PIQPROGCLASS | |
10 | PROGACST | PIQTRPROGACST | PIQTRPROGACST | CHAR | 4 | 0 | External Academic Standing | T7PIQTRPROGAS | |
11 | PROGSTAT | PIQPROGSTATUS | PIQPROGSTATUS | NUMC | 3 | 0 | Program Progression Status | T7PIQPROGSTATUS | |
12 | EXTSESGPA | PIQTREXTSESGPA | CHAR | 10 | 0 | External Sessional Average | |||
13 | EXTSESGPASCALE | PIQTREXTSESGPASCALE | PIQSCALE_ID | CHAR | 4 | 0 | Grading Scale for Original Sessional Average | T7PIQSCALE | |
14 | EXTSESATMCRED | PIQTREXTSESATMCRED | PIQCP | QUAN | 10 | 5 | Attempted Credits Per Academic Session | ||
15 | EXTSESGRDCRED | PIQTREXTSESGRDCRED | PIQCP | QUAN | 10 | 5 | Graded Credits Per Academic Session | ||
16 | EXTSESERNCRED | PIQTREXTSESERNCRED | PIQCP | QUAN | 10 | 5 | Earned Credits Per Academic Session | ||
17 | EXTSESCREDTYPE | PIQTREXTSESCREDTYPE | MEINS | UNIT | 3 | 0 | External Credit Type of Sessional Credits | T7PIQCP |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | PIQTRSESSION_EXT | EXTSESCREDTYPE | T7PIQCP | CPUNIT | 1 | CN | |
2 | PIQTRSESSION_EXT | EXTSESGPASCALE | T7PIQSCALE | SCALEID | 1 | CN | |
3 | PIQTRSESSION_EXT | PROGACST | T7PIQTRPROGAS | PROGACST | |||
4 | PIQTRSESSION_EXT | PROGCLASSID | T7PIQPROGCLASS | PROGCLASS | 1 | CN | |
5 | PIQTRSESSION_EXT | PROGSTAT | T7PIQPROGSTATUS | PROGSTATUS | 1 | CN | |
6 | PIQTRSESSION_EXT | SESSIONID | T7PIQTREXTSES | SESSIONID | 1 | CN | |
7 | PIQTRSESSION_EXT | STAGEID | T7PIQLEVEL | ACLEVEL | 1 | CN |
History
Last changed by/on | SAP | 20050224 |
SAP Release Created in | 463 |