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)
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