SAP table T7PIQ_GB_UFILEIN (UCAS: Records UFileIn)

SAP table T7PIQ_GB_UFILEIN has 5 primary key fields being MANDT,STUDENTNR,TRANSCODE,SEQNR,CHOICENR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
STUDENTNR Student Number CHAR 12 0 PIQSTUDENT12
TRANSCODE UCAS: Transaction CHAR 2 0 T7PIQ_GB_TRANS PIQ_GB_UCAS_TRANSACTION
SEQNR UCAS: Sequence number NUMC 4 0 PIQ_GB_UCAS_SEQNR
CHOICENR Program Choice NUMC 2 0 T7PIQCHOICES PIQCHOICE_NO
DECISION UCAS: Decision made by the institution CHAR 1 0 T7PIQ_GB_DECIS PIQ_GB_UCAS_DECISION
COURSE_OLD UCAS: Course Code CHAR 6 0 * PIQ_GB_UCAS_COURSE
COURSE UCAS: Course Code CHAR 6 0 * PIQ_GB_UCAS_COURSE
CAMPUS UCAS: Campus Id CHAR 1 0 T7PIQ_GB_CAMPUSM PIQ_GB_UCAS_CAMPUS
ENTRY_DATE_OLD UCAS: Date of Entry DATS 8 0 PIQ_GB_UCAS_ENTRY_DATE
ENTRY_DATE UCAS: Date of Entry DATS 8 0 PIQ_GB_UCAS_ENTRY_DATE
ENTRY_POINT UCAS: Point of Entry CHAR 1 0 T7PIQ_GB_ENT_PN PIQ_GB_UCAS_ENTRY_POINT
CONDITION1 UCAS: Conditions CHAR 197 0 PIQ_GB_UCAS_CONDITIONS
CONDITION2 UCAS: Conditions CHAR 197 0 PIQ_GB_UCAS_CONDITIONS
CONDITION3 UCAS: Conditions CHAR 197 0 PIQ_GB_UCAS_CONDITIONS
REASON UCAS: Abbreviation reason for withdrawal/clearing CHAR 2 0 PIQ_GB_UCAS_REASON
AEDTM Changed on DATS 8 0 AEDTM
UNAME User Name CHAR 12 0 USRNAME
TIME Time TIMS 6 0 UZEIT
STATUS UCAS: Status of an applicant record CHAR 1 0 PIQ_GB_UCAS_DEC_STATUS
C Record checked
E Error while Transmission
S Record sent
T Record Transmitted Immediately
PASSPORTID UCAS: Passport ID CHAR 6 0 PIQ_GB_UCAS_PASSID
COPYFORM UCAS: Flag, Copy Form required CHAR 1 0 PIQ_GB_UCAS_COPYF
N No
Y Yes
PERSONALID_IND CHAR 1 0
PERSONALID UCAS : ucaslink Personal Id CHAR 10 0 PIQ_GB_UCAS_PERSONALID
APPL_SCHEME_CODE UCAS: Application Scheme Code CHAR 4 0 PIQ_GB_UCAS_APPLSCHCODE
OFFER_LEVEL UCAS: Student Offer Level CHAR 1 0 T7PIQ_GB_OFFRLEV PIQ_GB_UCAS_OFFERLEVEL

T7PIQ_GB_UFILEIN foreign key relationships

Table Field Check Table Check Field
0 T7PIQ_GB_UFILEIN CAMPUS T7PIQ_GB_CAMPUSM UCAS: Mapping table UCAS Campus -> SAP Campus CAMPUS
1 T7PIQ_GB_UFILEIN CHOICENR T7PIQCHOICES Program Choices MANDT
0 T7PIQ_GB_UFILEIN ENTRY_POINT T7PIQ_GB_ENT_PN UCAS: Mapping UCAS point of entry -> SAP program stage POINT_OF_ENTRY
1 T7PIQ_GB_UFILEIN OFFER_LEVEL T7PIQ_GB_OFFRLEV UCAS: Student Offer Level OFFER_LEVEL
0 T7PIQ_GB_UFILEIN TRANSCODE T7PIQ_GB_TRANS UCAS: Transactions UCAS_TRANSACTION