CUKAS - Availability of information

Availability of UCAS Data for HESA information

What is this information?

This is the information used in the UCAS Data for HESA transaction. The majority of this data is available from UCAS prior to the release of the transaction.

Where is this information available?

UCAS provides various other transactions (known as ivStar transactions) through odbc-link. Find out more about odbc-link.

What is available?

The majority of UCAS Data for HESA fields are available.

The exceptions being:

Subject Qualification Aim 1 - 3 (SBJQA 1 -3)
Subject Percentage 1 -3 (SBJPCT 1 - 3)
Highest Qualification on Entry (QUALENT3)

Caveats

Not all fields will be in a HESA Student Record compliant format.

Some data is not available until the end of cycle / after A-level results day.

Some data has to be derived.

The data

The data can be split into four groups:

Data available on accept

Data derivable on accept

Data available after A-level results day

Data available at end of cycle

Data available on accept

The following data is available for applicants after they are GU1:

CUKAS Application Code: From all ivcStar transactions as Appno
CUKAS Personal ID: From all ivcStar transactions as Personalid
Application Scheme Code: From all ivcStar transactions as ApplicationSchemeCode
Scottish Candidate Number: From ivcStarK as SCN
Surname: From ivcStarN as Surname
Forenames: From ivcStarN as Forenames
Date of birth: From ivcStarN as BirthDate
Gender: From ivcStarN as Sex
Area of permanent residence: From ivcStarK as APR
Nationality: From ivcStarK as Nationality
Disability: From ivcStarK as Disability
Postcode: From ivcStarA as Postcode
National identity: From ivcStarK as Nationalidentity1
Unique Learner Number: From ivcStarN as UniqueLearnerNumber

Below is a table representing which data items are available from which ivcStar transaction.

Fieldname	starA	starK	starN
CUKAS Application Code	X	X	X
CUKAS Personal ID	X	X	X
Application Scheme Code	X	X	X
Scottish Candidate Number		X
Surname			X
Forenames			X
Date of birth			X
Gender			X
Area of permanent residence		X
Nationality		X
Disability		X
Postcode	X
National identity		X
Unique Learner Number			X

Data derivable on accept

You will need the applicant's Application Number or Personal ID and Application Scheme Code to find the following information.

The following data can be derived for applicants after they are GU1:

Year left last institution: From ivcEducation as Year To using the Year To field with the value closest to the current date
Welsh Baccalaureate: From ivcFormQuals using the Qual Type and Result field. If the applicant has a Qual Type of 'WB' they have a Welsh Baccalaureate. The Result field will indicate if the qualification is pending or not

Below is a table representing which data items are available from which ivcStar Transaction.

Fieldname	Education	FormQuals
CUKAS Application Code	X	X
CUKAS Personal ID	X	X
Application Scheme Code	X	X
Year left last institution	X
Previous institution	X
Welsh Baccalaureate		X

Data available after A-level results day

You will need the applicant's Application Number or Personal ID and Application Scheme Code to find the following information.

The following data is available for applicants after A-level results day:

Qualification grade 1 - 30: From ivcStarPQR as EBLresult
To find the corresponding qualification sitting, qualification subject, qualification type and qualification year your need the SubjectID from ivcStarPQR relating to the qualification grade
Qualification siting 1 - 30: From cvELBSubject as Sitting
Qualification subject 1 - 30: From cvELBSubject as SubjCode
Qualification type 1 - 30: From cvELBSubject as ExamLevel
Qualification year 1 - 30: From cvELBSubject as Year

Below is a table representing which data items are available from which ivcStar transaction.

Fieldname	cvEBLSubject	starPQR
CUKAS Application Code		X
CUKAS Personal ID		X
Application Scheme Code		X
Qualification grade 1 - 30		X
Qualification sitting 1 - 30	X
Qualification subject 1 - 30	X
Qualification type 1 - 30	X
Qualification year 1 - 30	X

Data available at end of cycle

You will need the applicant's Application Number or Personal ID and Application Scheme Code to find the following information.

The following data is available for applicants at the end of the cycle:

Ethnicity: From ivcStarH or ivcStarX as Ethnic
Year left last institution: From ivcStarH as EducationLeaveDate
(Year left last institution is also derivable on GU1)
Socio-economic code: From ivcStarX as SocioEconomic
Standard occupational classification: From ivcStarH or ivcStarX as POCC
Previous institution: From ivcStarH as LastEducation
(Previous institution is also available on GU1)
National identity: From ivcStarX as Nationalidentity1
(National identity is also available on GU1)

Below is a table representing which data items are available from which ivcStar transaction.

Fieldname	starH	starX
CUKAS Application Code	X	X
CUKAS Personal ID	X	X
Application Scheme Code	X	X
Ethnicity	X	X
Year left last institution	X
Socio-economic code		X
Standard occupational classification	X	X
National identity		X