Name Description Source Use
ASSESSMENT_CLEAN_2021

Contains details of the assessments submitted in the undergraduate assessment data collected by HESA from medical schools

Can be used to interpret student assessment data.

 HESA Reference table
CR_COURSE Course details mapped to HESA values GMC Reference table
CR_EXAM Contains details for the Royal College and faculty exams found in EXAM_TOTAL_MARKS and EXAM_SECTION_MARKS GMC Reference table
CR_FP Contains details of the SJT used in the foundation recruitment GMC Reference table
CR_ITEMS_TO_INDICATORS Training indicators mapped to questions from NTS survey for analysis of survey responses. GMC (NTS) Reference table
CR_ITEMS_TO_INDICATORS_QUESTIONS Question text associated with questions that form training indicators. GMC (NTS) Reference table
CR_MEDICAL_SCHOOL_NAMES Contains the medical school data for an individual GMC Reference table
CR_ONS_POSTCODE Details postcode and linked geographical data from Office for National Statistics. See ONS for details on data included in this table GMC Reference table
CR_UKPRN Reference table for medical schools UKPRN GMC Reference table
CR_UKPRN_NAME Maps the UKPRN with the institution GMC Reference table
CR_UKPRN_SCHOOL_ASSESS UKPRNs associated with each UK medical school. GMC Reference table
NTS_ITEM_TRACKER

This table contains a record of the items used in the NTS with one row per item per answer per year.
Use this table to specify which items are required in extracts.

Generic and demographic final questionnaire can be found in Annex A for each year. NTS breifing notes can be found here.

 GMC (NTS) Reference table
ORGANISATION_LIVE Contains details for individual organisations

GMC

ODS

 Reference table