Skip to main content

HESA Collections

Back to C23055

Table 2 - STUDENT ASSESSMENT - results data for all student attempts at an assessment

Version 1.0 Produced 2024-05-08

Field name Field long name Definition Data type Sample entries Essential or desirable Further notes and guidance
STUDENTASSESSMENTID Student assessment identifier Primary key for Student Assessment table. Identifier for this student on this assessment. A concatenation of HUSID, ASSESSID and ATTEMPTNUMBER. Text "10001111_10007158_Y0_A1 N/A GMC will assign these IDs during the load process. Please leave this field blank.
ASSESSID Assessment identifier Assessment identifier. Foreign key link to ASSESSMENT table Text "10007158_Y1_A1"
"10006386_10007158_Y1_A1"
Essential The value of this field should correspond to the value in the ASSESSMENT table for this assessment/row of data.
OWNSTU Provider's own identifier for student The internal university ID number for the individual student. This may be a string of numbers, letters, and other characters such as slashes. Further deatils can be found within the coding manual
Text "2145672 Essential Your medical school may assign additional identifiers such as 'candidate number' or 'college number'. For this field, we require the university ID number as assigned to the student by the institution upon their enrolment.
HUSID HESA unique student identifier This is the unique ID given by HESA to all higher education students, that follows students as and when they move between institutions. This is a string of 13 digits. Further details can be found within the coding manual Text "1712345671238 Optional This data item may not be routinely used by your medical school and not included in spreadsheets used internally for assessment management.
As such, this field is optional.
If you wish to include this data item but do not routinely use it, your institution's registry or equivalent department should be able to help.
SURNAME Family name Family name of the individual student.
Further details on how HESA handles names can be found on the coding manual
Please note that the final dataset will not include identifiers such as names.
Text "Bloggs Essential Please note that the final dataset will not include identifiers such as names. They are included in the dataset so GMC colleagues can link the data to other UKMED datasets.
FNAMES Forenames Forenames of the individual student
Further details on how HESA handles names can be found on the coding manual
Text "Charlie Ashley" Essential Please note that the final dataset will not include identifiers such as names. They are included in the dataset so GMC colleagues can link the data to other UKMED datasets.
STUDENTSCORE Student's overall score The students final score for the assessment this row of data relates to. Number "99" Essential Please ensure that this score is expressed the same way as stated in the ASSESSMENT table and PASSMARK table.
For example, where ASSESSMENT states a score should be a percentage (and PASSMARK provides a MAXSCORE of 100, valid value would be 0-100.
An incorrect approach would be to state a score is a percentage in ASSESSMENT, then provide a raw score in STUDENTSCORE.
If a student did not sit an exam during a sitting and thus there is no STUDENTSCORE for that sitting, do not include that row of data.
ADJUSTMENT Adjustments for student Details of any adjustment the student had whilst sitting the exam, for example the amount of extra time. Text "10 extra minutes per hour"
"Additional 5 mins breaks per hour"
"Single occupancy room"
"Student is allowed a calculator"
Desirable - if available Please ensure ADJUSTMENT values do not include any student forenames or surnames or other identifiable information.
ATTEMPTNUMBER Attempt number Whether this was the student's 1st, 2nd etc. attempt at the exam. Number "1"
"2"
"3"
"0"
Optional Where STUDENTRESULT is 'Deferred' or 'Nullified', please set ATTEMPTNUMBER as zero. 
If a student did not sit an exam during a sitting and thus there is no STUDENTSCORE for that sitting, do not include that row of data.
NSTATPASS Number of stations passed Clinical exams only. Total number of stations passed or failed, if applicable. Number "7" If applicable
STUDENTRESULT Student's result Pass or fail for most attempts
Other values: "Deferred" (where a first attempt is not sat and the student is allowed to take the resit sitting as a first attempt), "Nullified" (where a first attempt is sat but discounted by exam board and the resit counts as a first attempt).
Number "Pass"
"Fail"
"Deferred"
"Nullified"
Essential Where STUDENTRESULT is 'Deferred' or 'Nullified', please set ATTEMPTNUMBER as zero.
DATEASSESSMENT Date student sat assessment Date, as defined by the school, of when the assessment was taken for the particular attempt. This will correspond to one of the dates listed for that assessment in the PASSMARK table. Date "21/06/2023" Essential This date should match the DATEASSESSMENT for the relevant sitting as stated in the PASSMARK table.

Need help?

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