SAP ABAP Table PIQ_UCAS_APPS_DETAILS (UCAS : Applicant Details)

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	PIQ_UCAS_APPS_DETAILS	Table Relationship Diagram
Short Description	UCAS : Applicant Details

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	INSTCODE	☐	PIQ_GB_UCAS_INST_ID1	PIQ_GB_UCAS_INST_ID	CHAR	4	0	UCAS: Institution Code	*
2	APPLICANT_NO	☐	PIQ_GB_UCAS_APPLICANT_ID	PIQ_GB_UCAS_APPLICANT_ID	NUMC	9	0	UCAS: Applicant number
3	PERSONALID	☐	PIQ_GB_UCAS_PERSONALID	PIQ_GB_UCAS_PERSONALID	CHAR	10	0	UCAS : ucaslink Personal Id
4	APPL_SCHEME_CODE	☐	PIQ_GB_UCAS_APPLSCHCODE	CHAR4	CHAR	4	0	UCAS: Application Scheme Code
5	ADMISSION_SYS	☐	PIQ_GB_UCAS_ADMISSION_SYSTEM	PIQ_GB_UCAS_ADMISSION_SYSTEM	CHAR	1	0	UCAS : Admission system
6	TITLE	☐	TITEL	TITEL	CHAR	15	0	Title	*
7	LASTNAME	☐	PIQ_NACHN_MC	CHAR40	CHAR	40	0	Last Name (Field for Search Help)
8	FIRSTNAME	☐	PIQ_VORNA_MC	CHAR40	CHAR	40	0	First Name (Search Help Field)
9	ROUTE_B	☐	PIQ_GB_UCAS_ROUTE_B	PIQ_GB_UCAS_INTERV_PRIO	CHAR	1	0	UCAS: I want route B	*
10	GCE	☐	PIQ_GB_UCAS_GCE_A_AS	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of Summer GCE A/AS-Levels
11	VCE	☐	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
12	WINTERALEVELS	☐	PIQ_GB_UCAS_WINTER_A	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of Winter A-Levels
13	PREVSUMALEVELS	☐	PIQ_GB_UCAS_PREV_A	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of previous Summer A-Levels
14	PREVSUMASLEVELS	☐	PIQ_GB_UCAS_PREV_AS	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of previous AS-Levels
15	BTEC	☐	PIQ_GB_UCAS_BTEC	PIQ_GB_UCAS_BTEC	CHAR	1	0	UCAS: BTEC Flag
16	SQA	☐	PIQ_GB_UCAS_SQA_FLAG	PIQ_GB_UCAS_SQA_FLAG	CHAR	1	0	UCAS: Flag SQA applicant
17	OEQ	☐	PIQ_GB_UCAS_QEQ	PIQ_GB_UCAS_QEQ	CHAR	1	0	UCAS: OEQ Flag	*
18	REG_NUMBER	☐	PIQ_GB_UCAS_REG_NUM	PIQ_GB_UCAS_REG_NUM	CHAR	13	0	UCAS: BTEC/SQA Scottish Cand. Number
19	HOME_ADDRESS1	☐			CHAR	40	0
20	HOME_ADDRESS2	☐			CHAR	40	0
21	HOME_ADDRESS4	☐			CHAR	40	0
22	HOME_ADDRESS3	☐			CHAR	40	0
23	HOME_PHONENO	☐			CHAR	20	0
24	HOME_POSTCODE	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
25	HOME_COUNTRY	☐			CHAR	10	0
26	ETHNIC	☐	PIQETHNIC	PIQETHNIC	CHAR	4	0	Ethnic Origin	*
27	ETHNICT	☐	PIQETHNICT	TEXT40	CHAR	40	0	Ethnic Origin (Description)
28	POC	☐	PIQ_GB_UCAS_OCCUPAT	PIQ_GB_UCAS_OCCUPAT	CHAR	4	0	UCAS: Occupational group
29	POCT	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
30	GENDER	☐	GESCH	GESCH	CHAR	1	0	Gender Key
31	DATEOFBIRTH	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
32	EMAILADDRESS	☐	PIQ_GB_UCAS_EMAIL		CHAR	241	0	UCAS: Email address
33	DISABILITYCODE	☐	PIQ_GB_UCAS_DISAB	PIQ_GB_UCAS_DISAB	CHAR	2	0	UCAS: Disabilities
34	DISABILITYDESC	☐	PIQ_GB_UCAS_DISAB_DESC	CHAR30	CHAR	30	0	UCAS : Disability code Description
35	MOBILEPHONENO	☐	AD_MBNMBR1	CHAR30	CHAR	30	0	First Mobile Telephone No.: Dialing Code + Number
36	SPECIALNEEDS	☐	PIQ_GB_UCAS_SPECIAL_NEEDS		LCHR	500	0	UCAS: Special needs declared by the applicant
37	CRIMINAL_CONV	☐			CHAR	1	0
38	KEY_SKILLS	☐			CHAR	1	0
39	VOC_EXAMS	☐			CHAR	1	0
40	IRISH_FLAG	☐	PIQ_GB_UCAS_IRISH_FLAG	PIQ_GB_UCAS_IRISH_FLAG	CHAR	1	0	UCAS: Irish Leaving Certification Flag
41	AIC_FLAG	☐			CHAR	1	0
42	LATEAPP_FLAG	☐	PIQ_GB_UCAS_LATE_APPL_FLAG	PIQ_GB_UCAS_LATE_APPL_FLAG	CHAR	1	0	UCAS: Late Application Flag
43	INT_BACC_FLAG	☐	PIQ_GB_UCAS_EX_IBAC	CHAR1	CHAR	1	0	CM UCAS: Flag International Baccalaureate
44	FEE_PAYER_CODE	☐	PIQ_GB_UCAS_FEE_PAYER	PIQ_GB_UCAS_FEE_PAYER	NUMC	2	0	UCAS: Fee Payer Code	*
45	FEE_PAYER_CODE_DES	☐			CHAR	50	0
46	NAT_INS_NUMBER	☐			CHAR	20	0
47	NATIO	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
48	NATIO_DESC	☐	NATIO50	TEXT50	CHAR	50	0	Nationality (Max. 50 Characters)
49	GBLND	☐	GBLND	LAND1	CHAR	3	0	Country of Birth	*
50	GBLND_DESC	☐	LANDX50	TEXT50	CHAR	50	0	Country Name (Max. 50 Characters)
51	DATE_ENTERED_UK	☐	PIQ_GB_UCAS_DATEENTEREDUK	DATS	DATS	8	0	Date Entered In United Kingdom
52	RESID_STATUS	☐	RESIS	RESIS	CHAR	1	0	Residence status	*
53	RESID_STATUS_DESC	☐	RESTX	TEXT25	CHAR	25	0	Residence status texts
54	APPLICANTSTATUS	☐	PIQ_GB_UCAS_APPLICANT_STATUS	PIQ_GB_UCAS_APPLICANT_STATUS	NUMC	3	0	UCAS : Applicant Status
55	ADDRESS1	☐			CHAR	40	0
56	ADDRESS2	☐			CHAR	40	0
57	ADDRESS3	☐			CHAR	40	0
58	ADDRESS4	☐			CHAR	40	0
59	POSTCODE	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
60	AEDTM_UCAS	☐	PIQ_GB_UCAS_AEDTM	DATS	DATS	8	0	UCAS: Date of the last change made by UCAS
61	UZEIT_UCAS	☐	PIQ_GB_UCAS_UZEIT	UZEIT	TIMS	6	0	UCAS: Time of the last change made by UCAS
62	UCAS_COUNTY	☐			CHAR	3	0
63	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
64	LASTEDUESTA	☐	PIQ_GB_UCAS_SCHOOL	PIQ_GB_UCAS_SCHOOL	CHAR	7	0	UCAS: School Number	*
65	PREFERRED_FNAME	☐	PIQ_GB_UCAS_PRFD_FNAME	CHAR35	CHAR	35	0	UCAS: Applicant Preferred First Name
66	IELTS_NUMBER	☐	PIQ_GB_UCAS_IELTS_NUM	CHAR20	CHAR	20	0	UCAS: Applicant International Eng Lang Testing System Number
67	ISA_NUMBER	☐	PIQ_GB_UCAS_ISA_NUM	CHAR20	CHAR	20	0	UCAS: Applicant Independent Safeguarding Authority Number
68	TOEFL_NUMBER	☐	PIQ_GB_UCAS_TOEFL_NUM	CHAR16	CHAR	16	0	UCAS: Applicant Test of English as a foreign language Number
69	PASSPORTIDATE	☐	PIQ_GB_UCAS_PASSPORTIDATE	PIQ_GB_UCAS_PASSPORTIDATE	DATS	8	0	UCAS: Passport Issue Date
70	PASSPORTNUMBER	☐	PIQ_GB_UCAS_PASSPORTNUMBER	PIQ_GB_UCAS_PASSPORTNUMBER	CHAR	35	0	UCAS: Passport Number
71	PASSPORTIPLACE	☐	PIQ_GB_UCAS_PASSPORTIPLACE	PIQ_GB_UCAS_PASSPORTIPLACE	CHAR	30	0	UCAS: Passport Place of Issue
72	PASSPORTEDATE	☐	PIQ_GB_UCAS_PASSPORTEDATE	PIQ_GB_UCAS_PASSPORTEDATE	DATS	8	0	UCAS: Passport Expiry Date
73	SCHOOLNUMBER	☐	PIQ_GB_UCAS_SCHOOL	PIQ_GB_UCAS_SCHOOL	CHAR	7	0	UCAS: School Number	*
74	HOMECTRYCODE	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
75	DUAL_NTNLYTCODE	☐	PIQNATS2	LAND1	CHAR	3	0	Second Nationality (Citizenship)	*
76	AGE	☐	PIQ_GB_UCAS_APPL_AGE	NUMC4	NUMC	4	0	UCAS: Applicant Age
77	CARE_CODE	☐	PIQ_GB_UCAS_CARE_CODE	PIQ_GB_UCAS_CARE_CODE	CHAR	10	0	UCAS: Applicant Care Code
78	DATE_APPLIED	☐	PIQ_GB_UCAS_DATE_APPLIED	DATS	DATS	8	0	UCAS: Date of application
79	HIGH_EXP_QUAL	☐	PIQ_GB_UCAS_HIGH_EXP_QUAL	PIQ_GB_UCAS_HIGH_EXP_QUAL	CHAR	1	0	UCAS: Highest level of qualification expected
80	INCARE_DURATION	☐	PIQ_GB_UCAS_INCARE_DURATION	PIQ_GB_UCAS_INCARE_DURATION	CHAR	1	0	UCAS: Duration of been in care
81	PARENTAL_HECODE	☐	PIQ_GB_UCAS_PARENTAL_HECODE	PIQ_GB_UCAS_PARENTAL_HECODE	CHAR	10	0	UCAS: Parent's Higher Education
82	PREVIOUS_SURNAME	☐	PIQ_GB_UCAS_PREVIOUS_SURNAME	PIQ_GB_UCAS_PREVIOUS_SURNAME	CHAR	30	0	UCAS: Previous Surname
83	POLAR2	☐	PIQ_GB_UCAS_POLAR2_SCORE		NUMC	4	0	UCAS: HEFCE Polar2 Score
84	UNAVAIL_INTDATES	☐	PIQ_GB_UCAS_UNAVAIL_INTDATES		CHAR	250	0	UCAS: Unavailable Interview Dates

History

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