HESA Collections
Table 2 - STUDENT ASSESSMENT - results data for all student attempts at an assessment
Version 1.1 Produced 2023-11-15
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.