1. Home
  2. Resources
  3. SAP Tables
  4. T7PIQ_GB_UFILEIN - UCAS: Records UFileIn

SAP Table T7PIQ_GB_UFILEIN

UCAS: Records UFileIn

T7PIQ_GB_UFILEIN (UCAS: Records UFileIn) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link T7PIQ_GB_UFILEIN to other SAP tables.

Source: T7PIQ_GB_UFILEIN (UCAS: Records UFileIn)

T7PIQ_GB_UFILEIN table fields

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

T7PIQ_GB_UFILEIN foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T7PIQ_GB_UFILEIN CAMPUS T7PIQ_GB_UFILEIN MANDT T7PIQ_GB_CAMPUSM UCAS: Mapping table UCAS Campus -> SAP Campus MANDT
T7PIQ_GB_UFILEIN CAMPUS T7PIQ_GB_UFILEIN CAMPUS T7PIQ_GB_CAMPUSM UCAS: Mapping table UCAS Campus -> SAP Campus CAMPUS
T7PIQ_GB_UFILEIN CHOICENR T7PIQ_GB_UFILEIN MANDT T7PIQCHOICES Program Choices MANDT
T7PIQ_GB_UFILEIN CHOICENR T7PIQ_GB_UFILEIN CHOICENR T7PIQCHOICES Program Choices CHOICE_NO
T7PIQ_GB_UFILEIN DECISION T7PIQ_GB_UFILEIN DECISION T7PIQ_GB_DECIS UCAS: Decision institution DECISION
T7PIQ_GB_UFILEIN ENTRY_POINT T7PIQ_GB_UFILEIN MANDT T7PIQ_GB_ENT_PN UCAS: Mapping UCAS point of entry -> SAP program stage MANDT
T7PIQ_GB_UFILEIN ENTRY_POINT T7PIQ_GB_UFILEIN ENTRY_POINT T7PIQ_GB_ENT_PN UCAS: Mapping UCAS point of entry -> SAP program stage POINT_OF_ENTRY
T7PIQ_GB_UFILEIN MANDT T7PIQ_GB_UFILEIN MANDT T000 Clients MANDT
T7PIQ_GB_UFILEIN OFFER_LEVEL T7PIQ_GB_UFILEIN MANDT T7PIQ_GB_OFFRLEV UCAS: Student Offer Level MANDT
T7PIQ_GB_UFILEIN OFFER_LEVEL T7PIQ_GB_UFILEIN OFFER_LEVEL T7PIQ_GB_OFFRLEV UCAS: Student Offer Level OFFER_LEVEL
T7PIQ_GB_UFILEIN TRANSCODE T7PIQ_GB_UFILEIN TRANSCODE T7PIQ_GB_TRANS UCAS: Transactions UCAS_TRANSACTION