Skip to content

Admitted Patient Care

Admitted Patient Care Data Model

Overview

Patient records for all acute emergency admissions for adults (18 years + on day of admission) that had an admission date within the specified study period (see above).

Please check the coding of the variables against those linked to in the ‘Coding/Classification system’ column, this is to ensure data (and therefore analysis) standardisation across sites.

Data Model

Variable name Description Reasoning / Filtering (see Coding / Classification system) Format / Coding / Classification system
patient_id Pseudo individual patient identifier To be able to identify different/the same patient across the dataset, and to identify re-admissions. Derived from NHS Number. No filtering A unique pseudonymous identifier for each individual patient across the dataset
gender Defines the sex of the patient To report on patient demographics. No filtering NHS Data Model PERSON GENDER CODE
ethnos The ethnicity of the patient, as specified by the patient. Groups as defined in the 2001 census. To report on patient demographics. No filtering NHS Data Model ETHNIC CATEGORY
procodet NHS Digital ODS code defining the organisation providing treatment. To be able to identify the trust of the admission NHS Data Model ORGANISATION CODE (CODE OF PROVIDER)
sitetret NHS Digital ODS code defining the site on which the patient was treated within an organisation. Contains the first 3 digits of the provider code of treatment (procodet) with the last two digits being the site identifier. To be able to identify the site of the admission NHS Data Model SITE CODE (OF TREATMENT)
townsend_score_decile Deprivation measure that covers both England and Scotland. To be derived from patient postcode To report on patient demographics. No filtering. (https://statistics.ukdataservice.ac.uk/dataset/2011-uk-townsend-deprivation-scores) Derived from NHS Data Model POSTCODE OF USUAL ADDRESS
admimeth Identifies how the patient was admitted to hospital Will act as a later co-variate to discriminate between elective and emergency admissions. admimeth in (21, 22, 23, 24, 25, 2A, 2B, 2C, 2D, 28)
admisorc Identifies where the patient was immediately prior to admission Used to identify possible care home admissions. No filtering NHS Data Model SOURCE OF ADMISSION CODE (HOSPITAL PROVIDER SPELL)
admidate The date the patient was admitted to hospital at the start of a hospital spell. Start date of hospital spell, to limit the time period of interest. admidate on or after 2021-11-01 and also on or before 2022-10-31
admitime The time the patient was admitted to hospital at the start of a hospital spell. hh:mm:ss format Start time of hospital spell. No filtering NHS Data Model START TIME (HOSPITAL PROVIDER SPELL)
disdest Identifies where the patient was due to go on leaving hospital Can be used to identify discharge to care homes.No filtering NHS Data Model DISCHARGE DESTINATION CODE (HOSPITAL PROVIDER SPELL
dismeth Indicates the circumstances under which a patient left hospital Used to identify deaths. No filtering NHS Data Model DISCHARGE METHOD CODE (HOSPITAL PROVIDER SPELL)
length_of_stay The length of stay of the patient admission. Calculated as the time between a patient's spell start date and spell end date. No filtering Derived from NHS Data Model START DATE (HOSPITAL PROVIDER SPELL) and NHS Data Model DISCHARGE DATE (HOSPITAL PROVIDER SPELL)
epiorder The order of the episode within the current hospital provider spell. 1 indicates the first episode in the hospital provider spell, 2 the second, etc. We wish diagnosis and procedure data from only the first episode of a spell (epiorder = 1). NHS Data Model EPISODE NUMBER
admiage Age on admission To report on patient demographics and to limit to desired cohort.Filter: Admiage equals or is greater than 18 years old NHS Data Model AGE ON ADMISSION
diag_01 The primary diagnosis code recorded for the episode. The classification system in use is ICD-10. Used to identify ambulatory care sensitive conditions. See epiorder. No filtering NHS Data Model PRIMARY DIAGNOSIS (ICD). Code required to be in contemporary ICD-10 coding standard.
diag_NN The secondary diagnosis codes recorded for the episode. The classification system in use is ICD-10. Used to identify ambulatory care sensitive conditions. See epiorder. May include up to 19 secondary diagnosis fields, from 02-20. NHS Data Model SECONDARY DIAGNOSIS (ICD). Code required to be in contemporary ICD-10 coding standard.
opertn_01 The main operative procedure code recorded for the episode. The classification system in use is OPCS-4. See epiorder. No filtering NHS Data Model PRIMARY PROCEDURE (OPCS). Codes required to be in contemporary OPCS-4 coding standard
opdate_01 The date the primary operative procedure took place. See epiorder. No filtering NHS Data Model PROCEDURE DATE
opertn_NN Secondary procedure code See epiorder. No filtering. May include up to 23 secondary procedure fields, from 02-24. NHS Data Model PROCEDURE (OPCS). Codes required to be in contemporary OPCS-4 coding standard
opdate_NN Secondary procedure date See epiorder. No filtering NHS Data Model PROCEDURE DATE
disreadydays Discharge Ready Days - The difference between the discharge ready date and discharge date (in days) No filtering NHS Data Model DISCHARGE READY DATE to the NHS Data Model DISCHARGE DATE

Note: We are aware that the CDS allows for unlimited secondary diagnoses and procedures to be recorded. The first recorded 19 such secondary diagnoses and first 23 such secondary procedures are sufficient for our purposes.