1 |
MANDT |
|
MANDT |
MANDT |
CLNT |
3 |
0 |
Client |
T000 |
2 |
TABNR |
|
HRTABNR |
HRTABNR |
CHAR |
32 |
0 |
Reference Number to Table Part |
HRITABNR |
3 |
TABSEQNR |
|
HRTABSEQNR |
NUM06 |
NUMC |
6 |
0 |
Sequence Number in Table Part of Table Infotype |
|
4 |
.INCLUDE |
|
|
|
|
0 |
0 |
UCAS Table Section Student's Choices (GB) |
|
5 |
CHOICE_NO |
|
PIQCHOICE_NO |
PIQCHOICE_NO |
NUMC |
2 |
0 |
Program Choice |
* |
6 |
INSTITUTION |
|
PIQ_GB_UCAS_INST_ID |
PIQ_GB_UCAS_INST_ID |
CHAR |
4 |
0 |
UCAS: Institution Code |
T7PIQ_GB_INST |
7 |
COURSE |
|
PIQ_GB_UCAS_COURSE |
PIQ_GB_UCAS_COURSE |
CHAR |
6 |
0 |
UCAS: Course Code |
T7PIQ_GB_COURSE |
8 |
SC_OBJID |
|
PIQSCOBJID |
HROBJID |
NUMC |
8 |
0 |
Program ID |
* |
9 |
CAMPUS |
|
PIQ_GB_UCAS_CAMPUS |
PIQ_GB_UCAS_CAMPUS |
CHAR |
1 |
0 |
UCAS: Campus Id |
* |
10 |
FACULTY |
|
PIQ_GB_UCAS_FACULTY |
PIQ_GB_UCAS_FACULTY |
CHAR |
1 |
0 |
UCAS: Faculty Id |
* |
11 |
DECISION |
|
PIQ_GB_UCAS_DECISION |
PIQ_GB_UCAS_DECISION |
CHAR |
1 |
0 |
UCAS: Decision made by the institution |
T7PIQ_GB_DECIS |
12 |
REPLY |
|
PIQ_GB_UCAS_REPLY |
PIQ_GB_UCAS_REPLY |
CHAR |
1 |
0 |
UCAS: Reply made by applicant |
T7PIQ_GB_REPLY |
13 |
CONDITIONS |
|
PIQ_GB_UCAS_CONDITIONS_SUM |
PIQ_GB_UCAS_CONDITIONS_SUM |
CHAR |
6 |
0 |
UCAS: Summary of conditions |
* |
14 |
ENTRY_DATE |
|
PIQ_GB_UCAS_ENTRY_DATE |
PIQ_GB_UCAS_ENTRY_DATE |
DATS |
8 |
0 |
UCAS: Date of Entry |
|
15 |
CHOICE_CANCEL |
|
PIQ_GB_UCAS_CHOICE_CANCEL |
PIQ_GB_UCAS_CHOICE_CANCEL |
CHAR |
1 |
0 |
UCAS:Choice cancelled by applicant |
|
16 |
AEDTM_UCAS |
|
PIQ_GB_UCAS_AEDTM |
DATS |
DATS |
8 |
0 |
UCAS: Date of the last change made by UCAS |
|
17 |
UCAS_ACTION |
|
PIQ_GB_UCAS_ACTION |
PIQ_GB_UCAS_ACTION |
CHAR |
1 |
0 |
UCAS: UCAS action |
T7PIQ_GB_UCASAC |
18 |
SUBSTITUTION |
|
PIQ_GB_UCAS_SUBSTITUTION |
PIQ_GB_UCAS_SUBSTITUTION |
CHAR |
1 |
0 |
UCAS: Substitution |
T7PIQ_GB_SUBSTI |
19 |
AMENDMENT |
|
PIQ_GB_UCAS_AMENDMENT |
PIQ_GB_UCAS_AMENDMENT |
CHAR |
1 |
0 |
UCAS: Amendment |
* |
20 |
PREV_COURSE |
|
PIQ_GB_UCAS_COURSE_OLD |
PIQ_GB_UCAS_COURSE |
CHAR |
6 |
0 |
UCAS: Previous Course code MARVIN |
* |
21 |
CONF_STATUS |
|
PIQ_GB_UCAS_CONF_STATUS |
PIQ_GB_UCAS_CONF_STATUS |
CHAR |
1 |
0 |
UCAS:Confirmation status |
T7PIQ_GB_STATUS |
22 |
CONF_HIST |
|
PIQ_GB_UCAS_CONF_HIST |
PIQ_GB_UCAS_CONF_HIST |
CHAR |
1 |
0 |
UCAS: Confirmation History |
T7PIQ_GB_CON_HI |
23 |
ENTRY_POINT |
|
PIQ_GB_UCAS_ENTRY_POINT |
PIQ_GB_UCAS_ENTRY_POINT |
CHAR |
1 |
0 |
UCAS: Point of Entry |
T7PIQ_GB_ENT_PN |
24 |
INTERV_PRIO |
|
PIQ_GB_UCAS_INTERV_PRIO |
PIQ_GB_UCAS_INTERV_PRIO |
CHAR |
1 |
0 |
UCAS: Priority of the interview |
T7PIQ_GB_INT_PRI |
25 |
HOME_INDIC |
|
PIQ_GB_UCAS_HOME_IND |
PIQ_GB_UCAS_HOME_IND |
CHAR |
1 |
0 |
UCAS: Live at home indicator |
|
26 |
.INCLUDE |
|
|
|
|
0 |
0 |
UCAS: Administration data |
|
27 |
AEDTM_INST |
|
PIQ_GB_UCAS_AEDTM_INST |
DATS |
DATS |
8 |
0 |
UCAS: Date of change made by the institution |
|
28 |
UNAME_INST |
|
USRNAME |
CHAR12 |
CHAR |
12 |
0 |
User Name |
|
29 |
COURSE_INST |
|
PIQ_GB_UCAS_COURSE_ID_INST |
PIQ_GB_UCAS_COURSE |
CHAR |
6 |
0 |
UCAS: MARVIN course code institution |
T7PIQ_GB_COURSE |
30 |
CAMPUS_INST |
|
PIQ_GB_UCAS_CAMPUS_ID_INST |
PIQ_GB_UCAS_CAMPUS |
CHAR |
1 |
0 |
UCAS: Campus Id Changed by Institution |
|
31 |
ENTRY_MONTH_INST |
|
PIQ_GB_UCAS_ENTRY_MONTH_INST |
|
NUMC |
2 |
0 |
UCAS: obsolet (Entry month changed by Institution) |
|
32 |
ENTRY_YEAR_INST |
|
PIQ_GB_UCAS_ENTRY_YEAR_INST |
JAHR |
NUMC |
4 |
0 |
-CM UCAS: Year of Entry changed by Institution |
|
33 |
ENTRY_POINT_INST |
|
PIQ_GB_UCAS_ENTRY_POINT_INST |
PIQ_GB_UCAS_ENTRY_POINT |
CHAR |
1 |
0 |
-CM UCAS: Point of Entry changed by Institution |
T7PIQ_GB_ENT_PN |
34 |
TRANSACTION_INST |
|
PIQ_GB_UCAS_TRANSACTION_INST |
PIQ_GB_UCAS_TRANSACTION |
CHAR |
2 |
0 |
-CM UCAS: Last Transaction sent to UCAS |
T7PIQ_GB_TRANS |
35 |
DECISION_INST |
|
PIQ_GB_UCAS_TRANSACTION_INST |
PIQ_GB_UCAS_TRANSACTION |
CHAR |
2 |
0 |
-CM UCAS: Last Transaction sent to UCAS |
* |
36 |
CONDITIONS_INST1 |
|
PIQ_GB_UCAS_CONDITIONS_INST |
PIQ_GB_UCAS_CONDITIONS |
CHAR |
197 |
0 |
UCAS: Final conditions set by institution |
|
37 |
CONDITIONS_INST2 |
|
PIQ_GB_UCAS_CONDITIONS_INST |
PIQ_GB_UCAS_CONDITIONS |
CHAR |
197 |
0 |
UCAS: Final conditions set by institution |
|
38 |
CONDITIONS_INST3 |
|
PIQ_GB_UCAS_CONDITIONS_INST |
PIQ_GB_UCAS_CONDITIONS |
CHAR |
197 |
0 |
UCAS: Final conditions set by institution |
|
39 |
ADJ_STATUS |
|
PIQ_GB_UCAS_CHOICEADJSTATUS |
PIQ_GB_UCAS_CHOICEADJSTATUS |
CHAR |
1 |
0 |
UCAS: Adjustment Status for Adjustment Choice |
|
40 |
INTERVIEW_DATE |
|
PIQ_GB_UCAS_INTERVIEWDATE |
DATS |
DATS |
8 |
0 |
UCAS: Date of Interview |
|
41 |
INTERVIEW_RESP |
|
PIQ_GB_UCAS_IRESP |
PIQ_GB_UCAS_IRESP |
CHAR |
1 |
0 |
UCAS: Interview Response of the Applicant |
|
42 |
YR_APPLIED |
|
PIQ_GB_UCAS_YR_APPLD |
PIQ_GB_UCAS_YR_APPLD |
CHAR |
4 |
0 |
Year Applied for Choice Details |
|
43 |
APPL_SCHEME_CODE |
|
PIQ_GB_UCAS_APPLSCHCODE |
CHAR4 |
CHAR |
4 |
0 |
UCAS: Application Scheme Code |
|
44 |
DEFER_ENTRY |
|
PIQ_GB_UCAS_DEFER_ENTRY |
PIQ_GB_UCAS_DEFER_ENTRY |
CHAR |
1 |
0 |
UCAS: Defer entry for choice details |
|
45 |
INSTDESCDATE |
|
PIQ_GB_UCAS_INSTDECDATE |
DATS |
DATS |
8 |
0 |
Institution#s Decision Date |
|
46 |
REFDATE |
|
PIQ_GB_UCAS_REFERRALDATE |
DATS |
DATS |
8 |
0 |
Date When Choice Was Referred |
|
47 |
OFFER_LEVEL |
|
PIQ_GB_UCAS_OFFERLEVEL |
PIQ_GB_UCAS_OFFERLEVEL |
CHAR |
1 |
0 |
UCAS: Student Offer Level |
T7PIQ_GB_OFFRLEV |