UCAS - 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 UF:

UCAS Application Code: From all ivStar transactions as Appno
UCAS Personal ID: From all ivStar transactions as Personalid
Application Scheme Code: From all ivStar transactions as ApplicationSchemeCode
Scottish Candidate Number: From ivStarK as SCN
Surname: From ivStarN as Surname
Forenames: From ivStarN as Forenames
Date of birth: From ivStarN as BirthDate
Gender: From ivStarN as Sex
Area of permanent residence: From ivStarK as APR
Nationality: From ivStarK as Nationality
Disability: From ivStarK as Disability
Postcode: From ivStarA as Postcode
Previous institution: From ivStarK as School
National identity: From ivStarK as Nationalidentity1
Unique Learner Number: From ivStarN as UniqueLearnerNumber
Parental education: From ivStarK as ParentinHE
Expected QUALENT3: From ivStarK as ExpectedQualent3
Attained QUALENT3: From ivStarK as AttainedQualent3

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

Fieldname	starA	starK	starN
UCAS Application Code	X	X	X
UCAS 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
Previous institution		X
National identity		X
Unique Learner Number			X
Parental education		X
Expected QUALENT3		X
Attained QUALENT3		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 UF:

Year left last institution: From ivEducation as Year To using the Year To field with the value closest to the current date
Previous institution: From ivEducation as School using the Year To field with the value closest to the current date
Welsh Baccalaureate: From ivFormQuals 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 ivStar Transaction.

Fieldname	Education	FormQuals
UCAS Application Code	X	X
UCAS 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 ivStarPQR as EBLresult
To find the corresponding qualification sitting, qualification subject, qualification type and qualification year your need the SubjectID from ivStarPQR 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 ivStar transaction.

Fieldname	cvEBLSubject	starPQR
UCAS Application Code		X
UCAS 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 ivStarH or ivStarX as Ethnic
Year left last institution: From ivStarH as EducationLeaveDate
(Year left last institution is also derivable on UF)
Socio-economic code: From ivStarX as SocioEconomic
Standard occupational classification: From ivStarH or ivStarX as POCC
Previous institution: From ivStarH as LastEducation
(Previous institution is also available on UF)
National identity: From ivStarX as Nationalidentity1
(National identity is also available on UF)

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

Fieldname	starH	starX
UCAS Application Code	X	X
UCAS 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
Previous institution	X
National identity		X