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 = 1 AND classpat = 2 admimeth, classpat Core daycase spells
CLASS_MEDICAL specialty Medical specialties tretspef IN medical tretspef Medical treatment specialties
CLASS_SURGICAL specialty Surgical specialties tretspef IN surgical tretspef Surgical treatment specialties
CLASS_ENDOSCOPY procedures Endoscopy procedures primaryprocedure IN 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 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 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