SAP ABAP Table PIQDB_GB_CONTEXT (UCAS: Contextual Data)
Hierarchy
☛
IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
⤷ IS-HER-CM-GB (Application Component) United Kingdom
⤷ PMIQ_GB_UCASLINK (Package) Campus Management (Great Britain UCAS Link)
⤷ IS-HER-CM-GB (Application Component) United Kingdom
⤷ PMIQ_GB_UCASLINK (Package) Campus Management (Great Britain UCAS Link)
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | PIQDB_GB_CONTEXT | Table Relationship Diagram |
Short Description | UCAS: Contextual Data |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | SCHOOL_CODE | PIQ_GB_UCAS_SCHOOL_CODE | CHAR10 | CHAR | 10 | 0 | UCAS : School Code | ||
3 | SCH_YEAR | PIQ_GB_UCAS_YEAR_CODE | NUMC4 | NUMC | 4 | 0 | UCAS: Year code | ||
4 | AVG_QCA_ENTRY | PIQ_GB_UCAS_AVG_QCA_ENTRY | DEC | 7 | 1 | UCAS: Average QCA Points Per Qualification Per Entry | |||
5 | AVG_QCA_STUDENT | PIQ_GB_UCAS_AVG_QCA_STUD | DEC | 8 | 1 | UCAS: Average QCA Points Per Qualification Per Student | |||
6 | AVG_TARIFF_ENTRY | PIQ_GB_UCAS_AVG_TARIFF_ENTRY | DEC | 7 | 1 | Average Tariff Points Per Qualification Per Entry (Scottish) | |||
7 | AVG_TARIFF_STUDE | PIQ_GB_UCAS_AVG_TARIFF_STUD | DEC | 8 | 1 | Average Tariff Points Per Qual. Per Student (Scottish) | |||
8 | BEST_GCSE_PERF | PIQ_GB_UCAS_BEST_GCSEPERF | DEC | 6 | 1 | Best 8 GCSE Performance. | |||
9 | BEST_STD_PERF | PIQ_GB_UCAS_BEST_STDPERF | DEC | 6 | 1 | Best 8 SCQF level 4 Performance Score (Scottish) | |||
10 | EDU_MAINT_ALLWD | PIQ_GB_UCAS_EDUMAINTALWD | NUMC3 | NUMC | 3 | 0 | Percentage entitled to education maintenance allowance | ||
11 | FIVE_ACGCSE | PIQ_GB_UCAS_FIVE_ACGCSE | NUMC3 | NUMC | 3 | 0 | Percentage of students achieving GCSE | ||
12 | FIVE_ACSTD | PIQ_GB_UCAS_FIVE_ACSTD | NUMC3 | NUMC | 3 | 0 | Percentage of students achieving SCQF | ||
13 | FREE_SCH_MEALSEN | PIQ_GB_UCAS_SCH_MEALSENT | NUMC3 | NUMC | 3 | 0 | Percentage entitled to free school meals | ||
14 | FREE_SCH_MEALSRE | PIQ_GB_UCAS_SCH_MEALSREG | NUMC3 | NUMC | 3 | 0 | Percentage registered for free school meals (Scottish) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | PIQDB_GB_CONTEXT | MANDT | T000 | MANDT |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |