SAP ABAP Table PIQ_UCAS_STAR_K (UCAS: Coded Information (Type *K))

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_UCAS_STAR_K	Table Relationship Diagram
Short Description	UCAS: Coded Information (Type *K)

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	APPLICANTID	☐	PIQ_GB_UCAS_APPLICANT_ID	PIQ_GB_UCAS_APPLICANT_ID	NUMC	9	0	UCAS: Applicant number
2	REASON	☐			CHAR	1	0
3	CHA_DATE	☐			CHAR	6	0
4	CWD	☐	PIQ_GB_UCAS_CWD_FLAG	PIQ_GB_UCAS_CWD_FLAG	CHAR	1	0	UCAS: Choice withdrew totally or re-instatement
5	CHA_CWD	☐			CHAR	6	0
6	UCAS_FIRST	☐			CHAR	6	0
7	RUN_NO	☐			NUMC	3	0
8	BIRTHDATE	☐			CHAR	6	0
9	SCHOOL	☐	PIQ_GB_UCAS_SCHOOL_STAR_K	CHAR5	CHAR	5	0	CM UCAS: School ID
10	SEX	☐			CHAR	1	0
11	RES_CAT	☐			CHAR	1	0
12	NEEDS	☐	UCAS_NEEDS	UCAS_NEEDS	CHAR	1	0	UCAS Special Needs
13	DOMICILE	☐	UCAS_DOMICILE	UCAS_COUNTRY	NUMC	3	0	UCAS: Domicile (County) Code	*
14	BIRTH_COUNTRY	☐	UCAS_BIRTH_COUNTRY	UCAS_COUNTRY	NUMC	3	0	UCAS Country of Birth	*
15	NATION	☐	UCAS_NATION	UCAS_COUNTRY	NUMC	3	0	UCAS Nationality Code	*
16	FEE_PAY	☐			NUMC	2	0
17	SUMMER_GCE_A_AS	☐	PIQ_GB_UCAS_GCE_A_AS	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of Summer GCE A/AS-Levels
18	SUMMER_VCE_A_AS	☐	PIQ_GB_UCAS_VCE_A_AS_DB	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of Summer VCE AS/A-Levels and Doubles
19	NOT_USED	☐			CHAR	1	0
20	SQA_FLAG	☐	PIQ_GB_UCAS_SQA_FLAG	PIQ_GB_UCAS_SQA_FLAG	CHAR	1	0	UCAS: Flag SQA applicant
21	BTEC_FLAG	☐	PIQ_GB_UCAS_BTEC	PIQ_GB_UCAS_BTEC	CHAR	1	0	UCAS: BTEC Flag
22	HIG_FLAG	☐	PIQ_GB_UCAS_HHIQ_FLAG	PIQ_GB_UCAS_HHIQ_FLAG	CHAR	1	0	UCAS: HSC/IBAC Flag	*
23	IRISH_FLAG	☐	PIQ_GB_UCAS_IRISH_FLAG	PIQ_GB_UCAS_IRISH_FLAG	CHAR	1	0	UCAS: Irish Leaving Certification Flag
24	WINTER_A	☐	PIQ_GB_UCAS_WINTER_A	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of Winter A-Levels
25	PREV_SUMMER_A	☐	PIQ_GB_UCAS_PREV_A	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of previous Summer A-Levels
26	OTHER_RESULTS	☐	PIQ_GB_UCAS_OTHER_RESULTS	PIQ_GB_UCAS_OTHER_RESULTS	CHAR	1	0	UCAS: Other A/AS/Highers/CSYS Flag
27	EXAM_ACH	☐	PIQ_GB_UCAS_REC_ACHIEVMNT	PIQ_GB_UCAS_REC_ACHIEVMNT	CHAR	1	0	UCAS: Record of Achievement
28	REG_NO	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
29	OEQ	☐	PIQ_GB_UCAS_QEQ	PIQ_GB_UCAS_QEQ	CHAR	1	0	UCAS: OEQ Flag	*
30	ROUTE_B	☐			CHAR	1	0
31	FILLER	☐			CHAR	24	0
32	EAS	☐			CHAR	1	0
33	REG2_NO	☐	PIQ_GB_UCAS_REG_NUM	PIQ_GB_UCAS_REG_NUM	CHAR	13	0	UCAS: BTEC/SQA Scottish Cand. Number
34	PREV_AS	☐	PIQ_GB_UCAS_PREV_AS	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of previous AS-Levels
35	CHOICE_TRANS	☐	PIQ_GB_UCAS_CHOICE_TRANS	PIQ_GB_UCAS_CHOICE_TRANS	CHAR	1	0	UCAS: Choices all transparent flag

History

Last changed by/on	SAP	20090218
SAP Release Created in