SAP ABAP Table PIQ_GB_UCAS_DEC01 (UCAS: Help structure 1 decision transaction)

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_DEC01	Table Relationship Diagram
Short Description	UCAS: Help structure 1 decision transaction

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	ST_STUDENT12	☐	PIQSTUDENT12	PIQSTUDENT12	CHAR	12	0	Student Number
2	ST_PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
3	ST_OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
4	ST_OBJID	☐	PD_OBJID_R	NUM08	NUMC	8	0	Object ID
5	ST_SEARK	☐	PIQSTSRK	CHAR12	CHAR	12	0	Student
6	ST_NAME	☐	PIQSTDTX	TEXT40	CHAR	40	0	Student's Name (Sortable)
7	ST_NACHN	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
8	ST_VORNA	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
9	ST_GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
10	ST_GESCH	☐	GESCH	GESCH	CHAR	1	0	Gender Key
11	ST_ANRED	☐	ANRDE	ANRDE	CHAR	1	0	Form-of-Address Key	T522G
12	ST_ADAREA	☐	PIQORIGIN	PIQORIGIN	CHAR	4	0	Origin	T7PIQORIGIN
13	SC_SEARK	☐	PIQSCSRK	CHAR12	CHAR	12	0	Program of Study
14	SC_OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
15	SC_OBJID	☐	PIQSCOBJID	HROBJID	NUMC	8	0	Program ID	*
16	SC_BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
17	SC_ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
18	SC_SHORT	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
19	SC_TEXT	☐	PIQSCTXT	TEXT40	CHAR	40	0	Program Description
20	SC_MARVIN	☐	PIQ_GB_UCAS_COURSE	PIQ_GB_UCAS_COURSE	CHAR	6	0	UCAS: Course Code	*
21	SC_MARVIN_OLD	☐	PIQ_GB_UCAS_COURSE	PIQ_GB_UCAS_COURSE	CHAR	6	0	UCAS: Course Code	*
22	CHOICE_NO	☐	PIQCHOICE_NO	PIQCHOICE_NO	NUMC	2	0	Program Choice	T7PIQCHOICES
23	KEY_DATE	☐	PIQKEYDATE	DATUM	DATS	8	0	Key Date
24	IT_TRANSACTION	☐	PIQ_GB_UCAS_TRANSACTION_INST	PIQ_GB_UCAS_TRANSACTION	CHAR	2	0	-CM UCAS: Last Transaction sent to UCAS	T7PIQ_GB_TRANS
25	IT_TRANSACTIONT	☐	PIQ_GB_UCAS_DESCRIPTION	TEXT50	CHAR	50	0	-Cm UCAS: Field description
26	IT_DECISION	☐	PIQ_GB_UCAS_DECISION	PIQ_GB_UCAS_DECISION	CHAR	1	0	UCAS: Decision made by the institution	T7PIQ_GB_DECIS
27	IT_DECISIONT	☐	PIQ_GB_UCAS_DESCRIPTION	TEXT50	CHAR	50	0	-Cm UCAS: Field description
28	IT_DECISION_OLD	☐	PIQ_GB_UCAS_DECISION	PIQ_GB_UCAS_DECISION	CHAR	1	0	UCAS: Decision made by the institution	T7PIQ_GB_DECIS
29	IT_REPLY	☐	PIQ_GB_UCAS_REPLY	PIQ_GB_UCAS_REPLY	CHAR	1	0	UCAS: Reply made by applicant	T7PIQ_GB_REPLY
30	IT_ENTRY_DATE	☐	PIQ_GB_UCAS_ENTRY_DATE	PIQ_GB_UCAS_ENTRY_DATE	DATS	8	0	UCAS: Date of Entry
31	IT_ENTRY_DATE_OLD	☐	PIQ_GB_UCAS_ENTRY_DATE	PIQ_GB_UCAS_ENTRY_DATE	DATS	8	0	UCAS: Date of Entry
32	IT_ENTRY_POINT	☐	PIQ_GB_UCAS_ENTRY_POINT	PIQ_GB_UCAS_ENTRY_POINT	CHAR	1	0	UCAS: Point of Entry	T7PIQ_GB_ENT_PN
33	IT_ENTRY_POINTT	☐	PIQ_GB_UCAS_DESCRIPTION	TEXT50	CHAR	50	0	-Cm UCAS: Field description
34	IT_REASON	☐	PIQ_GB_UCAS_ABBREV	PIQ_GB_UCAS_ABBREV	CHAR	2	0	UCAS: Abbreviations	T7PIQ_GB_ABBR
35	IT_REASONT	☐	PIQ_GB_UCAS_ABBREV_DESC	PIQ_GB_UCAS_ABBREV_DESC	CHAR	60	0	UCAS: Abbreviation Description
36	O_OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
37	O_OBJID	☐	PD_OBJID_R	NUM08	NUMC	8	0	Object ID
38	O_SEARK	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
39	O_SHORT	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
40	O_TEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
41	O_BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
42	O_ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
43	O_CAMPUS	☐	PIQ_GB_UCAS_CAMPUS	PIQ_GB_UCAS_CAMPUS	CHAR	1	0	UCAS: Campus Id	T7PIQ_GB_CAMPUSM
44	PASSPORTID	☐	PIQ_GB_UCAS_PASSID	PIQ_GB_UCAS_PASSID	CHAR	6	0	UCAS: Passport ID
45	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_DEC01	CHOICE_NO	T7PIQCHOICES	CHOICE_NO	REF	1	CN
2	PIQ_GB_UCAS_DEC01	IT_DECISION	T7PIQ_GB_DECIS	DECISION
3	PIQ_GB_UCAS_DEC01	IT_DECISION_OLD	T7PIQ_GB_DECIS	DECISION
4	PIQ_GB_UCAS_DEC01	IT_ENTRY_POINT	T7PIQ_GB_ENT_PN	POINT_OF_ENTRY	REF	1	CN
5	PIQ_GB_UCAS_DEC01	IT_REASON	T7PIQ_GB_ABBR	ABBREV	REF	1	CN
6	PIQ_GB_UCAS_DEC01	IT_REPLY	T7PIQ_GB_REPLY	REPLY
7	PIQ_GB_UCAS_DEC01	IT_TRANSACTION	T7PIQ_GB_TRANS	UCAS_TRANSACTION
8	PIQ_GB_UCAS_DEC01	O_CAMPUS	T7PIQ_GB_CAMPUSM	CAMPUS	REF	1	CN
9	PIQ_GB_UCAS_DEC01	ST_ADAREA	T7PIQORIGIN	ORIGIN	REF	1	CN
10	PIQ_GB_UCAS_DEC01	ST_ANRED	T522G	ANRED		1	CN
11	PIQ_GB_UCAS_DEC01	ST_OTYPE	T778O	OTYPE	REF	1	CN
12	PIQ_GB_UCAS_DEC01	ST_PLVAR	T778P	PLVAR	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in