- Home
- Resources
- SAP Tables
- PIQ_UCAS_STAR_K - UCAS: Coded Information (Type *K)
SAP Table PIQ_UCAS_STAR_K
UCAS: Coded Information (Type *K)
PIQ_UCAS_STAR_K (UCAS: Coded Information (Type *K)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link PIQ_UCAS_STAR_K to other SAP tables.
Source: PIQ_UCAS_STAR_K (UCAS: Coded Information (Type *K))
PIQ_UCAS_STAR_K table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| APPLICANTID |
UCAS: Applicant number |
PIQ_GB_UCAS_APPLICANT_ID |
|
NUMC |
|
9 |
0 |
|
| REASON |
|
|
|
CHAR |
|
1 |
0 |
|
| CHA_DATE |
|
|
|
CHAR |
|
6 |
0 |
|
| CWD |
UCAS: Choice withdrew totally or re-instatement |
PIQ_GB_UCAS_CWD_FLAG |
|
CHAR |
|
1 |
0 |
Possible values
| C |
Completely Withdrawn |
| R |
Re-Instated |
|
| CHA_CWD |
|
|
|
CHAR |
|
6 |
0 |
|
| UCAS_FIRST |
|
|
|
CHAR |
|
6 |
0 |
|
| RUN_NO |
|
|
|
NUMC |
|
3 |
0 |
|
| BIRTHDATE |
|
|
|
CHAR |
|
6 |
0 |
|
| SCHOOL |
CM UCAS: School ID |
PIQ_GB_UCAS_SCHOOL_STAR_K |
|
CHAR |
|
5 |
0 |
|
| SEX |
|
|
|
CHAR |
|
1 |
0 |
|
| RES_CAT |
|
|
|
CHAR |
|
1 |
0 |
|
| NEEDS |
UCAS Special Needs |
UCAS_NEEDS |
|
CHAR |
|
1 |
0 |
|
| DOMICILE |
UCAS: Domicile (County) Code |
UCAS_DOMICILE |
|
NUMC |
|
3 |
0 |
|
| BIRTH_COUNTRY |
UCAS Country of Birth |
UCAS_BIRTH_COUNTRY |
|
NUMC |
|
3 |
0 |
|
| NATION |
UCAS Nationality Code |
UCAS_NATION |
|
NUMC |
|
3 |
0 |
|
| FEE_PAY |
|
|
|
NUMC |
|
2 |
0 |
|
| SUMMER_GCE_A_AS |
UCAS: No. of Summer GCE A/AS-Levels |
PIQ_GB_UCAS_GCE_A_AS |
|
NUMC |
|
1 |
0 |
|
| SUMMER_VCE_A_AS |
UCAS: No. of Summer VCE AS/A-Levels and Doubles |
PIQ_GB_UCAS_VCE_A_AS_DB |
|
NUMC |
|
1 |
0 |
|
| NOT_USED |
|
|
|
CHAR |
|
1 |
0 |
|
| SQA_FLAG |
UCAS: Flag SQA applicant |
PIQ_GB_UCAS_SQA_FLAG |
|
CHAR |
|
1 |
0 |
Possible values
|
| BTEC_FLAG |
UCAS: BTEC Flag |
PIQ_GB_UCAS_BTEC |
|
CHAR |
|
1 |
0 |
Possible values
|
| HIG_FLAG |
UCAS: HSC/IBAC Flag |
PIQ_GB_UCAS_HHIQ_FLAG |
|
CHAR |
|
1 |
0 |
|
| IRISH_FLAG |
UCAS: Irish Leaving Certification Flag |
PIQ_GB_UCAS_IRISH_FLAG |
|
CHAR |
|
1 |
0 |
Possible values
| I |
Irish Leaving Certification |
|
| WINTER_A |
UCAS: No. of Winter A-Levels |
PIQ_GB_UCAS_WINTER_A |
|
NUMC |
|
1 |
0 |
|
| PREV_SUMMER_A |
UCAS: No. of previous Summer A-Levels |
PIQ_GB_UCAS_PREV_A |
|
NUMC |
|
1 |
0 |
|
| OTHER_RESULTS |
UCAS: Other A/AS/Highers/CSYS Flag |
PIQ_GB_UCAS_OTHER_RESULTS |
|
CHAR |
|
1 |
0 |
Possible values
|
| EXAM_ACH |
UCAS: Record of Achievement |
PIQ_GB_UCAS_REC_ACHIEVMNT |
|
CHAR |
|
1 |
0 |
Possible values
|
| REG_NO |
Character Field Length = 10 |
CHAR10 |
|
CHAR |
|
10 |
0 |
|
| OEQ |
UCAS: OEQ Flag |
PIQ_GB_UCAS_QEQ |
|
CHAR |
|
1 |
0 |
|
| ROUTE_B |
|
|
|
CHAR |
|
1 |
0 |
|
| FILLER |
|
|
|
CHAR |
|
24 |
0 |
|
| EAS |
|
|
|
CHAR |
|
1 |
0 |
|
| REG2_NO |
UCAS: BTEC/SQA Scottish Cand. Number |
PIQ_GB_UCAS_REG_NUM |
|
CHAR |
|
13 |
0 |
|
| PREV_AS |
UCAS: No. of previous AS-Levels |
PIQ_GB_UCAS_PREV_AS |
|
NUMC |
|
1 |
0 |
|
| CHOICE_TRANS |
UCAS: Choices all transparent flag |
PIQ_GB_UCAS_CHOICE_TRANS |
|
CHAR |
|
1 |
0 |
Possible values
|
