SAP ABAP Table T7PIQ_GB_DECLIST (UCASLINK : Decision List)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	T7PIQ_GB_DECLIST	Table Relationship Diagram
Short Description	UCASLINK : Decision List

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	.INCLUDE	☐				0	0	UCAS: Records UFileIn
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	STUDENTNR	☐	PIQSTUDENT12	PIQSTUDENT12	CHAR	12	0	Student Number
4	TRANSCODE	☐	PIQ_GB_UCAS_TRANSACTION	PIQ_GB_UCAS_TRANSACTION	CHAR	2	0	UCAS: Transaction	T7PIQ_GB_TRANS
5	SEQNR	☐	PIQ_GB_UCAS_SEQNR	NUMC4	NUMC	4	0	UCAS: Sequence number
6	CHOICENR	☐	PIQCHOICE_NO	PIQCHOICE_NO	NUMC	2	0	Program Choice	T7PIQCHOICES
7	DECISION	☐	PIQ_GB_UCAS_DECISION	PIQ_GB_UCAS_DECISION	CHAR	1	0	UCAS: Decision made by the institution	T7PIQ_GB_DECIS
8	COURSE_OLD	☐	PIQ_GB_UCAS_COURSE	PIQ_GB_UCAS_COURSE	CHAR	6	0	UCAS: Course Code	*
9	COURSE	☐	PIQ_GB_UCAS_COURSE	PIQ_GB_UCAS_COURSE	CHAR	6	0	UCAS: Course Code	*
10	CAMPUS	☐	PIQ_GB_UCAS_CAMPUS	PIQ_GB_UCAS_CAMPUS	CHAR	1	0	UCAS: Campus Id	T7PIQ_GB_CAMPUSM
11	ENTRY_DATE_OLD	☐	PIQ_GB_UCAS_ENTRY_DATE	PIQ_GB_UCAS_ENTRY_DATE	DATS	8	0	UCAS: Date of Entry
12	ENTRY_DATE	☐	PIQ_GB_UCAS_ENTRY_DATE	PIQ_GB_UCAS_ENTRY_DATE	DATS	8	0	UCAS: Date of Entry
13	ENTRY_POINT	☐	PIQ_GB_UCAS_ENTRY_POINT	PIQ_GB_UCAS_ENTRY_POINT	CHAR	1	0	UCAS: Point of Entry	T7PIQ_GB_ENT_PN
14	CONDITION1	☐	PIQ_GB_UCAS_CONDITIONS	PIQ_GB_UCAS_CONDITIONS	CHAR	197	0	UCAS: Conditions
15	CONDITION2	☐	PIQ_GB_UCAS_CONDITIONS	PIQ_GB_UCAS_CONDITIONS	CHAR	197	0	UCAS: Conditions
16	CONDITION3	☐	PIQ_GB_UCAS_CONDITIONS	PIQ_GB_UCAS_CONDITIONS	CHAR	197	0	UCAS: Conditions
17	REASON	☐	PIQ_GB_UCAS_REASON	PIQ_GB_UCAS_REASON	CHAR	2	0	UCAS: Abbreviation reason for withdrawal/clearing
18	AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
19	UNAME	☐	USRNAME	CHAR12	CHAR	12	0	User Name
20	TIME	☐	UZEIT	UZEIT	TIMS	6	0	Time
21	STATUS	☐	PIQ_GB_UCAS_DEC_STATUS	PIQ_GB_UCAS_DEC_STATUS	CHAR	1	0	UCAS: Status of an applicant record
22	PASSPORTID	☐	PIQ_GB_UCAS_PASSID	PIQ_GB_UCAS_PASSID	CHAR	6	0	UCAS: Passport ID
23	COPYFORM	☐	PIQ_GB_UCAS_COPYF	PIQ_GB_UCAS_COPYF	CHAR	1	0	UCAS: Flag, Copy Form required
24	PERSONALID_IND	☐			CHAR	1	0
25	PERSONALID	☐	PIQ_GB_UCAS_PERSONALID	PIQ_GB_UCAS_PERSONALID	CHAR	10	0	UCAS : ucaslink Personal Id
26	APPL_SCHEME_CODE	☐	PIQ_GB_UCAS_APPLSCHCODE	CHAR4	CHAR	4	0	UCAS: Application Scheme Code
27	OFFER_LEVEL	☐	PIQ_GB_UCAS_OFFERLEVEL	PIQ_GB_UCAS_OFFERLEVEL	CHAR	1	0	UCAS: Student Offer Level	T7PIQ_GB_OFFRLEV
28	NACHN	☐	NACHN	NACHN	CHAR	25	0	Last Name
29	VORNA	☐	VORNA	VORNM	CHAR	25	0	First Name
30	COND_MARK	☐			CHAR	4	0
31	MARK	☐			CHAR	1	0
32	CHECKED	☐			CHAR	4	0

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	472