SAP ABAP Table PIQ_GB_UCAS_CHOICES (UCAS: Help structure choice data)

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_CHOICES	Table Relationship Diagram
Short Description	UCAS: Help structure choice data

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	CHOICE_NO	☐	PIQCHOICE_NO	PIQCHOICE_NO	NUMC	2	0	Program Choice	T7PIQCHOICES
2	INSTITUTION	☐	PIQ_GB_UCAS_INST_ID	PIQ_GB_UCAS_INST_ID	CHAR	4	0	UCAS: Institution Code	*
3	CAMPUS	☐	PIQ_GB_UCAS_CAMPUS	PIQ_GB_UCAS_CAMPUS	CHAR	1	0	UCAS: Campus Id
4	COURSE	☐	PIQ_GB_UCAS_COURSE	PIQ_GB_UCAS_COURSE	CHAR	6	0	UCAS: Course Code	*
5	COURSE_OBJID	☐	PD_OBJID_R	NUM08	NUMC	8	0	Object ID
6	COURSE_DESC	☐	PIQ_GB_UCAS_DESCRIPTION	TEXT50	CHAR	50	0	-Cm UCAS: Field description
7	ENTRY_POINT	☐	PIQ_GB_UCAS_ENTRY_POINT	PIQ_GB_UCAS_ENTRY_POINT	CHAR	1	0	UCAS: Point of Entry	T7PIQ_GB_ENT_PN
8	PREV_COURSE	☐	PIQ_GB_UCAS_COURSE_OLD	PIQ_GB_UCAS_COURSE	CHAR	6	0	UCAS: Previous Course code MARVIN	*
9	FACULTY	☐	PIQ_GB_UCAS_FACULTY	PIQ_GB_UCAS_FACULTY	CHAR	1	0	UCAS: Faculty Id
10	DECISION	☐	PIQ_GB_UCAS_DECISION	PIQ_GB_UCAS_DECISION	CHAR	1	0	UCAS: Decision made by the institution	*
11	DECISIONT	☐	PIQ_GB_UCAS_DESCRIPTION	TEXT50	CHAR	50	0	-Cm UCAS: Field description
12	REPLY	☐	PIQ_GB_UCAS_REPLY	PIQ_GB_UCAS_REPLY	CHAR	1	0	UCAS: Reply made by applicant	T7PIQ_GB_REPLY
13	REPLYT	☐	PIQ_GB_UCAS_DESCRIPTION	TEXT50	CHAR	50	0	-Cm UCAS: Field description
14	CONDITIONS	☐	PIQ_GB_UCAS_CONDITIONS_SUM	PIQ_GB_UCAS_CONDITIONS_SUM	CHAR	6	0	UCAS: Summary of conditions	T7PIQ_GB_COND
15	CHOICE_CANCEL	☐	PIQ_GB_UCAS_CHOICE_CANCEL	PIQ_GB_UCAS_CHOICE_CANCEL	CHAR	1	0	UCAS:Choice cancelled by applicant
16	AEDTM_UCAS	☐	PIQ_GB_UCAS_AEDTM	DATS	DATS	8	0	UCAS: Date of the last change made by UCAS
17	UCAS_ACTION	☐	PIQ_GB_UCAS_ACTION	PIQ_GB_UCAS_ACTION	CHAR	1	0	UCAS: UCAS action	T7PIQ_GB_UCASAC
18	ENTRY_DATE	☐	PIQ_GB_UCAS_ENTRY_DATE	PIQ_GB_UCAS_ENTRY_DATE	DATS	8	0	UCAS: Date of Entry
19	HOME_INDIC	☐	PIQ_GB_UCAS_HOME_IND	PIQ_GB_UCAS_HOME_IND	CHAR	1	0	UCAS: Live at home indicator
20	INTERV_PRIO	☐	PIQ_GB_UCAS_INTERV_PRIO	PIQ_GB_UCAS_INTERV_PRIO	CHAR	1	0	UCAS: Priority of the interview	T7PIQ_GB_INT_PRI
21	AMENDMENT	☐	PIQ_GB_UCAS_AMENDMENT	PIQ_GB_UCAS_AMENDMENT	CHAR	1	0	UCAS: Amendment	T7PIQ_GB_AMENDM
22	CONF_STATUS	☐	PIQ_GB_UCAS_CONF_STATUS	PIQ_GB_UCAS_CONF_STATUS	CHAR	1	0	UCAS:Confirmation status	T7PIQ_GB_STATUS
23	CONF_HIST	☐	PIQ_GB_UCAS_CONF_HIST	PIQ_GB_UCAS_CONF_HIST	CHAR	1	0	UCAS: Confirmation History	T7PIQ_GB_CON_HI
24	SUBSTITUTION	☐	PIQ_GB_UCAS_SUBSTITUTION	PIQ_GB_UCAS_SUBSTITUTION	CHAR	1	0	UCAS: Substitution	T7PIQ_GB_SUBSTI
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
27	OFFER_LEVELT	☐	PIQ_GB_UCAS_DESCRIPTION	TEXT50	CHAR	50	0	-Cm UCAS: Field description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQ_GB_UCAS_CHOICES	AMENDMENT	T7PIQ_GB_AMENDM	UCAS_AMENDM	REF	1	CN
2	PIQ_GB_UCAS_CHOICES	CHOICE_NO	T7PIQCHOICES	CHOICE_NO	REF	1	CN
3	PIQ_GB_UCAS_CHOICES	CONDITIONS	T7PIQ_GB_COND	CONDITION_SUM	REF	1	CN
4	PIQ_GB_UCAS_CHOICES	CONF_HIST	T7PIQ_GB_CON_HI	CONF_HIST	REF	1	CN
5	PIQ_GB_UCAS_CHOICES	CONF_STATUS	T7PIQ_GB_STATUS	CONF_STATUS	REF	1	CN
6	PIQ_GB_UCAS_CHOICES	ENTRY_POINT	T7PIQ_GB_ENT_PN	POINT_OF_ENTRY	REF	1	CN
7	PIQ_GB_UCAS_CHOICES	INTERV_PRIO	T7PIQ_GB_INT_PRI	INTERV_PRIO	REF	1	CN
8	PIQ_GB_UCAS_CHOICES	OFFER_LEVEL	T7PIQ_GB_OFFRLEV	OFFER_LEVEL
9	PIQ_GB_UCAS_CHOICES	REPLY	T7PIQ_GB_REPLY	REPLY	REF	1	CN
10	PIQ_GB_UCAS_CHOICES	SUBSTITUTION	T7PIQ_GB_SUBSTI	SUBSTITUTION	REF	1	CN
11	PIQ_GB_UCAS_CHOICES	UCAS_ACTION	T7PIQ_GB_UCASAC	UCAS_ACTION	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in