Skip to main content

HESA Collections

Back to C20055

Data Model / Data Items

Version 1.0 Produced 2020-10-23

HESA Assessment data record entity relationship diagram

Assessment data record entity

Contents:

Table 1 - ASSESSMENT

Field description Field long name Definition / Guidance Sample entry Completed by Mandatory or desirable
ASSESSID Assessment identifier Primary key for Assessment table.
Identifier for the assessment, formed from a concatenation of UKPRN, year of programme and a consecutive number.
If assessments are changed substantially, they will require a new ID.
Schools with two UKPRNS will have both reflected in the ID.
10007158_Y0_A1
or
10006386_10007158_Y0_A1
GMC assigned Mandatory
COURSE Course name The course this assessment is used for if schools run more than one course. BM6 School Mandatory
ASSESSNAME Assessment name The school's internal identifier for the assessment. HSFI MEDI0011 School Mandatory
ASSESSTYPE Assessment type A description of the type of assessment used. University controlled free text. Exam (50%)
eAssignment & Presented (50%)
School Mandatory
MLACPSA Medical Licensing Assessment, Clinical and Professional Skills Assessment Percentage contribution of the assessment to the overall MLACPSA assessment.
If the MLACPSA includes more than one school assessment, then the value will be less than 100.
Some assessments particularly in the earlier years will be summative but will not count to the MLACPSA so the value will be 0.
0 School Mandatory
ASSESSDESCRIP Assessment description School's description of assessment.
University controlled free text.
Human Structure and Function I School Mandatory
ASSESSYEARPROG Year of programme The year of the student's programme the assessment is sat. 0 School Mandatory
TOTALSCOREMETHOD Total score methodology Free text field.
Method for total score — e.g.
The percentage contribution of each component. Is the standard error added to the total score? Is negative marking used?
Enter NA if not applicable.
Practical Report weight 50%
Multiple Choice Paper weight 25%
Written Paper weight 25%
School Mandatory - if applicable
SCORETYPE Score type Possible values could include:
  • Raw score
  • Percentage
  • University alphanumeric grade
Percentage School Mandatory
STANDARDSETTING Standard setting Description of the standard setting method used, for example:
  • Angoff method
  • Borderline group
Enter NA if not applicable.
Angoff School Mandatory
YEARSTART Year the assessment started The first academic year the assessment was used and included in this collection.
The value will be 2020/21 for all entries in 2020/21.
2020/21 School Mandatory
YEAREND Year the assessment ended The last academic year the assessment was used and included in this collection. If the assessment will be included in next year's return please leave blank. School Optional
EPMWEIGHT Educational Performance Measure weighting The weighting given to the assessment when calculating the student's EPM decile score for their foundation programme application.
EPM score is described here:
https://foundationprogramme.nhs.uk/faqs/educational-performance-measure-epm-faqs/.
0 School Mandatory
SPECIALARRANGEMENTS Special arrangements due to COVID-19 for academic year 2020/21 For schools to record any arrangements, adjustments or changes made to this assessment during the 2020/21 academic year due to the Covid-19 pandemic. These changes may relate to a variety of areas, e.g. delivery format, marking, content and dates held.
Enter NA if not applicable.
We hope this information will not be required in subsequent academic years.
It's been decided that in 2020-21 there will only be 2 SBA's (one in Jan and one in May), the November 2020 SBA has been cancelled. School Mandatory

Table 2 - STUDENT ASSESSMENT

Field description Field long name Definition / Guidance Sample entry Completed by Mandatory or desirable
STUDENTASSESSMENTID Student assessment identifier Primary key for Student Assessment table.
Identifier for this student on this assessment.
Student Assessment 1 GMC assigned N/A
ASSESSID Assessment identifier Assessment identifier
This identifier is the foreign key link to the ASSESSMENT table.
10007158_Y0_A1 GMC assigned Mandatory
OWNSTU Provider's own identifier for student HESA guidance:
Student.OWNSTU
GMC will validate by linking to the HESA Student Record data we receive. We will report on linkage failures.
Own01 School Mandatory
HUSID HESA unique student identifier HESA guidance:
Student.HUSID
0710641234565 School Optional
SURNAME Family name HESA guidance:
Student.SURNAME
Names are present in the sample exam board spreadsheets.
Names will not be included in final data but will be used to validate OWNSTU.
Surname School Mandatory
FNAMES Forenames HESA guidance:
Student.FNAMES
Names are present in the sample exam board spreadsheets.
Names will not be included in final data but will be used to validate OWNSTU.
Forename School Mandatory
STUDENTSCORE Student's overall score Student's overall raw score on an assessment or total score for all stations on a clinical exam or university alphanumeric grade.
This may be a percentage.
99 School Mandatory
RESULTCATEGORY Result category Type of result category, for example:
  • Borderline,
  • Distinction etc.
Not all schools classify all results or may only classify performance across all assessments in the year.
Distinction School Desirable - if available
ADJUSTMENT Adjustments for student Details of any adjustment the student had whilst sitting the exam, for example the amount of extra time. This was the adjustment School Desirable - if available
ATTEMPTNUMBER Attempt number Whether this was the student's 1st, 2nd etc. attempt at the exam.
Attempt number may be reset following an appeal/mitigating circumstances.
ATTEMPTNUMBER will indicate whether the attempt was a resit.
2 School Desirable - if available
NSTATPASS Number of stations passed Total number of stations passed, if applicable. (OSCE only) 6 School If applicable
STUDENTRESULT Student's result Pass or fail.
For clinical exams a pass may be based on the STUDENTSCORE greater than or equal to the EXAMPASSMARK and NSTATPASS being greater than STATIONREQ.
Pass School Mandatory

Table 3 - PASSMARK

Field description Field long name Definition / Guidance Sample entry Completed by Mandatory or desirable
ASSESSID Assessment identifier This identifier is the foreign key link to the ASSESSMENT table. 10007158_Y0_A1 GMC assigned Mandatory
DATEASSESSMENT Date of assessment Date, as defined by the school, of when the assessment was taken. 2020-02-20 School Mandatory
DATEDEFINITION Source of date Source of the date used in DATEASSESSMENT.
This may differ by provider depending on what is recorded.
It may be the date of first sitting the assessment or date results published.
Internal records School Mandatory
EXAMPASSMARK Exam pass mark Pass mark for sitting this assessment.
To allow calculation of score relative to pass, this may vary by sitting.
50 School Mandatory
MAXSCORE Maximum score Maximum possible score for this assessment.
To allow scores to be converted to percentage if required.
60 School Mandatory
STATIONREQ Stations required Only applicable to some clinical exams.
Number of station passes required to pass exam.
4 School Mandatory - if applicable

Need help?

Contact Liaison by email or on +44 (0)1242 388 531.