SAP ABAP Table T7PIQ_GB_UFILEIN (UCAS: Records UFileIn)

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-HER-CM-GB (Application Component) United Kingdom
     ⤷ PMIQ_GB (Package) Campus Management (Great Britain)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	T7PIQ_GB_UFILEIN	Table Relationship Diagram
Short Description	UCAS: Records UFileIn

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	STUDENTNR	☑	PIQSTUDENT12	PIQSTUDENT12	CHAR	12	0	Student Number
3	TRANSCODE	☑	PIQ_GB_UCAS_TRANSACTION	PIQ_GB_UCAS_TRANSACTION	CHAR	2	0	UCAS: Transaction	T7PIQ_GB_TRANS
4	SEQNR	☑	PIQ_GB_UCAS_SEQNR	NUMC4	NUMC	4	0	UCAS: Sequence number
5	CHOICENR	☑	PIQCHOICE_NO	PIQCHOICE_NO	NUMC	2	0	Program Choice	T7PIQCHOICES
6	DECISION	☐	PIQ_GB_UCAS_DECISION	PIQ_GB_UCAS_DECISION	CHAR	1	0	UCAS: Decision made by the institution	T7PIQ_GB_DECIS
7	COURSE_OLD	☐	PIQ_GB_UCAS_COURSE	PIQ_GB_UCAS_COURSE	CHAR	6	0	UCAS: Course Code	*
8	COURSE	☐	PIQ_GB_UCAS_COURSE	PIQ_GB_UCAS_COURSE	CHAR	6	0	UCAS: Course Code	*
9	CAMPUS	☐	PIQ_GB_UCAS_CAMPUS	PIQ_GB_UCAS_CAMPUS	CHAR	1	0	UCAS: Campus Id	T7PIQ_GB_CAMPUSM
10	ENTRY_DATE_OLD	☐	PIQ_GB_UCAS_ENTRY_DATE	PIQ_GB_UCAS_ENTRY_DATE	DATS	8	0	UCAS: Date of Entry
11	ENTRY_DATE	☐	PIQ_GB_UCAS_ENTRY_DATE	PIQ_GB_UCAS_ENTRY_DATE	DATS	8	0	UCAS: Date of Entry
12	ENTRY_POINT	☐	PIQ_GB_UCAS_ENTRY_POINT	PIQ_GB_UCAS_ENTRY_POINT	CHAR	1	0	UCAS: Point of Entry	T7PIQ_GB_ENT_PN
13	CONDITION1	☐	PIQ_GB_UCAS_CONDITIONS	PIQ_GB_UCAS_CONDITIONS	CHAR	197	0	UCAS: Conditions
14	CONDITION2	☐	PIQ_GB_UCAS_CONDITIONS	PIQ_GB_UCAS_CONDITIONS	CHAR	197	0	UCAS: Conditions
15	CONDITION3	☐	PIQ_GB_UCAS_CONDITIONS	PIQ_GB_UCAS_CONDITIONS	CHAR	197	0	UCAS: Conditions
16	REASON	☐	PIQ_GB_UCAS_REASON	PIQ_GB_UCAS_REASON	CHAR	2	0	UCAS: Abbreviation reason for withdrawal/clearing
17	AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
18	UNAME	☐	USRNAME	CHAR12	CHAR	12	0	User Name
19	TIME	☐	UZEIT	UZEIT	TIMS	6	0	Time
20	STATUS	☐	PIQ_GB_UCAS_DEC_STATUS	PIQ_GB_UCAS_DEC_STATUS	CHAR	1	0	UCAS: Status of an applicant record
21	PASSPORTID	☐	PIQ_GB_UCAS_PASSID	PIQ_GB_UCAS_PASSID	CHAR	6	0	UCAS: Passport ID
22	COPYFORM	☐	PIQ_GB_UCAS_COPYF	PIQ_GB_UCAS_COPYF	CHAR	1	0	UCAS: Flag, Copy Form required
23	PERSONALID_IND	☐			CHAR	1	0
24	PERSONALID	☐	PIQ_GB_UCAS_PERSONALID	PIQ_GB_UCAS_PERSONALID	CHAR	10	0	UCAS : ucaslink Personal Id
25	APPL_SCHEME_CODE	☐	PIQ_GB_UCAS_APPLSCHCODE	CHAR4	CHAR	4	0	UCAS: Application Scheme Code
26	OFFER_LEVEL	☐	PIQ_GB_UCAS_OFFERLEVEL	PIQ_GB_UCAS_OFFERLEVEL	CHAR	1	0	UCAS: Student Offer Level	T7PIQ_GB_OFFRLEV

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T7PIQ_GB_UFILEIN	CAMPUS	T7PIQ_GB_CAMPUSM	CAMPUS	REF	1	CN
2	T7PIQ_GB_UFILEIN	CHOICENR	T7PIQCHOICES	CHOICE_NO	KEY	1	CN
3	T7PIQ_GB_UFILEIN	DECISION	T7PIQ_GB_DECIS	DECISION
4	T7PIQ_GB_UFILEIN	ENTRY_POINT	T7PIQ_GB_ENT_PN	POINT_OF_ENTRY	REF	1	CN
5	T7PIQ_GB_UFILEIN	MANDT	T000	MANDT	KEY	1	CN
6	T7PIQ_GB_UFILEIN	OFFER_LEVEL	T7PIQ_GB_OFFRLEV	OFFER_LEVEL
7	T7PIQ_GB_UFILEIN	TRANSCODE	T7PIQ_GB_TRANS	UCAS_TRANSACTION	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in