IN THIS SITE...
HES Data Dictionary
Admissions
- Admission date check flag (adm_cfl)
- Date of admission (admidate)
- Date of decision to admit (elecdate)
- Date of decision to admit check flag (elec_cfl)
- First regular day or night admission (firstreg)
- Method of admission (admimeth)
- Source of admission (admisorc)
- Waiting time (elecdur)
Augmented/critical care period
- ACP sequence number (acpseq)
- Augmented care location (acploc)
- Augmented care period disposal (acpdisp)
- Augmented care period end date (acpend)
- Augmented care period local ID (acplcid)
- Augmented care period number (acpn)
- Augmented care period outcome indicator (acpout)
- Augmented care period planned indicator (acpplan)
- Augmented care period source (acpsour)
- Augmented care period speciality function code (acpspef)
- Augmented care period start date (acpstar)
- High-dependency care level (depdays)
- Intensive care level days (intdays)
- Number of augmented care periods within episode (numacp)
- Number of organ systems supported (orgsup)
Clinical
- Cause code (cause)
- Cause code - 3 characters (cause3dg)
- Cause code - 4 characters (cause4dg)
- Date of operation (opdte_nn)
- Diagnosis (diag_nn)
- Intended management (intmanig)
- Main operation - three characters (oper3)
- Main specialty (mainspef)
- Operation codes (oper_nn)
- Operation status code (operstat)
- Patient classification (classpat)
- Post-operative duration (posopdur)
- Pre-operative duration (preopdur)
- Primary diagnosis - 3 characters (diag3)
- Primary diagnosis - 4 characters (diag4)
- Primary diagnosis chapter (chapter)
- Treatment specialty (tretspef)
Discharges
- Date of discharge (disdate)
- Destination on discharge (disdest)
- Discharge date check flag (dis_cfl)
- Discharge ready date (disreadydate)
- Method of discharge (dismeth)
Episodes and spells
- Bed days within a year (bedyear)
- Beginning of spell (spelbgin)
- Date episode ended (epiend)
- Date episode started (epistart)
- Duration of spell (speldur)
- End of spell (spelend)
- Episode duration (epidur)
- Episode end date check flag (epie_cfl)
- Episode order (epiorder)
- Episode start date check flag (epis_cfl)
- Episode status (epistat)
- Episode type (epitype)
- Hospital provider spell number (provspno)
- Ward type at start of episode (wardstrt)
Geographical
- Cancer network (cannet)
- Cancer registry (canreg)
- Census output area, 2001 (oacode)
- Census output area, 2001 (6 character) (oacode6)
- County of residence (rescty)
- Current electoral ward (currward)
- Electoral ward in 1981 (ward81)
- Electoral ward in 1991 (ward91)
- Electoral ward in 1998 (ward98)
- Government office region of residence (resgor)
- Government office region of treatment (gortreat)
- Health authority of residence (resha)
- Health authority of treatment (hatreat)
- Local authority district (resladst)
- Local authority district in 1998 (lad98)
- Lower super output area (soal)
- Middle super output area (soam)
- Ordnance survey grid reference (gridlink)
- Patient's health authority of residence, provided by NHS (har)
- Patient's PCT of residence - current (respct06)
- Patient's PCT of residence - historic (respect02)
- Patient's primary care trust of residence (respct)
- Patient's SHA of residence - current (resstha06)
- Patient's SHA of residence - historic (resstha02)
- Patient's strategic health authority of residence (resstha)
- Primary care trust area of treatment (pcttreat)
- Region of treatment (rotreat)
- Regional office of residence (resro)
- Rural / urban indicator (rururb_ind)
- Site code of treatment (sitetret)
- Strategic health authority area of treatment (sthatret)
- Super output area (soacode)
- Westminster parliamentary constituency (pcon)
Healthcare resource groups
- Dominant procedure (domproc)
- Healthcare resource group (HES generated) (hrg_n.n)
- Healthcare Resource group: version 3.1 (hrg_3.1)
- Healthcare resource group: version 3.5 (hrg_3.5)
- NHS-generated HRG code (hrgnhs)
- NHS-generated HRG code version number (hrgnhsvn)
Maternity
- Age of baby in days (neodur)
- Anaesthetic given during labour or delivery (delpren)
- Anaesthetic given post-labour or delivery (delposn)
- Antenatal days of stay (antedur)
- Baby sequence number (babyseq)
- Birth date (baby) (dobbaby)
- Birth order (birorder)
- Birth status (birstat)
- Birth weight (birweit)
- Delivery method (delmeth)
- Delivery method derived (delmethd)
- Delivery place (actual) (delplace)
- Delivery place (intended) (delinten)
- Delivery place change reason (delchang)
- First antenatal assessment date (anasdate)
- Gestation period in weeks at first antenatal assessment (anagest)
- Labour/delivery onset method (delonset)
- Length of gestation (gestat)
- Mother's age at delivery (matage)
- Mother's date of birth (motdob)
- Mother's date of birth check flag (motdob_cfl)
- Neonatel level of care (neocare)
- Number of babies (numbaby)
- Number of baby tails (numtailb)
- Number of previous pregnancies (numpreg)
- Postnatal stay (postdur)
- Resuscitation method (biresus)
- Sex of baby (sexbaby)
- Status of person conducting delivery (delstat)
- Well baby check flag (well_baby_ind)
Organisation
- Commissioner code (purcode)
- Commissioner code status (purval)
- Commissioner's regional office (purro)
- Commissioner's strategic health authority (purstha)
- Commissioning serial number (csnum)
- Health authority area where patient's GP was registered (gppracha)
- Primary care group (pcgcode)
- Primary care trust area where patient's GP practice was registered (gpprpct)
- Primary care trust of responsibility (pctcode)
- Primary Care Trust of responsibility - current (pctcode06)
- Primary Care Trust of responsibility - historic (pctcode02)
- Provider code (procodet)
- Provider code - 3 character (procode3)
- Provider code - 5 character (procode)
- Provider type (protype)
- Regional office area where patient's GP practice was registered (gppracro)
- Strategic health authority area where patient's GP practice was registered (gpprstha)
Patient
- Admin category at start of episode (admincatst)
- Administrative and legal status of patient (category)
- Administrative category (admincat)
- Admission episode flag (admiflag)
- Age at activity date (activage)
- Age at end of episode (endage)
- Age at start of episode (startage)
- Age of baby in days (neodur)
- Age on admission (admiage)
- Date of birth - patient (dob)
- Date of birth check flag - patient (dob_cfl)
- Discharge episode flag (disflag)
- Ethnic category (ethnos)
- Finished consultant episode flag (fceflag)
- In year flag (inyrflag)
- Legal category of patient (leglcat)
- Legal status classification code at start of episode (leglstatst)
- Local patient identifier (lopatid)
- NHS Number (newnhsno)
- Patient ID - HES generated (original) (hesid_orig)
- Patient identifier - HES generated (pseudo_hesid)
- Postcode district of patient's residence (postdist)
- Postcode of patient (homeadd)
- Sex of patient (sex)
Patient pathway
- Duration of elective wait (Waitdays)
- Earliest reasonable date offered (Earldatoff)
- Organisation code (patient pathway id issuer) (orgpppid)
- Patient pathway ID (patpathid)
- RTT period end date (rttperend)
- RTT period start date (rttperstart)
- RTT period status (rttperstat)
- Unique booking reference number (bookrefno)
Period of care
- Admission date check flag (adm_cfl)
- Bed days within a year (bedyear)
- Beginning of spell (spelbgin)
- Date episode ended (epiend)
- Date episode started (epistart)
- Date of admission (admidate)
- Date of decision to admit (elecdate)
- Date of decision to admit check flag (elec_cfl)
- Date of discharge (disdate)
- Destination on discharge (disdest)
- Discharge date check flag (dis_cfl)
- Duration of spell (speldur)
- End of spell (spelend)
- Episode duration (epidur)
- Episode order (epiorder)
- Episode start date check flag (epis_cfl)
- Episode status (epistat)
- Episode type (epitype)
- First regular day or night admission (firstreg)
- Hospital provider spell number (provspno)
- Intended management (intmanig)
- Main specialty (mainspef)
- Method of admission (admimeth)
- Method of discharge (dismeth)
- Patient classification (classpat)
- Source of admission (admisorc)
- Treatment specialty (tretspef)
- Waiting time (elecdur)
- Ward type at start of episode (wardstrt)
Practitioner
- Code of GP practice (gpprac)
- Code of GP Practice (pseudonymised) (pgpprac)
- Code of patient's registered or referring general medical practitioner (reggmp)
- Code of patient's registered or referring general medical practitioner (pseudonymised) (preggmp)
- Consultant code (consult)
- Consultant code (pseudonymised) (pconsult)
- Pseudonymised referrer code (preferrer)
- Referrer code (referrer)
- Referring organisation code (referorg)
Psychiatric
- Age at psychiatric census date (censage)
- Carer support indicator (carersi)
- Date detention commenced (detndat)
- Date detention commenced check flag (det_cfl)
- Detention category (detncat)
- Duration of care to psychiatric census date (cendur)
- Duration of detention (detdur)
- Legal group of patient (legalgpa)
- Legal group of patient (psychiatric) (legalgpc)
- Legal status classification (leglstat)
- Marital status (psychiatric) (marstat)
- Mental category (mentcat)
- Psychiatric history on admission (admistat)
- Status of patient included in psychiatric census (censtat)
- V code indicator (vind)
- Ward type at psychiatric census date (cenward)
Socio-economic
- IMD Barriers to Housing and Services Domain (imd04hs)
- IMD Crime Domain (imd04c)
- IMD Decile Group (imd04_decile)
- IMD Education, Skills and Training Domain (imd04ed)
- IMD Employment Deprivation Domain (imd04em)
- IMD Health and Disability Domain (imd04hd)
- IMD Income Affecting Adults Domain (imd04ia)
- IMD Income Affecting Children Index (imd04ic)
- IMD Income Domain (imd04i)
- IMD Living Environment Domain (imd04le)
- IMD Overall Ranking (imd04rk)
System
- CDS extract date (cdsextdate)
- CDS protocol identifier (cdsverprotid)
- CDS unique identifier (cdsuniqueid)
- CDS version number (cdsversion)
- Combined grossing factor (gross_b)
- Coverage grossing factor (gross_a)
- Date data received (subdate)
- Ethnic category (audit version) (ethrawl)
- Ethnic character (audit version) (ethraw)
- NHS Number status indicator (nhsnoind)
- Origin of primary care group (pcgorig)
- Origin of primary care trust of responsibility (pctorig)
- Origin of Primary care trust of responsibility - current (pctorig06)
- Origin of Primary care trust of responsibility - historic (pctorig02)
- Patient identifier (HES generated) - basis of match (matchid)
- Record identifier (epikey)
- SUS loaded staging date (suslddate)
- SUS record id (susrecid)