Skip to content

Classification Register

Routing logic and cohort/subgroup definitions.

Classification ID Type Definition Logic Variables Parent Notes
CLASS_AE_MINOR casemix Minor attendances acuity IN {3,4,5} or acuity IS NULL / unknown acuity CLASS_AE Ambulatory, less severe conditions
CLASS_AE_MAJOR casemix Major attendances acuity = 2 acuity CLASS_AE Serious illnessess and injuries requiring trolley-based care
CLASS_AE_RESUS casemix Resus attendances acuity = 1 acuity CLASS_AE Critically ill or life-threatening emergencies
CLASS_AGE_ADULT age Adult patients age >= 18 years age Age in years at attendance / admission
CLASS_AGE_CHILD age Children age < 18 years age Age in years at attendance / admission
CLASS_AE scope Core A&E attendances aedepttype = 1 aedepttype Core A&E scope; consultant-led 24/7 with full resuscitation facilities; excludes type 2 mono-specialty units.
CLASS_DAYCASE scope Core daycase spells admimeth starts with 1 AND classpat = 2 admimeth, classpat Core daycase spells
CLASS_MEDICAL specialty Medical specialties tretspef IN medical specialties - see daycase_tretspef_mapping.xlsx file tretspef Medical treatment specialties
CLASS_SURGICAL specialty Surgical specialties tretspef IN surgical specialties - see daycase_tretspef_mapping.xlsx file tretspef Surgical treatment specialties
CLASS_ENDOSCOPY procedures Endoscopy procedures primaryprocedure IN
Oesophagoscopy G14, G15, G16, G17, G18, G19, G20
OGD G42, G43, G44, G45, G46
Duodenoscopy G54, G55
Jejunoscopy G64,G65
Ileoscopy G79,G80
Sigmoidoscopy H23, H24, H25, H26, H27, H28, H37, H69, H70, H71
ERCP J38,J39, J40, J41, J42, J43, J44, J45
Colonoscopy H20,H21, H22, H68
Bronchoscopy E48, E49, E50, E51
 primaryprocedure Endoscopy procedures
CLASS_AGE_NEONATAL age Neonate or newborn age < 29 days age Age in years at attendance / admission
CLASS_AGE_PAEDIATRIC age Children (excl. neonates) age >= 29 days AND age < 18 years age Age in years at attendance / admission
CLASS_WELL_BABIES Birth episodes Birth episodes for healthy or well babies
CLASS_CRITICAL_CARE scope
CLASS_ELECTIVE admission_type Elective admissions admimeth LIKE 1* AND classpat = 1 admimeth
CLASS_REGULAR_DAY_NIGHT admission_type Regular day/night admissions classpat IN 3, 4 classpat Patients admitted for a planned series of treatments e.g., renal dialysis
CLASS_RENAL specialty Renal medicine specialty tretspef = 361 tretspef Renal medicine specialty incl. dialysis treatment
CLASS_ZERO_LOS segmentation Zero day length-of-stay spells speldur = 0 speldur
CLASS_NON_ELECTIVE admission_type Non-elective admissions admimeth LIKE 2* AND classpat = 1 admimeth; classpat
CLASS_HAS_PROCEDURE segmentation Spell with recorded procedure has_procedure = 1 has_procedure
CLASS_CARDIAC_CATH procedures Cardiac catheter-based procedures primaryprocedure IN primaryprocedure
CLASS_CARDIOLOGY specialty Cardiology or paediatric cardiology specialties tretspef IN tretspef
CLASS_INT_RADIOLOGY specialty Interventional radiology or paediatric interventional radiology tretspef IN tretspef
CLASS_OP_ATTEND scope atentype IN atentype
CLASS_OP_FACE_TO_FACE attendance_type CLASS_OP_ATTEND
CLASS_OP_FIRST attendance_type CLASS_OP_ATTEND
CLASS_OP_FOLLOW_UP attendance_type CLASS_OP_ATTEND
CLASS_OP_VIRTUAL attendance_type CLASS_OP_ATTEND
CLASS_HAEM_ONC specialty Haematology and oncology specialties tretspef IN 253,303,260,370,800 tretspef Haematology and oncology specialties incl. SACT therapies (chemotherapy and immunotherapy) and blood transfusions.
CLASS_MATERNITY scope Maternity admissions
CLASS_NO_BIRTH_EVENT No birth event recorded CLASS_MATERNITY
CLASS_BIRTH_EVENT Birth event recorded CLASS_MATERNITY
CLASS_BIRTH_NORMAL segmentation R24 normal delivery CLASS_BIRTH_EVENT
CLASS_BIRTH_ASSISTED segmentation R19 breech extraction or R20 other breech or R21 forceps cephalic or R22 vacuum or R23 cephalic vaginal w. abnormal present. head CLASS_BIRTH_EVENT
CLASS_BIRTH_ELECTIVE_CSECTION segmentation R17 elective caesarean CLASS_BIRTH_EVENT
CLASS_BIRTH_NON_ELECTIVE_CSECTION segmentation R18 other caesarean CLASS_BIRTH_EVENT
CLASS_NON_ZERO_LOS segmentation Spells with an overnight stay speldur > 0 speldur
CLASS_SDEC scope SDEC (Same Day Emergency Care) attendances aedepttype = 5 aedepttype See ongoing issue on SDEC classification