SAP ABAP Table PIQ_UCAS_APPS_RESULTS (UCAS : Applicant exam Results)
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 INTTAB    Structure 
Structure PIQ_UCAS_APPS_RESULTS   Table Relationship Diagram
Short Description UCAS : Applicant exam Results    
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 INSTCODE PIQ_GB_UCAS_INST_ID1 PIQ_GB_UCAS_INST_ID CHAR 4   0   UCAS: Institution Code *
2 APPLICANT_NO PIQ_GB_UCAS_APPLICANT_ID PIQ_GB_UCAS_APPLICANT_ID NUMC 9   0   UCAS: Applicant number  
3 PERSONALID PIQ_GB_UCAS_PERSONALID PIQ_GB_UCAS_PERSONALID CHAR 10   0   UCAS : ucaslink Personal Id  
4 ADMISSION_SYS PIQ_GB_UCAS_ADMISSION_SYSTEM PIQ_GB_UCAS_ADMISSION_SYSTEM CHAR 1   0   UCAS : Admission system  
5 SUBJECT PIQ_GB_UCAS_SUBJ_EBL PIQ_GB_UCAS_SUBJ_EBL CHAR 3   0   CM UCAS: EBL Subject Code *
6 ORGMARK PIQORGMARK PIQORGMARK CHAR 10   0   Original Grade T7PIQ_GB_POINTS
7 QUALITY PIQ_GB_UCAS_GRADE_TYPE PIQ_GB_UCAS_GRADE_TYPE CHAR 4   0   UCAS: Grade type (Qualification) T7PIQ_GB_RESTYP
8 EXAM_LEVEL_CODE PIQ_GB_EXAM_LEVEL_CODE PIQ_GB_EXAM_LEVEL_CODE CHAR 4   0   UCAS Exam Level Code *
9 GRADE_BAND PIQ_GB_UCAS_GRADE_BAND PIQ_GB_UCAS_GRADE_BAND CHAR 4   0   UCAS: Special paper grade band  
10 GRADE_2 PIQ_GB_UCAS_GRADE PIQ_GB_UCAS_GRADE CHAR 1   0   UCAS: Grade 2 T7PIQ_GB_POINTS
11 EXAM_BOARD PIQ_GB_UCAS_EX_BOARD PIQ_GB_UCAS_EX_BOARD CHAR 1   0   UCAS: Exam Board Code T7PIQ_GB_EBOARD
12 MARKDATE PIQMARKDATE   DATS 8   0   Reference Date for Grade  
13 SITTING PIQ_GB_UCAS_SITTNG PIQ_GB_UCAS_SITTNG CHAR 1   0   UCAS: Sitting  
14 EXAM_YY PIQ_GB_UCAS_EXAM_YEAR PIQPERYR NUMC 4   0   UCAS: Exam Year *
15 AEDTM_UCAS PIQ_GB_UCAS_AEDTM DATS DATS 8   0   UCAS: Date of the last change made by UCAS  
16 UZEIT_UCAS PIQ_GB_UCAS_UZEIT UZEIT TIMS 6   0   UCAS: Time of the last change made by UCAS  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 PIQ_UCAS_APPS_RESULTS EXAM_BOARD T7PIQ_GB_EBOARD EXAM_BOARD REF 1 CN
2 PIQ_UCAS_APPS_RESULTS GRADE_2 T7PIQ_GB_POINTS GRADE_2    
3 PIQ_UCAS_APPS_RESULTS ORGMARK T7PIQ_GB_POINTS GRADE    
4 PIQ_UCAS_APPS_RESULTS QUALITY T7PIQ_GB_RESTYP QUALITY REF    
History
Last changed by/on SAP  20130529 
SAP Release Created in 472