SAP ABAP Table PT1783 (UCAS Table Section Student's Choices (GB))

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	PT1783	Table Relationship Diagram
Short Description	UCAS Table Section Student's Choices (GB)

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	*
2	INSTITUTION	☐	PIQ_GB_UCAS_INST_ID	PIQ_GB_UCAS_INST_ID	CHAR	4	0	UCAS: Institution Code	T7PIQ_GB_INST
3	COURSE	☐	PIQ_GB_UCAS_COURSE	PIQ_GB_UCAS_COURSE	CHAR	6	0	UCAS: Course Code	T7PIQ_GB_COURSE
4	SC_OBJID	☐	PIQSCOBJID	HROBJID	NUMC	8	0	Program ID	*
5	CAMPUS	☐	PIQ_GB_UCAS_CAMPUS	PIQ_GB_UCAS_CAMPUS	CHAR	1	0	UCAS: Campus Id
6	FACULTY	☐	PIQ_GB_UCAS_FACULTY	PIQ_GB_UCAS_FACULTY	CHAR	1	0	UCAS: Faculty Id
7	DECISION	☐	PIQ_GB_UCAS_DECISION	PIQ_GB_UCAS_DECISION	CHAR	1	0	UCAS: Decision made by the institution	T7PIQ_GB_DECIS
8	REPLY	☐	PIQ_GB_UCAS_REPLY	PIQ_GB_UCAS_REPLY	CHAR	1	0	UCAS: Reply made by applicant	T7PIQ_GB_REPLY
9	CONDITIONS	☐	PIQ_GB_UCAS_CONDITIONS_SUM	PIQ_GB_UCAS_CONDITIONS_SUM	CHAR	6	0	UCAS: Summary of conditions	*
10	ENTRY_DATE	☐	PIQ_GB_UCAS_ENTRY_DATE	PIQ_GB_UCAS_ENTRY_DATE	DATS	8	0	UCAS: Date of Entry
11	CHOICE_CANCEL	☐	PIQ_GB_UCAS_CHOICE_CANCEL	PIQ_GB_UCAS_CHOICE_CANCEL	CHAR	1	0	UCAS:Choice cancelled by applicant
12	AEDTM_UCAS	☐	PIQ_GB_UCAS_AEDTM	DATS	DATS	8	0	UCAS: Date of the last change made by UCAS
13	UCAS_ACTION	☐	PIQ_GB_UCAS_ACTION	PIQ_GB_UCAS_ACTION	CHAR	1	0	UCAS: UCAS action	T7PIQ_GB_UCASAC
14	SUBSTITUTION	☐	PIQ_GB_UCAS_SUBSTITUTION	PIQ_GB_UCAS_SUBSTITUTION	CHAR	1	0	UCAS: Substitution	T7PIQ_GB_SUBSTI
15	AMENDMENT	☐	PIQ_GB_UCAS_AMENDMENT	PIQ_GB_UCAS_AMENDMENT	CHAR	1	0	UCAS: Amendment
16	PREV_COURSE	☐	PIQ_GB_UCAS_COURSE_OLD	PIQ_GB_UCAS_COURSE	CHAR	6	0	UCAS: Previous Course code MARVIN	*
17	CONF_STATUS	☐	PIQ_GB_UCAS_CONF_STATUS	PIQ_GB_UCAS_CONF_STATUS	CHAR	1	0	UCAS:Confirmation status	T7PIQ_GB_STATUS
18	CONF_HIST	☐	PIQ_GB_UCAS_CONF_HIST	PIQ_GB_UCAS_CONF_HIST	CHAR	1	0	UCAS: Confirmation History	T7PIQ_GB_CON_HI
19	ENTRY_POINT	☐	PIQ_GB_UCAS_ENTRY_POINT	PIQ_GB_UCAS_ENTRY_POINT	CHAR	1	0	UCAS: Point of Entry	T7PIQ_GB_ENT_PN
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	HOME_INDIC	☐	PIQ_GB_UCAS_HOME_IND	PIQ_GB_UCAS_HOME_IND	CHAR	1	0	UCAS: Live at home indicator
22	.INCLUDE	☐				0	0	UCAS: Administration data
23	AEDTM_INST	☐	PIQ_GB_UCAS_AEDTM_INST	DATS	DATS	8	0	UCAS: Date of change made by the institution
24	UNAME_INST	☐	USRNAME	CHAR12	CHAR	12	0	User Name
25	COURSE_INST	☐	PIQ_GB_UCAS_COURSE_ID_INST	PIQ_GB_UCAS_COURSE	CHAR	6	0	UCAS: MARVIN course code institution	T7PIQ_GB_COURSE
26	CAMPUS_INST	☐	PIQ_GB_UCAS_CAMPUS_ID_INST	PIQ_GB_UCAS_CAMPUS	CHAR	1	0	UCAS: Campus Id Changed by Institution
27	ENTRY_MONTH_INST	☐	PIQ_GB_UCAS_ENTRY_MONTH_INST		NUMC	2	0	UCAS: obsolet (Entry month changed by Institution)
28	ENTRY_YEAR_INST	☐	PIQ_GB_UCAS_ENTRY_YEAR_INST	JAHR	NUMC	4	0	-CM UCAS: Year of Entry changed by Institution
29	ENTRY_POINT_INST	☐	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
30	TRANSACTION_INST	☐	PIQ_GB_UCAS_TRANSACTION_INST	PIQ_GB_UCAS_TRANSACTION	CHAR	2	0	-CM UCAS: Last Transaction sent to UCAS	T7PIQ_GB_TRANS
31	DECISION_INST	☐	PIQ_GB_UCAS_TRANSACTION_INST	PIQ_GB_UCAS_TRANSACTION	CHAR	2	0	-CM UCAS: Last Transaction sent to UCAS	*
32	CONDITIONS_INST1	☐	PIQ_GB_UCAS_CONDITIONS_INST	PIQ_GB_UCAS_CONDITIONS	CHAR	197	0	UCAS: Final conditions set by institution
33	CONDITIONS_INST2	☐	PIQ_GB_UCAS_CONDITIONS_INST	PIQ_GB_UCAS_CONDITIONS	CHAR	197	0	UCAS: Final conditions set by institution
34	CONDITIONS_INST3	☐	PIQ_GB_UCAS_CONDITIONS_INST	PIQ_GB_UCAS_CONDITIONS	CHAR	197	0	UCAS: Final conditions set by institution
35	ADJ_STATUS	☐	PIQ_GB_UCAS_CHOICEADJSTATUS	PIQ_GB_UCAS_CHOICEADJSTATUS	CHAR	1	0	UCAS: Adjustment Status for Adjustment Choice
36	INTERVIEW_DATE	☐	PIQ_GB_UCAS_INTERVIEWDATE	DATS	DATS	8	0	UCAS: Date of Interview
37	INTERVIEW_RESP	☐	PIQ_GB_UCAS_IRESP	PIQ_GB_UCAS_IRESP	CHAR	1	0	UCAS: Interview Response of the Applicant
38	YR_APPLIED	☐	PIQ_GB_UCAS_YR_APPLD	PIQ_GB_UCAS_YR_APPLD	CHAR	4	0	Year Applied for Choice Details
39	APPL_SCHEME_CODE	☐	PIQ_GB_UCAS_APPLSCHCODE	CHAR4	CHAR	4	0	UCAS: Application Scheme Code
40	DEFER_ENTRY	☐	PIQ_GB_UCAS_DEFER_ENTRY	PIQ_GB_UCAS_DEFER_ENTRY	CHAR	1	0	UCAS: Defer entry for choice details
41	INSTDESCDATE	☐	PIQ_GB_UCAS_INSTDECDATE	DATS	DATS	8	0	Institution#s Decision Date
42	REFDATE	☐	PIQ_GB_UCAS_REFERRALDATE	DATS	DATS	8	0	Date When Choice Was Referred
43	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	PT1783	CONF_HIST	T7PIQ_GB_CON_HI	CONF_HIST		1	CN
2	PT1783	CONF_STATUS	T7PIQ_GB_STATUS	CONF_STATUS		1	CN
3	PT1783	COURSE	T7PIQ_GB_COURSE	COURSE_ID
4	PT1783	COURSE_INST	T7PIQ_GB_COURSE	COURSE_ID		1	CN
5	PT1783	DECISION	T7PIQ_GB_DECIS	DECISION		1	CN
6	PT1783	ENTRY_POINT	T7PIQ_GB_ENT_PN	POINT_OF_ENTRY		1	CN
7	PT1783	ENTRY_POINT_INST	T7PIQ_GB_ENT_PN	POINT_OF_ENTRY		1	CN
8	PT1783	INSTITUTION	T7PIQ_GB_INST	INSTITUTION_ID		1	CN
9	PT1783	INTERV_PRIO	T7PIQ_GB_INT_PRI	INTERV_PRIO		1	CN
10	PT1783	OFFER_LEVEL	T7PIQ_GB_OFFRLEV	OFFER_LEVEL
11	PT1783	REPLY	T7PIQ_GB_REPLY	REPLY		1	CN
12	PT1783	SUBSTITUTION	T7PIQ_GB_SUBSTI	SUBSTITUTION		1	CN
13	PT1783	TRANSACTION_INST	T7PIQ_GB_TRANS	UCAS_TRANSACTION		1	CN
14	PT1783	UCAS_ACTION	T7PIQ_GB_UCASAC	UCAS_ACTION	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in