All Data Dictionary Categories

Name

Description

Source

Use

ASSESSMENT_CLEAN_2021

Description

This tables describes each assessment used by the medical school courses. Available for download in CR_REFERENCE_TABLES.

Refresh frequency

Annual

Stats

FIRST_EVENT_MEASURED	LAST_EVENT_MEASURED	N_DISTINCT_RECORDS	N_RECORDS
2021	2022	365	392

Columns

Column Name	Data Type	Column Description
ASSESSID	VARCHAR2(40)	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.
COURSE	VARCHAR2(400)	The course the assessment was used on, e.g. Standard Entry Medicine.
COURSE_CLEAN	VARCHAR2(400)
ASSESSNAME	VARCHAR2(400)	The school's internal identifier for the assessment.
ASSESSTYPE	VARCHAR2(1100)	A description of the type of assessment used. Medical school controlled free text.
MLACPSA	NUMBER	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.
ASSESSDESCRIP	VARCHAR2(1100)	Medical school’s description of the assessment. Medical school controlled free text.
ASSESSYEARPROG	NUMBER	The year of the student's programme the assessment is sat.
TOTALSCOREMETHOD	VARCHAR2(1100)	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? NA if not applicable.
TOTALSCOREMETHOD_CLEAN	VARCHAR2(1100)
SCORETYPE	VARCHAR2(400)	Possible values could include: Raw score Percentage University alphanumeric grade
SCORETYPE_CLEAN	VARCHAR2(400)
STANDARDSETTING	VARCHAR2(400)	Description of the standard setting method used, for example: Angoff method Borderline group NA if not applicable
YEARSTART	VARCHAR2(20)	The first academic year the assessment was used and included in this collection.
YEAREND	VARCHAR2(20)	The last academic year the assessment was used and included in this collection. If the assessment is still in use this will be blank.
EPM_WEIGHT	VARCHAR2(400)	The weighting given to the assessment when calculating the student's EPM decile score for their foundation programme application. EPM score is described here.
EPM_WEIGHT_CLEAN	VARCHAR2(400)
SPECIAL_ARRANGEMENTS	VARCHAR2(1100)	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.
DATE_UPDATED	DATE	Date this record (i.e. table row) was last amended.

This tables describes each assessment used by the medical school courses. Available for download in CR_REFERENCE_TABLES.

HESA Assessment data record

Informs the GMC and HESA of which assessments are used by which schools and courses in which years. UKMED researchers will use it to interpret student assessment data.

CR_COURSE

Description

Available for download in CR_REFERENCE_TABLES

Refresh frequency

Annual

Stats

N_DISTINCT_RECORDS	N_RECORDS
64	2507

Columns

Column Name	Data Type	Column Description
HESA_UKPRN	VARCHAR2(200)	UK Provider Reference Number
HESA_QUAL_AIM	VARCHAR2(800)	This field describes the general qualification aim of the course and is intended to record the qualification that will be attained as a result of successful completion of studies. In use from 2002/2003 to 2006/2007.
HESA_COURSE_AIM	VARCHAR2(1000)	This field describes the general qualification aim of the course and is intended to record the qualification that will be attained as a result of successful completion of studies. From 2007/08 onwards. See here for further details
HESA_CTITLE	VARCHAR2(1200)	The medical school’s title for the course. The course title as studied in this academic year. See here for further details
HESA_COURSE_TYPE	VARCHAR2(200)	HESA CTITLE AND HESA COURSE_ID were manually mapped to course types in https://www.medschools.ac.uk/studying-medicine/course-types . Possible value include: Standard Entry Medicine Transferred from Oxbridge for year 3 onwards Graduate Entry Programme Medicine with a Gateway Year Medicine with a Preliminary Year Private EU Medicine
MEDICAL_SCHOOL
COURSENAME
COURSELENGTH
TEST
UCASCOURSECODE
COURSETYPE
CTITLE
COURSEID
COURSEAIM
QUALAIM
UKPRN
COMMENTS
HESA_COURSE_ID	VARCHAR2(120)	The universities’ own course identifiers. In use from 2007/2008 onwards. See here.

Available for download in CR_REFERENCE_TABLES

GMC reference table

Reference table

CR_EXAM

Description

Available for download in CR_REFERENCE_TABLES

Refresh frequency

Annual

Stats

FIRST_EVENT_MEASURED	LAST_EVENT_MEASURED	N_DISTINCT_RECORDS	N_RECORDS
2014	2016	115	115

Columns

Column Name	Data Type	Column Description
COLLEGENAMELABEL	VARCHAR2(255)	The table only contains colleges that have signed a UKMED Data Sharing Agreement.
ABBREVIATEDEXAMNAME	VARCHAR2(255)	The name of the exam contained in the college’s submission to the GMC.
EXAMNAME	VARCHAR2(255)	Full name of the exam as per the college website.
DATAYEARINTRODUCED	INTEGER	The first GMC collection year containing this exam.
EXAMTYPE	VARCHAR2(255)
LEVELTAKEN	VARCHAR2(255)	The stage of training at which the exam is typically taken.
SOURCEURL	VARCHAR2(255)	The source of the information about the exam.
SECTIONSCOREAVAILABLE	VARCHAR2(1)	Whether section scores are available for the exam.
TOTALSCOREAVAILABLE	VARCHAR2(1)	Whether a total score is available for the exam.
TYPEOFTOTALSCORE	VARCHAR2(255)	The format of the total score.
COLLEGENAME	VARCHAR2(255)	The table only contains colleges that have signed a UKMED Data Sharing Agreement.
REQUIREDFORPROGRESSIONTO	CLOB	The point in training at which the exam is required to progress – see the path for each specialty here - http://www.gmc-uk.org/education/approved_curricula_systems.asp
COLLEGE_NAME	VARCHAR2(100)	Abbreviated name of college.
COLLEGE_NAME_LABEL	VARCHAR2(400)	Full name of college.
ABBREVIATED_EXAM_NAME	VARCHAR2(400)	Abbreviated exam contained in the college’s submission to the GMC.
EXAM_NAME	VARCHAR2(1000)	Full name of the exam as per the college web site.
DATA_YEAR_INTRODUCED	VARCHAR2(16)	The first GMC collection year containing this exam.
EXAM_TYPE	VARCHAR2(1000)	Example values (not a full list): Single best answer (SBA) questions Multiple Choice Questions Station Based
LEVEL_TAKEN	VARCHAR2(2000)	The stage of training at which the exam is typically taken.
ELIGIBILITY	VARCHAR2(4000)	Who is eligible to take the exam, e.g. UK only, in training only and so forth.
REQUIRED_FOR_PROGRESSION_TO	VARCHAR2(2000)	The point in training at which the exam is required to progress – see the path for each specialty here
SOURCE_URL	VARCHAR2(1000)	The source of the information about the exam.
SECTION_SCORE_AVAILABLE	VARCHAR2(4)	Whether section scores are available for the exam.
TOTAL_SCORE_AVAILABLE	VARCHAR2(4)	Whether a total score is available for the exam.
TYPE_OF_TOTAL_SCORE	VARCHAR2(200)	The format of the total score – percent or integer.

Available for download in CR_REFERENCE_TABLES

GMC reference table

Reference table

CR_FP

Description

Available for download in CR_REFERENCE_TABLES

Refresh frequency

Annual

Stats

FIRST_EVENT_MEASURED	LAST_EVENT_MEASURED	N_DISTINCT_RECORDS	N_RECORDS
2013	2016	12	12

Columns

Column Name	Data Type	Column Description
SJT_SCORED_ITEMS_PART1	NUMBER(8,4)	Number of items in part 1.
QUESTIONPAPER	NUMBER (1,0)	There are three variants of the SJT test paper used within a year. Approximately 6,000 applicants take Paper 1 (December – first sit only); 2,000 take paper 2 (January – first sit plus contingency); <10 take Paper 3 (January – contingency date only).
SJT_RAW_PART1 _MAX	NUMBER(8,4)	Maximum possible score in part 1. Part 1 – ranking (5 options). Marks for near misses. Scores out of 20 though some items are scored out of 19.
SJT_RAW_PART1 _MAX	NUMBER(8,4)	Maximum possible score in part 2. Multiple choice (select 3 from 8). Questions marked out of 12.
DATA_YEAR	VARCHAR2(16)	Derived based on year the extract was received
QUESTION_PAPER	NUMBER	There are three variants of the SJT test paper used within a year. Approximately 6,000 applicants take Paper 1 (December – first sit only); 2,000 take paper 2 (January – first sit plus contingency); <10 take Paper 3 (January – contingency date only).
ITEMS_SCORED	NUMBER	0-60 (in reality, 58, 59 or 60) The SJT test paper comprises 70 items; of these, 10 are trial items, and the SJT final score is based on performance of 60 live items with known psychometric properties. If one of the live items does not perform well psychometrically, it is removed before scoring and test-equating. The placement of trial items changes each year, and these items are not identified.
SJT_SCORED_ITEMS_PART1	NUMBER	Number of items in part 1.
SJT_SCORED_ITEMS_PART2	NUMBER	Number of items in part 2.
SJT_RAW_MAX	NUMBER	Overall maximum possible score.
SJT_RAW_PART1_MAX	NUMBER	Maximum possible score in part 1. Part 1 – ranking (5 options). Marks for near misses. Scores out of 20 though some items are scored out of 19.
SJT_RAW_PART2_MAX	NUMBER	Maximum possible score in part 2. Multiple choice (select 3 from 8). Questions marked out of 12.

Available for download in CR_REFERENCE_TABLES

GMC reference table

Reference table

CR_ITEMS_TO_INDICATORS

Description

Training indicators mapped to questions from NTS survey for analysis of survey responses.

Refresh frequency

Annual

Stats

FIRST_EVENT_MEASURED	LAST_EVENT_MEASURED	N_DISTINCT_RECORDS	N_RECORDS
2012	2022	27	175

Columns

Column Name	Data Type	Column Description

Training indicators mapped to questions from NTS survey for analysis of survey responses.

GMC - National Training Survey

Reference table

CR_ITEMS_TO_INDICATORS_QUESTIONS

Description

Question text associated with questions that form training indicators.

Refresh frequency

Annual

Stats

FIRST_EVENT_MEASURED	LAST_EVENT_MEASURED	N_DISTINCT_RECORDS	N_RECORDS
2012	2022	192	740

Columns

Column Name	Data Type	Column Description
QUESTION_YEAR	NUMBER	Year the question featured as part of National Training Survey.
QUESTION_ITEM	VARCHAR2(200)	Question identifier.
ITEM_TEXT	VARCHAR2(2000)	Question text.
INDICATOR_NAME	VARCHAR2(200)	Indicator mapped to question.
STANDARDS_MAPPING	VARCHAR2(4000)	Standards mapping used.
INDICATOR_CALCULATION	VARCHAR2(2000)	Values assigned to each question response, for use as an indicator.
QUESTION_LASTYEAR	VARCHAR2(200)	Flags that it is the last year that the question was featured as part of the National Training Survey.
QUESTION_FIRSTYEAR	VARCHAR2(200)	Flags that it is the first year that the question was featured as part of the National Training Survey.
QUESTION_TEXT_CHANGE	VARCHAR2(20)	Flags that question text has been modified.
QUESTION_ANSWERS_CHANGE	VARCHAR2(20)	Flags question responses has changed.
QUESTION_REPLACED	VARCHAR2(20)	Flags if question has been replaced.

Question text associated with questions that form training indicators.

GMC - National Training Survey

Reference table

CR_MEDICAL_SCHOOL_NAMES

Description

Available for download in CR_REFERENCE_TABLES

Refresh frequency

Annual

Stats

FIRST_EVENT_MEASURED	LAST_EVENT_MEASURED	N_DISTINCT_RECORDS	N_RECORDS
1989	2019	608801	608801

Columns

Column Name	Data Type	Column Description
PERSON_UID	VARCHAR2(60)	GMC unique doctor reference number for those that registered. For those who did not complete their studies/have not completed to date this will be HESA_HUSID with an ‘H’ prefix. Replaced by extract specific STUDY_ID in de-identified research extracts.
PRIMARY_PMQ_PLACE	VARCHAR2(600)	Primary Medical Qualification awarding body.
PMQ_YEAR	NUMBER	Primary PMQ year.
HESA_UKPRN_FIRST	VARCHAR2(32)	The chronologically first UKPRN number that this student is found to have in HESA_ACAD_YEARS.
HESA_UKPRN_LAST	VARCHAR2(32)	The chronologically last UKPRN number that this student is found to have in HESA_ACAD_YEARS.
MEDICAL_SCHOOL_FIRST	VARCHAR2(400)	The first medical school derived from UKPRN using CR_UKPRN_NAME.
ABBREVIATEDNAME_HESA	VARCHAR2(255)	The abbreviated medical school name associated with the HESA UKPRN value.
ABBREVIATEDNAME_SHORTCODE	VARCHAR2(255)	The abbreviated medical school name associated with the short code value.
MEDICAL_SCHOOL_NAME	VARCHAR2(600)	The best abbreviated medical school name available as described in the introductory text for this table.
MEDICAL_SCHOOL_NAME_SRC	VARCHAR2(50)	The source of the medical school name. Possible values are: Amended to RegistrationShortcode RegistrationShortcode HESA PMQAwardingBody Keele but not whole 5 years so coded to Manchester Non-medical school value
MEDICAL_SCHOOL_SPLIT	VARCHAR2(600)	Contains two medical school where the person has attended two schools as part of an agreed programme, for example St Andrews then Manchester.
MEDICAL_SCHOOL_SPLIT_SRC	VARCHAR2(63)	The source of the medical school split name.
COURSE_TYPE	VARCHAR2(800)	HESA CTITLE AND HESA COURSE_ID were manually mapped to course types in: MSC course types Possible value include: Standard Entry Medicine Transferred from Oxbridge for year 3 onwards Graduate Entry Programme Medicine with a Gateway Year Medicine with a Preliminary Year Private EU Medicine
COURSE_TYPE_SRC	VARCHAR2(31)	The source of the course type value.
HESA_COMYEAR	NUMBER	Year the student started the course extracted from HESA_COMDATE.
PRIMARY_PMQ_SHORTCODE	VARCHAR2(200)	Code used by the GMC to identify medical schools and their awarding bodies, due to changes in awarding bodies, the same medical school can have more than one shortcode.
FIRST_MEDSCHOOL_AFTER_GAP	VARCHAR2(400)	First medical school after any gap (non-continuous ACYEARS) in data from HESA. This variable is derived to capture first medical school of the course completed for students who leave and then start their studies at another school.
HESA_UKPRN_LAST_NAME	VARCHAR2(400)	HESA CTITLE AND HESA COURSE_ID were manually mapped to course types Possible value include: Standard Entry Medicine Transferred from Oxbridge for year 3 onwards Graduate Entry Programme Medicine with a Gateway Year Medicine with a Preliminary Year Private EU Medicine
HESA_UKPRN_FIRST_NAME	VARCHAR2(400)	The name of the university as found in HESA_UKPRN_FIRST. Included here for ease of reporting.
MEDICAL_SCHOOL_LAST	VARCHAR2(400)	The last medical school derived from UKPRN using CR_UKPRN_NAME.

Available for download in CR_REFERENCE_TABLES

GMC reference table

Reference table

CR_ONS_POSTCODE

Description

Available for download in CR_REFERENCE_TABLES

Refresh frequency

Annual

Stats

N_DISTINCT_RECORDS	N_RECORDS
2632804	2632804

Columns

Column Name	Data Type	Column Description
PARISH	VARCHAR2(60)
STREG	VARCHAR2(4)
STATSWARD	VARCHAR2(60)
OA01	VARCHAR2(60)
CASWARD	VARCHAR2(60)
LSOA01	VARCHAR2(60)
MSOA01	VARCHAR2(60)
UR01IND	VARCHAR2(60)
OAC01	VARCHAR2(12)
SCOTPCON	VARCHAR2(40)
GOR
HRO
PCD2	VARCHAR2(32)
PCDS	VARCHAR2(32)
PCD	VARCHAR2(28)
DOINTR	VARCHAR2(24)
DOTERM	VARCHAR2(24)
USERTYPE	VARCHAR2(4)
OSEAST1M	VARCHAR2(24)
OSNRTH1M	VARCHAR2(28)
OSGRDIND	VARCHAR2(4)
OA11	VARCHAR2(36)
CTY	VARCHAR2(36)
LAUA	VARCHAR2(36)
WARD	VARCHAR2(36)
HLTHAU	VARCHAR2(36)
CTRY	VARCHAR2(36)
PCON	VARCHAR2(36)
EER	VARCHAR2(36)
TECLEC	VARCHAR2(36)
TTWA	VARCHAR2(36)
PCT	VARCHAR2(36)
NUTS	VARCHAR2(40)
PARK	VARCHAR2(36)
LSOA11	VARCHAR2(36)
MSOA11	VARCHAR2(36)
WZ11	VARCHAR2(36)
CCG	VARCHAR2(36)
BUA11	VARCHAR2(36)
BUASD11	VARCHAR2(36)
RU11IND	VARCHAR2(8)
OAC11	VARCHAR2(12)
LAT	VARCHAR2(40)
LONGI	VARCHAR2(40)
LEP1	VARCHAR2(36)
LEP2	VARCHAR2(36)
PFA	VARCHAR2(36)
IMD	VARCHAR2(20)
CED	VARCHAR2(60)
NHSER	VARCHAR2(60)
RGN	VARCHAR2(60)
CALNCV	VARCHAR2(60)
STP	VARCHAR2(60)

Available for download in CR_REFERENCE_TABLES

GMC reference table

Reference table

CR_UKPRN

Description

Available for download in CR_REFERENCE_TABLES

Refresh frequency

Annual

Stats

N_DISTINCT_RECORDS	N_RECORDS
49	60

Columns

Column Name	Data Type	Column Description
SHORT_CODE	VARCHAR2(12)	GMC medical school code.
UKPRN	VARCHAR2(32)	UK Provider reference number see: UK Register of Learning Providers.

Available for download in CR_REFERENCE_TABLES

GMC reference table

Reference table

CR_UKPRN_NAME

Description

Available for download in CR_REFERENCE_TABLES

Refresh frequency

Annual

Stats

FIRST_EVENT_MEASURED	LAST_EVENT_MEASURED	N_DISTINCT_RECORDS	N_RECORDS
2003	2021	63	77

Columns

Column Name	Data Type	Column Description
F_CAMPID	VARCHAR2(15)
UKPRN	VARCHAR2(32)	UK Provider reference number see: UK Register of Learning Providers.
NAME	VARCHAR2(400)	Name for the UKPRN.
WEB_NAME	VARCHAR2(400)	Name of medical school on their website.
MEDICAL_SCHOOL	VARCHAR2(200)	Abbreviated medical school name.
SHORT_CODE	VARCHAR2(12)	GMC medical school code.
AWARD_BODY	VARCHAR2(400)	Awarding body –
START_YEAR	VARCHAR2(16)	The year the institution started.
HESA_INST1	VARCHAR2(400)	A teaching institution that is separate from the main university.
UCAS_INSTIT_CODE	VARCHAR2(80)	Three-character code unique to each Higher Education Provider assigned by UCAS.
MEDICAL_SCHOOL_POSTCODE	VARCHAR2(80)	The year the institution started.

Available for download in CR_REFERENCE_TABLES

GMC reference table

Reference table

CR_UKPRN_SCHOOL_ASSESS

Description

UKPRNs associated with each UK medical school.

Refresh frequency

Annual

Stats

N_DISTINCT_RECORDS	N_RECORDS
40	40

Columns

Column Name	Data Type	Column Description
UKPRN_ASSESS	VARCHAR2(17)	UKPRN of medical school in HESA assessment data. UK Register of Learning Providers.
HESA_ASSESS_SCHOOL	VARCHAR2(100)	Medical school associated with UKPRN.

UKPRNs associated with each UK medical school.

GMC reference table

Reference table

ORGANISATION_LIVE

Description

Available for download in CR_REFERENCE_TABLES

Refresh frequency

Annual

Stats

N_DISTINCT_RECORDS	N_RECORDS
140055	140055

Columns

Column Name	Data Type	Column Description
GEOGRAPHIC_DEANERY	VARCHAR2(400)	Geographic Deanery name (value automatically set based on the Board or Trust associated with the NTS data record).
MED_SCHOOL_LETB	VARCHAR2(400)
S_ORG_EXT_ROW_ID	VARCHAR2(60)
LEP_ADMIN_ROWID	VARCHAR2(60)
ORG_NAME	VARCHAR2(1000)	Name of organisation.
ORG_CODE	VARCHAR2(200)
ODS_CODE	VARCHAR2(200)
STATUS	VARCHAR2(200)	Status: Active, Inactive, Closed, Open.
ORG_TYPE	VARCHAR2(200)	Type of organisation.
STAKEHOLDER_TYPE	VARCHAR2(200)
DESIGNATED_BODY_NAME	VARCHAR2(1000)
DB_TYPE	VARCHAR2(200)
DB_GROUP	VARCHAR2(80)
DB_IND	VARCHAR2(4)
RESPONSIBLE_OFFICER_UID	VARCHAR2(48)
EMPLOYER_LIAISON_ADVISER	VARCHAR2(600)
CITY	VARCHAR2(200)
POSTCODE	VARCHAR2(200)
POSTCODE_OUTCODE	VARCHAR2(30)
POSTCODE_TOWN	VARCHAR2(200)
POSTCODE_COUNTY	VARCHAR2(120)
POSTCODE_COUNTRY	VARCHAR2(120)
COUNTY	VARCHAR2(1000)
ODS_NAME	VARCHAR2(1000)
ODS_PAR_CODE	VARCHAR2(200)
ODS_PAR_NAME	VARCHAR2(1000)
ODS_CITY	VARCHAR2(200)
ODS_POSTCODE	VARCHAR2(200)
ODS_POSTCODE_OUTCODE	VARCHAR2(30)
ODS_POSTCODE_TOWN	VARCHAR2(200)
ODS_POSTCODE_COUNTY	VARCHAR2(120)
ODS_POSTCODE_COUNTRY	VARCHAR2(120)
ODS_COUNTY	VARCHAR2(1000)
ODS_COUNTRY	VARCHAR2(1000)
SOURCE	VARCHAR2(200)
RO_START_DATE	DATE
LAT_ORG_CODE	VARCHAR2(200)
POSTCODE_WARD	VARCHAR2(400)
POSTCODE_DISTRICT	VARCHAR2(200)
POSTCODE_REGION	VARCHAR2(200)
ODS_POSTCODE_WARD	VARCHAR2(400)
ODS_POSTCODE_DISTRICT	VARCHAR2(200)
ODS_POSTCODE_REGION	VARCHAR2(200)
SUPPRESS_LRMP_REVAL_FLAG	VARCHAR2(4)
LEVEL_CD	NUMBER
AGORA_ID	VARCHAR2(60)	GMC ID For internal use only.
COUNTRY	VARCHAR2(1000)	Full name of the country in which the school is located.
SHORT_CODE	VARCHAR2(200)	GMC medical school code.
GEOGRAPHIC_LETB	VARCHAR2(400)	Geographic LETB name (value automatically set based on the Board or Trust associated with the NTS data record).

Available for download in CR_REFERENCE_TABLES

GMC

Reference table