SAP ABAP Table PIQ_GB_UCAS_UFILEIN (Structure 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	INTTAB	Structure
Structure	PIQ_GB_UCAS_UFILEIN	Table Relationship Diagram
Short Description	Structure Ufilein

Delivery and Maintenance

Pool/cluster
Delivery Class
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	COURSE	☐	PIQ_GB_UCAS_COURSE_ID_INST	PIQ_GB_UCAS_COURSE	CHAR	6	0	UCAS: MARVIN course code institution	T7PIQ_GB_COURSE
2	CAMPUS	☐	PIQ_GB_UCAS_CAMPUS_ID_INST	PIQ_GB_UCAS_CAMPUS	CHAR	1	0	UCAS: Campus Id Changed by Institution
3	DATE_OF_ENTRY	☐	PIQ_GB_UCAS_ENTRY_DATE	PIQ_GB_UCAS_ENTRY_DATE	DATS	8	0	UCAS: Date of Entry
4	POINT_OF_ENTRY	☐	PIQ_GB_UCAS_ENTRY_POINT_INST	PIQ_GB_UCAS_ENTRY_POINT	CHAR	1	0	-CM UCAS: Point of Entry changed by Institution	T7PIQ_GB_ENT_PN
5	CONDITIONS_INST1	☐	PIQ_GB_UCAS_CONDITIONS_INST	PIQ_GB_UCAS_CONDITIONS	CHAR	197	0	UCAS: Final conditions set by institution
6	CONDITIONS_INST2	☐	PIQ_GB_UCAS_CONDITIONS_INST	PIQ_GB_UCAS_CONDITIONS	CHAR	197	0	UCAS: Final conditions set by institution
7	CONDITIONS_INST3	☐	PIQ_GB_UCAS_CONDITIONS_INST	PIQ_GB_UCAS_CONDITIONS	CHAR	197	0	UCAS: Final conditions set by institution
8	DECISION	☐	PIQ_GB_UCAS_DECISION	PIQ_GB_UCAS_DECISION	CHAR	1	0	UCAS: Decision made by the institution	T7PIQ_GB_DECIS
9	COND_LINE	☐	CHAR100	CHAR100	CHAR	100	0	Character 100
10	DESCISIONT	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
11	REASON	☐	CHAR2	CHAR2	CHAR	2	0	Version Number Component
12	CHOICE	☐	PIQCHOICE_NO	PIQCHOICE_NO	NUMC	2	0	Program Choice	*
13	INSTITUTION	☐	PIQ_GB_UCAS_INST_ID	PIQ_GB_UCAS_INST_ID	CHAR	4	0	UCAS: Institution Code	*
14	CAMPUS_CH	☐	PIQ_GB_UCAS_CAMPUS	PIQ_GB_UCAS_CAMPUS	CHAR	1	0	UCAS: Campus Id
15	COURSE_CH	☐	PIQ_GB_UCAS_COURSE_ID_INST	PIQ_GB_UCAS_COURSE	CHAR	6	0	UCAS: MARVIN course code institution	*
16	DATE_OF_ENTRY_CH	☐	PIQ_GB_UCAS_ENTRY_DATE	PIQ_GB_UCAS_ENTRY_DATE	DATS	8	0	UCAS: Date of Entry
17	POINT_OF_ENTRY_CH	☐	PIQ_GB_UCAS_ENTRY_POINT_INST	PIQ_GB_UCAS_ENTRY_POINT	CHAR	1	0	-CM UCAS: Point of Entry changed by Institution	*
18	PASSPORTID	☐	PIQ_GB_UCAS_PASSID	PIQ_GB_UCAS_PASSID	CHAR	6	0	UCAS: Passport ID
19	COPYFORM	☐	PIQ_GB_UCAS_COPYF	PIQ_GB_UCAS_COPYF	CHAR	1	0	UCAS: Flag, Copy Form required

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQ_GB_UCAS_UFILEIN	COURSE	T7PIQ_GB_COURSE	COURSE_ID	REF	1	CN
2	PIQ_GB_UCAS_UFILEIN	DECISION	T7PIQ_GB_DECIS	DECISION
3	PIQ_GB_UCAS_UFILEIN	POINT_OF_ENTRY	T7PIQ_GB_ENT_PN	POINT_OF_ENTRY	REF	1	CN

History

Last changed by/on	SAP	20090218
SAP Release Created in