T7PIQ_GB_UFILEIN

UCAS: Records UFileIn | #transactional | Component: United Kingdom
Column Name Description
MANDT FK Client
STUDENTNR Student Number
TRANSCODE FK UCAS: Transaction
SEQNR UCAS: Sequence number
CHOICENR FK Program Choice
Column Name Description
Column Name Description
Column Name Description
ENTRY_DATE_OLD UCAS: Date of Entry
ENTRY_DATE UCAS: Date of Entry
AEDTM Changed on
TIME Time
Column Name Description
STATUS UCAS: Status of an applicant record Show values
COPYFORM UCAS: Flag, Copy Form required Show values
Column Name Description Domain name
COURSE_OLD UCAS: Course Code PIQ_GB_UCAS_COURSE
COURSE UCAS: Course Code PIQ_GB_UCAS_COURSE
CONDITION1 UCAS: Conditions PIQ_GB_UCAS_CONDITIONS
CONDITION2 UCAS: Conditions PIQ_GB_UCAS_CONDITIONS
CONDITION3 UCAS: Conditions PIQ_GB_UCAS_CONDITIONS
REASON UCAS: Abbreviation reason for withdrawal/clearing PIQ_GB_UCAS_REASON
UNAME User Name CHAR12
PASSPORTID UCAS: Passport ID PIQ_GB_UCAS_PASSID
PERSONALID_IND null
PERSONALID UCAS : ucaslink Personal Id PIQ_GB_UCAS_PERSONALID
APPL_SCHEME_CODE UCAS: Application Scheme Code CHAR4
Master Data Relations Join Conditions
Program Choice
UCAS: Decision made by the institution T7PIQ_GB_UFILEIN.DECISION == T7PIQ_GB_DECIS.DECISION
UCAS: Point of Entry
Client T7PIQ_GB_UFILEIN.MANDT == T000.MANDT
UCAS: Student Offer Level
UCAS: Transaction T7PIQ_GB_UFILEIN.TRANSCODE == T7PIQ_GB_TRANS.UCAS_TRANSACTION
Other Relations | to Master Data Relations ↑ Join Conditions
UCAS: Campus Id