| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | TABNR | Reference Number to Table Part | nvarchar | 32 | 0 | | | | Allow NULL? |
| 3 | TABSEQNR | Sequence Number in Table Part of Table Infotype | nvarchar | 6 | 0 | | | | Allow NULL? |
| 4 | CHOICE_NO | Program Choice | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | INSTITUTION | UCAS: Institution Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | COURSE | UCAS: Course Code | nvarchar | 6 | 0 | | | | Allow NULL? |
| 7 | SC_OBJID | Program ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | CAMPUS | UCAS: Campus Id | char | 1 | 0 | | | | Allow NULL? |
| 9 | FACULTY | UCAS: Faculty Id | char | 1 | 0 | | | | Allow NULL? |
| 10 | DECISION | UCAS: Decision made by the institution | char | 1 | 0 | | | | Allow NULL? |
| 11 | REPLY | UCAS: Reply made by applicant | char | 1 | 0 | | | | Allow NULL? |
| 12 | CONDITIONS | UCAS: Summary of conditions | nvarchar | 6 | 0 | | | | Allow NULL? |
| 13 | ENTRY_DATE | UCAS: Date of Entry | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | CHOICE_CANCEL | UCAS:Choice cancelled by applicant | char | 1 | 0 | | | | Allow NULL? |
| 15 | AEDTM_UCAS | UCAS: Date of the last change made by UCAS | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | UCAS_ACTION | UCAS: UCAS action | char | 1 | 0 | | | | Allow NULL? |
| 17 | SUBSTITUTION | UCAS: Substitution | char | 1 | 0 | | | | Allow NULL? |
| 18 | AMENDMENT | UCAS: Amendment | char | 1 | 0 | | | | Allow NULL? |
| 19 | PREV_COURSE | UCAS: Previous Course code MARVIN | nvarchar | 6 | 0 | | | | Allow NULL? |
| 20 | CONF_STATUS | UCAS:Confirmation status | char | 1 | 0 | | | | Allow NULL? |
| 21 | CONF_HIST | UCAS: Confirmation History | char | 1 | 0 | | | | Allow NULL? |
| 22 | ENTRY_POINT | UCAS: Point of Entry | char | 1 | 0 | | | | Allow NULL? |
| 23 | INTERV_PRIO | UCAS: Priority of the interview | char | 1 | 0 | | | | Allow NULL? |
| 24 | HOME_INDIC | UCAS: Live at home indicator | char | 1 | 0 | | | | Allow NULL? |
| 25 | AEDTM_INST | UCAS: Date of change made by the institution | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | UNAME_INST | User Name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 27 | COURSE_INST | UCAS: MARVIN course code institution | nvarchar | 6 | 0 | | | | Allow NULL? |
| 28 | CAMPUS_INST | UCAS: Campus Id Changed by Institution | char | 1 | 0 | | | | Allow NULL? |
| 29 | ENTRY_MONTH_INST | UCAS: obsolet (Entry month changed by Institution) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 30 | ENTRY_YEAR_INST | -CM UCAS: Year of Entry changed by Institution | nvarchar | 4 | 0 | | | | Allow NULL? |
| 31 | ENTRY_POINT_INST | -CM UCAS: Point of Entry changed by Institution | char | 1 | 0 | | | | Allow NULL? |
| 32 | TRANSACTION_INST | -CM UCAS: Last Transaction sent to UCAS | nvarchar | 2 | 0 | | | | Allow NULL? |
| 33 | DECISION_INST | -CM UCAS: Last Transaction sent to UCAS | nvarchar | 2 | 0 | | | | Allow NULL? |
| 34 | CONDITIONS_INST1 | UCAS: Final conditions set by institution | nvarchar | 197 | 0 | | | | Allow NULL? |
| 35 | CONDITIONS_INST2 | UCAS: Final conditions set by institution | nvarchar | 197 | 0 | | | | Allow NULL? |
| 36 | CONDITIONS_INST3 | UCAS: Final conditions set by institution | nvarchar | 197 | 0 | | | | Allow NULL? |
| 37 | ADJ_STATUS | UCAS: Adjustment Status for Adjustment Choice | char | 1 | 0 | | | | Allow NULL? |
| 38 | INTERVIEW_DATE | UCAS: Date of Interview | nvarchar | 8 | 0 | | | | Allow NULL? |
| 39 | INTERVIEW_RESP | UCAS: Interview Response of the Applicant | char | 1 | 0 | | | | Allow NULL? |
| 40 | YR_APPLIED | Year Applied for Choice Details | nvarchar | 4 | 0 | | | | Allow NULL? |
| 41 | APPL_SCHEME_CODE | UCAS: Application Scheme Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 42 | DEFER_ENTRY | UCAS: Defer entry for choice details | char | 1 | 0 | | | | Allow NULL? |
| 43 | INSTDESCDATE | Institution’s Decision Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 44 | REFDATE | Date When Choice Was Referred | nvarchar | 8 | 0 | | | | Allow NULL? |
| 45 | OFFER_LEVEL | UCAS: Student Offer Level | char | 1 | 0 | | | | Allow NULL? |
| 46 | POTENTIAL_LEVEL | Potential Offer Level | char | 1 | 0 | | | | Allow NULL? |
| 47 | CWD_FLAG_T | UCAS: Choice withdrew totally or re-instatement | char | 1 | 0 | | | | Allow NULL? |
| 48 | CWD_DATE_T | UCAS:CWD withraw date | nvarchar | 8 | 0 | | | | Allow NULL? |
