T7PIQ_GB_UFILEIN - UCAS: Records UFileIn
UCAS: Records UFileIn information is stored in SAP table T7PIQ_GB_UFILEIN.
It is part of development package PMIQ_GB in software component IS-HER-CM-GB. This development package consists of objects that can be grouped under "Campus Management (Great Britain)".
It is part of development package PMIQ_GB in software component IS-HER-CM-GB. This development package consists of objects that can be grouped under "Campus Management (Great Britain)".
Fields for table T7PIQ_GB_UFILEIN
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| STUDENTNR | Student Number | X | PIQSTUDENT12 | CHAR | 24 | |
| TRANSCODE | UCAS: Transaction | X | PIQ_GB_UCAS_TRANSACTION | CHAR | 4 | T7PIQ_GB_TRANS |
| SEQNR | UCAS: Sequence number | X | PIQ_GB_UCAS_SEQNR | NUMC | 8 | |
| CHOICENR | Program Choice | X | PIQCHOICE_NO | NUMC | 4 | T7PIQCHOICES |
| DECISION | UCAS: Decision made by the institution | PIQ_GB_UCAS_DECISION | CHAR | 2 | T7PIQ_GB_DECIS | |
| COURSE_OLD | UCAS: Course Code | PIQ_GB_UCAS_COURSE | CHAR | 12 | * | |
| COURSE | UCAS: Course Code | PIQ_GB_UCAS_COURSE | CHAR | 12 | * | |
| CAMPUS | UCAS: Campus Id | PIQ_GB_UCAS_CAMPUS | CHAR | 2 | T7PIQ_GB_CAMPUSM | |
| ENTRY_DATE_OLD | UCAS: Date of Entry | PIQ_GB_UCAS_ENTRY_DATE | DATS | 16 | ||
| ENTRY_DATE | UCAS: Date of Entry | PIQ_GB_UCAS_ENTRY_DATE | DATS | 16 | ||
| ENTRY_POINT | UCAS: Point of Entry | PIQ_GB_UCAS_ENTRY_POINT | CHAR | 2 | T7PIQ_GB_ENT_PN | |
| CONDITION1 | UCAS: Conditions | PIQ_GB_UCAS_CONDITIONS | CHAR | 394 | ||
| CONDITION2 | UCAS: Conditions | PIQ_GB_UCAS_CONDITIONS | CHAR | 394 | ||
| CONDITION3 | UCAS: Conditions | PIQ_GB_UCAS_CONDITIONS | CHAR | 394 | ||
| REASON | UCAS: Abbreviation reason for withdrawal/clearing | PIQ_GB_UCAS_REASON | CHAR | 4 | ||
| AEDTM | Changed on | AEDTM | DATS | 16 | ||
| UNAME | User Name | USRNAME | CHAR | 24 | ||
| TIME | Time | UZEIT | TIMS | 12 | ||
| STATUS | UCAS: Status of an applicant record | PIQ_GB_UCAS_DEC_STATUS | CHAR | 2 | ||
| PASSPORTID | UCAS: Passport ID | PIQ_GB_UCAS_PASSID | CHAR | 12 | ||
| COPYFORM | UCAS: Flag, Copy Form required | PIQ_GB_UCAS_COPYF | CHAR | 2 | ||
| PERSONALID_IND | Personal Id Indicator | CHAR | 2 | |||
| PERSONALID | UCAS : ucaslink Personal Id | PIQ_GB_UCAS_PERSONALID | CHAR | 20 | ||
| APPL_SCHEME_CODE | UCAS: Application Scheme Code | PIQ_GB_UCAS_APPLSCHCODE | CHAR | 8 | ||
| OFFER_LEVEL | UCAS: Student Offer Level | PIQ_GB_UCAS_OFFERLEVEL | CHAR | 2 | T7PIQ_GB_OFFRLEV |