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
WD_ACCEPT_CANADA Flag if the medical school is one that Canada accepts as being a valid qualification for application when applying to work in medicine in Canada. WDOMS UKMED
WD_COUNTRY This table provides information for each country that contains a school listed in the World Directory. WDOMS UKMED
WD_PROGRAM This table contains a row for each medical program or track offered by medical schools. One program may be sponsored by multiple schools, and one school may offer several medical programs. WDOMS UKMED
WD_SCHOOL This main table contains one row for each school listed in the World Directory and each parent school (university) with which medical schools may be affiliated. WDOMS UKMED
WD_SCHOOL_AFFILIATION This table maps parent-child school relationships, usually representing medical schools and their parent universities. WDOMS UKMED
WD_SCHOOL_ALTNAME This table contains alternate names by which a school has been known, whether that name is historical or a current variation in language, spelling, or format. WDOMS UKMED
WD_SCHOOL_CONTACT_INFO This table contains phone numbers, fax numbers, and email addresses for schools. Schools may have multiple records for each type. WDOMS UKMED
WD_SCHOOL_PROGRAM This table maps associations between schools (see School.csv) and their various medical programs (see Program.csv). One school may have many programs, and one program may be sponsored by more than one school. WDOMS UKMED
WD_SCHOOL_URL School websites are stored in this table. Schools may have multiple records, usually representing websites in different languages. WDOMS UKMED