Calculation Traceability Matrix¶
The glue table that links classifications, assumptions, archetypes and outputs.
A CTM row represents a unique workload-to-capacity calculation pathway requiring distinct classifications, assumptions, workload derivation logic or capacity outputs.
| Functional area | Subgroup | Classification IDs | Workload Assumptions | Formula ID | Operational Assumptions | Capacity Output |
|---|---|---|---|---|---|---|
| BAYS_AE | adult minor | CLASS_AE, CLASS_AGE_ADULT, CLASS_AE_MINOR | AE_ADULT_MINOR_LOS | FRM_FLOW_SPACE | AE_ADULT_MINOR_UTIL, AE_BAYS_ANNUAL_OPERATIONAL__HOURS | ADULT_MINOR_AE_BAYS |
| BAYS_AE | child minor | CLASS_AE, CLASS_AGE_CHILD, CLASS_AE_MINOR | AE_CHILD_MINOR_LOS | FRM_FLOW_SPACE | AE_CHILD_MINOR_UTIL, AE_BAYS_ANNUAL_OPERATIONAL_HOURS | CHILD_MINOR_AE_BAYS |
| BEDS_AE | adult major | CLASS_AE, CLASS_AGE_ADULT, CLASS_AE_MAJOR | AE_ADULT_MAJOR_LOS | FRM_FLOW_SPACE | AE_ADULT_MAJOR_UTIL, AE_BEDS_ANNUAL_OPERATIONAL_HOURS | ADULT_MAJOR_AE_BEDS |
| BEDS_AE | child major | CLASS_AE, CLASS_AGE_CHILD, CLASS_AE_MAJOR | AE_CHILD_MAJOR_LOS | FRM_FLOW_SPACE | AE_CHILD_MAJOR_UTIL, AE_BEDS_ANNUAL_OPERATIONAL_HOURS | CHILD_MAJOR_AE_BEDS |
| BEDS_AE | resus | CLASS_AE, CLASS_AE_RESUS | AE_RESUS_LOS | FRM_FLOW_SPACE | AE_RESUS_UTIL, AE_BEDS_ANNUAL_OPERATIONAL_HOURS | RESUS_AE_BEDS |
| THIS ALL NEEDS CHECKING | ||||||
| BEDS_DAYCASE_RECOVERY | Adult medical | CLASS_DAYCASE_RECOVERY, CLASS_AGE_ADULT, MAP_MEDICAL | DAYCASE_RECOVERY_ADULT_MEDICAL_LOS | FRM_RECOVERY_OCCUPANCY | DAYCASE_RECOVERY_ADULT_MEDICAL_OCC, DAYCASE_RECOVERY_ANNUAL_OPER_HOURS | ADULT_MEDICAL_DAYCASE_RECOVERY_BEDS |
| BEDS_DAYCASE_RECOVERY | Adult surgical | CLASS_DAYCASE_RECOVERY, CLASS_AGE_ADULT, MAP_SURGICAL | DAYCASE_RECOVERY_ADULT_SURGICAL_LOS | FRM_RECOVERY_OCCUPANCY | DAYCASE_RECOVERY_ADULT_SURGICAL_OCC, DAYCASE_RECOVERY_ANNUAL_OPER_HOURS | ADULT_SURGICAL_DAYCASE_RECOVERY_BEDS |
| BEDS_DAYCASE_RECOVERY | Paediatric medical | CLASS_DAYCASE_RECOVERY, CLASS_AGE_CHILD, MAP_MEDICAL | DAYCASE_RECOVERY_PAED_MEDICAL_LOS | FRM_RECOVERY_OCCUPANCY | DAYCASE_RECOVERY_PAED_MEDICAL_OCC, DAYCASE_RECOVERY_ANNUAL_OPER_HOURS | PAED_MEDICAL_DAYCASE_RECOVERY_BEDS |
| BEDS_DAYCASE_RECOVERY | Paediatric surgical | CLASS_DAYCASE_RECOVERY, CLASS_AGE_CHILD, MAP_SURGICAL | DAYCASE_RECOVERY_PAED_SURGICAL_LOS | FRM_RECOVERY_OCCUPANCY | DAYCASE_RECOVERY_PAED_SURGICAL_OCC, DAYCASE_RECOVERY_ANNUAL_OPER_HOURS | PAED_SURGICAL_DAYCASE_RECOVERY_BEDS |
| BEDS_DAYCASE_ENDOSCOPY_RECOVERY | All groups | CLASS_DAYCASE_RECOVERY, CLASS_ENDOSCOPY | DAYCASE_ENDOSCOPY_RECOVERY_LOS | FRM_RECOVERY_OCCUPANCY | DAYCASE_ENDOSCOPY_RECOVERY_OCC, DAYCASE_ENDOSCOPY_RECOVERY_ANNUAL_OPER_HOURS | DAYCASE_ENDOSCOPY_RECOVERY_BEDS |
| BEDS_CRITICAL_CARE | Adult | CLASS_AGE_ADULT | CRITICAL_CARE_ADULT_PC_BDS | FRM_BED_OCCUPANCY | CRITICAL_CARE_ADULT_OCC, CRITICAL_CARE_ANNUAL_OPER_HOURS | ADULT_CRITICAL_CARE_BEDS, , |
| BEDS_CRITICAL_CARE | Paediatric | CLASS_AGE_PAED | CRITICAL_CARE_PAED_PC_BDS | FRM_BED_OCCUPANCY | CRITICAL_CARE_PAED_OCC, CRITICAL_CARE_ANNUAL_OPER_HOURS | PAEDIATRIC_CRITICAL_CARE_BEDS |
| BEDS_CRITICAL_CARE | Neonatal | CLASS_AGE_NEONATAL, CLASS_WELL_BABIES | CRITICAL_CARE_NEONATAL_PC_BDS | FRM_BED_OCCUPANCY | CRITICAL_CARE_NEONATAL_OCC, CRITICAL_CARE_ANNUAL_OPER_HOURS | NEONATAL_CRITICAL_CARE_BEDS |
| BEDS_DAYCASE_RENAL | All groups | (CLASS_ELECTIVE AND CLASS_ZERO_LOS AND CLASS_RENAL) OR (CLASS_REGULAR_DAY_NIGHT AND CLASS_RENAL) | none | FRM_SESSION_CAPACITY | RENAL_ANNUAL_SESSION_CAPACITY_PER_BED | RENAL_DAYCASE_BEDS |
| THEATRES_DAYCASE_PROC | Adult surgical | CLASS_DAYCASE, CLASS_HAS_PROCEDURE. CLASS_AGE_ADULT, MAP_SURGICAL | DAYCASE_THEATRE_ADULT_SURGICAL_PROC_TIME | FRM_TIME_UTIL | DAYCASE_THEATRE_UTIL, DAYCASE_THEATRE_ANNUAL_OPERATIONAL_HOURS | ADULT_SURGICAL_DAYCASE_PROC_THEATRES |
| THEATRES_DAYCASE_PROC | Paediatric | CLASS_DAYCASE, CLASS_HAS_PROCEDURE, CLASS_AGE_CHILD | DAYCASE_THEATRE_PAED_PROC_TIME | FRM_TIME_UTIL | DAYCASE_THEATRE_UTIL, DAYCASE_THEATRE_ANNUAL_OPERATIONAL_HOURS | PAEDIATRIC_DAYCASE_PROC_THEATRES |
| THEATRES_INPATIENT_PROC | Adult elective surgical | CLASS_HAS_PROCEDURE, CLASS_AGE_ADULT, CLASS_ELECTIVE, MAP_SURGICAL | INPATIENT_THEATRE_ADULT_ELEC_SURGICAL_PROC_TIME | FRM_TIME_UTIL | INPATIENT_THEATRE_UTIL, INPATIENT_THEATRE_ANNUAL_OPERATIONAL_HOURS | ADULT_ELECTIVE_SURGICAL_INPATIENT_PROC_THEATRES |
| THEATRES_INPATIENT_PROC | Adult non-elective surgical | CLASS_HAS_PROCEDURE, CLASS_AGE_ADULT, CLASS_NON_ELECTIVE, MAP_SURGICAL | INPATIENT_THEATRE_ADULT_NON_ELECTIVE_SURGICAL_PROC_TIME | FRM_TIME_UTIL | INPATIENT_THEATRE_UTIL, INPATIENT_THEATRE_ANNUAL_OPERATIONAL_HOURS | ADULT_NON_ELECTIVE_SURGICAL_INPATIENT_PROC_THEATRES |
| THEATRES_INPATIENT_PROC | Paediatric elective | CLASS_HAS_PROCEDURE, CLASS_AGE_CHILD, CLASS_ELECTIVE | INPATIENT_THEATRE_CHILD_ELEC_SURGICAL_PROC_TIME | FRM_TIME_UTIL | INPATIENT_THEATRE_UTIL, INPATIENT_THEATRE_ANNUAL_OPERATIONAL_HOURS | PAEDIATRIC_ELECTIVE_INPATIENT_PROC_THEATRES |
| THEATRES_INPATIENT_PROC | Paediatric non-elective | CLASS_HAS_PROCEDURE, CLASS_AGE_CHILD, CLASS_NON_ELECTIVE | INPATIENT_THEATRE_CHILD_NON_ELECTIVE_SURGICAL_PROC_TIME | FRM_TIME_UTIL | INPATIENT_THEATRE_UTIL, INPATIENT_THEATRE_ANNUAL_OPERATIONAL_HOURS | PAEDIATRIC_NON_ELECTIVE_INPATIENT_PROC_THEATRES |
| THEATRES_OBSTETRIC_PROC | All groups | OBSTETRIC_THEATRE_PROC_TIME | FRM_TIME_UTIL | OBSTETRIC_THEATRE_UTIL, OBSTETRIC_THEATRE_ANNUAL_OPERATIONAL_HOURS | OBSTETRIC_PROC_THEATRES | |
| LABS_CARDIAC_CATH_PROC | All groups | (CLASS_CARDIOLOGY AND CLASS_HAS_PROCEDURE) OR (CLASS_CARDIAC_CATH) | LABS_CARDIAC_CATH_PROC_TIME | FRM_TIME_UTIL | LABS_CARDIAC_CATH_UTIL, LABS_CARDIAC_CATH_ANNUAL_OPERATIONAL_HOURS | CARDIAC_CATH_PROC_LABS |
| ROOMS_ENDOSCOPY_PROC | All groups | CLASS_DAYCASE, CLASS_ENDOSCOPY | ENDOSCOPY_PROC_TIME | FRM_TIME_UTIL | ENDOSCOPY_CATH_PROC_UTIL, ENDOSCOPY_CATH_PROC_ANNUAL_OPERATIONAL_HOURS | ENDOSCOPY_PROC_ROOMS |
| ROOMS_INT_RADIOLOGY_PROC | All groups | CLASS_INT_RADIOLOGY, CLASS_HAS_PROCEDURE | INT_RADIOLOGY_PROC_TIME | FRM_TIME_UTIL | INT_RADIOLOGY_PROC_UTIL, INT_RADIOLOGY_PROC_ANNUAL_OPERATIONAL_HOURS | INT_RADIOLOGY_PROC_ROOMS |
| ROOMS_OUTPATIENT_CONSULT | first attendance | CLASS_OP_ATTEND, CLASS_OP_FACE_TO_FACE, CLASS_OP_FIRST |
OP_CONSULT_FIRST_TIME, OP_CONSULT_FIRST_DNA_RATE, OP_CONSULT_FIRST_DNA_TIME | FRM_APPOINTMENT_UTIL | OP_CONSULT_UTIL, OP_CONSULT_ANNUAL_OPERATIONAL_HOURS | FIRST_OUTPATIENT_CONSULT_ROOMS |
| ROOMS_OUTPATIENT_CONSULT | follow-up attendance | CLASS_OP_ATTEND, CLASS_OP_FACE_TO_FACE, CLASS_OP_FOLLOW_UP |
OP_CONSULT_FOLLOW_UP_TIME, OP_CONSULT_FOLLOW_UP_DNA_RATE, OP_CONSULT_FOLLOW_UP_DNA_TIME | FRM_APPOINTMENT_UTIL | OP_CONSULT_UTIL, OP_CONSULT_ANNUAL_OPERATIONAL_HOURS | FOLLOW_UP_OUTPATIENT_CONSULT_ROOMS |
| ROOMS_OUTPATIENT_VIRTUAL_CONSULT | All groups | CLASS_OP_ATTEND, CLASS_OP_VIRTUAL | OP_VIRTUAL_CONSULT_TIME, OP_VIRTUAL_CONSULT_DNA_RATE, OP_VIRTUAL_CONSULT_DNA_TIME | FRM_APPOINTMENT_UTIL | OP_VIRTUAL_CONSULT_UTIL, OP_VIRTUAL_CONSULT_ANNUAL_OPERATIONAL_HOURS | OUTPATIENT_VIRTUAL_CONSULT_ROOMS |
| ROOMS_OUTPATIENT_PROC | All groups | CLASS_OP_ATTEND, CLASS_HAS_PROCEDURE | OP_PROC_TIME, OP_PROC_DNA_RATE, OP_PROC_DNA_TIME | FRM_APPOINTMENT_UTIL | OP_PROC_UTIL, OP_PROC_ANNUAL_OPERATIONAL_HOURS | OUTPATIENT_PROC_ROOMS |
| SPACES_HAEM_ONC_TRT | All groups | CLASS_DAYCASE, CLASS_HAEM_ONC, CLASS_HAS_PROCEDURE | HAEM_ONC_TRT_TIME | FRM_TIME_UTIL | HAEM_ONC_TRT_UTIL, HAEM_ONC_ANNUAL_OPERATIONAL_HOURS | HAEM_ONC_TRT_SPACES |
| BEDS_INPATIENT_ASSESSMENT | Adult | CLASS_AGE_ADULT, CLASS_NON_ELECTIVE, MAP_MEDICAL, MAP_SURGICAL | INPATIENT_ASSESSMENT_ADULT_NON_ELECTIVE_MEDICAL_LOS, INPATIENT_ASSESSMENT_ADULT_NON_ELECTIVE_SURGICAL_LOS | FRM_BED_OCCUPANCY | INPATIENT_ASSESSMENT_ADULT_OCC, INPATIENT_ASSESSMENT_ANNUAL_OPERATIONAL_DAYS | ADULT_INPATIENT_ASSESSMENT_BEDS |
| BEDS_INPATIENT_ASSESSMENT | Paediatric | CLASS_AGE_PAED, CLASS_NON_ELECTIVE, MAP_MEDICAL, MAP_SURGICAL | INPATIENT_ASSESSMENT_PAED_NON_ELECTIVE_MEDICAL_LOS, INPATIENT_ASSESSMENT_PAED_NON_ELECTIVE_SURGICAL_LOS | FRM_BED_OCCUPANCY | INPATIENT_ASSESSMENT_PAED_OCC, INPATIENT_ASSESSMENT_ANNUAL_OPERATIONAL_DAYS | PAEDIATRIC_INPATIENT_ASSESSMENT_BEDS |
| BEDS_INPATIENT_WARD | adult elective medical | CLASS_AGE_ADULT, CLASS_ELECTIVE, MAP_MEDICAL | WARD_ADULT_ELECTIVE_MEDICAL_ZERO_DAY_LOS | FRM_BED_OCCUPANCY | WARD_ADULT_ELECTIVE_OCC, WARD_ANNUAL_OPERATIONAL_DAYS | ADULT_ELECTIVE_INPATIENT_WARD_BEDS |
| BEDS_INPATIENT_WARD | adult elective surgical | CLASS_AGE_ADULT, CLASS_ELECTIVE, MAP_SURGICAL | WARD_ADULT_ELECTIVE_SURGICAL_ZERO_DAY_LOS | FRM_BED_OCCUPANCY | WARD_ADULT_ELECTIVE_OCC, WARD_ANNUAL_OPERATIONAL_DAYS | ADULT_ELECTIVE_INPATIENT_WARD_BEDS |
| BEDS_INPATIENT_WARD | adult non-elective medical | CLASS_AGE_ADULT, CLASS_NON_ELECTIVE, MAP_MEDICAL | WARD_ADULT_NONELECTIVE_MEDICAL_ZERO_DAY_LOS | FRM_BED_OCCUPANCY | WARD_ADULT_NONELECTIVE_OCC, WARD_ANNUAL_OPERATIONAL_DAYS | ADULT_NON_ELECTIVE_INPATIENT_WARD_BEDS |
| BEDS_INPATIENT_WARD | adult non-elective surgical | CLASS_AGE_ADULT, CLASS_NON_ELECTIVE, MAP_SURGICAL | WARD_ADULT_NONELECTIVE_SURGICAL_ZERO_DAY_LOS | FRM_BED_OCCUPANCY | WARD_ADULT_NONELECTIVE_OCC, WARD_ANNUAL_OPERATIONAL_DAYS | ADULT_NON_ELECTIVE_INPATIENT_WARD_BEDS |
| BEDS_INPATIENT_WARD | paediatric elective medical | CLASS_AGE_CHILD, CLASS_ELECTIVE, MAP_MEDICAL | WARD_PAED_ELECTIVE_MEDICAL_ZERO_DAY_LOS | FRM_BED_OCCUPANCY | WARD_PAED_OCC, WARD_ANNUAL_OPERATIONAL_DAYS | PAEDIATRIC_INPATIENT_WARD_BEDS |
| BEDS_INPATIENT_WARD | paediatric elective surgical | CLASS_AGE_CHILD, CLASS_ELECTIVE, MAP_SURGICAL | WARD_PAED_ELECTIVE_SURGICAL_ZERO_DAY_LOS | FRM_BED_OCCUPANCY | WARD_PAED_OCC, WARD_ANNUAL_OPERATIONAL_DAYS | PAEDIATRIC_INPATIENT_WARD_BEDS |
| BEDS_INPATIENT_WARD | paediatric non-elective medical | CLASS_AGE_CHILD, CLASS_NON_ELECTIVE, MAP_MEDICAL | WARD_PAED_NONELECTIVE_MEDICAL_ZERO_DAY_LOS | FRM_BED_OCCUPANCY | WARD_PAED_OCC, WARD_ANNUAL_OPERATIONAL_DAYS | PAEDIATRIC_INPATIENT_WARD_BEDS |
| BEDS_INPATIENT_WARD | paediatric non-elective surgical | CLASS_AGE_CHILD, CLASS_NON_ELECTIVE, MAP_SURGICAL | WARD_PAED_NONELECTIVE_SURGICAL_ZERO_DAY_LOS | FRM_BED_OCCUPANCY | WARD_PAED_OCC, WARD_ANNUAL_OPERATIONAL_DAYS | PAEDIATRIC_INPATIENT_WARD_BEDS |
| BEDS_MATERNITY_ASSESSMENT | all groups | CLASS_MATERNITY, CLASS_ZERO_DAY, CLASS_NO_BIRTH_EVENT | MATERNITY_ASSESSMENT_ZERO_DAY_LOS | FRM_RECOVERY_OCCUPANCY | MATERNITY_ASSESSMENT_OCC, MATERNITY_ASSESSMENT_ANNUAL_OPERATIONAL_HOURS | MATERNITY_ASSESSMENT_BEDS |
| BEDS_MATERNITY_WARD_BIRTH | normal delivery | CLASS_MATERNITY, CLASS_BIRTH_NORMAL | MATERNITY_NORMAL_DELIVERY_ZERO_DAY_LOS | FRM_BED_OCCUPANCY | MATERNITY_BIRTH_WARD_OCC, MATERNITY_BIRTH_WARD_ANNUAL_OPERATIONAL_DAYS | NORMAL_DELIVERY_MATERNITY_WARD_BEDS |
| BEDS_MATERNITY_WARD_BIRTH | assisted delivery | CLASS_MATERNITY, CLASS_BIRTH_ASSISTED | MATERNITY_ASSISTED_DELIVERY_ZERO_DAY_LOS | FRM_BED_OCCUPANCY | MATERNITY_BIRTH_WARD_OCC, MATERNITY_BIRTH_WARD_ANNUAL_OPERATIONAL_DAYS | ASSISTED_DELIVERY_MATERNITY_WARD_BEDS |
| BEDS_MATERNITY_WARD_BIRTH | elective C-section | CLASS_MATERNITY, CLASS_BIRTH_ELECTIVE_CSECTION | MATERNITY_ELECTIVE_CSECTION_ZERO_DAY_LOS | FRM_BED_OCCUPANCY | MATERNITY_BIRTH_WARD_OCC, MATERNITY_BIRTH_WARD_ANNUAL_OPERATIONAL_DAYS | ELECTIVE_C_SECTION_MATERNITY_WARD_BEDS |
| BEDS_MATERNITY_WARD_BIRTH | non-elective C-section | CLASS_MATERNITY, CLASS_BIRTH_NONELECTIVE_CSECTION | MATERNITY_NONELECTIVE_CSECTION_ZERO_DAY_LOS | FRM_BED_OCCUPANCY | MATERNITY_BIRTH_WARD_OCC, MATERNITY_BIRTH_WARD_ANNUAL_OPERATIONAL_DAYS | NON_ELECTIVE_C_SECTION_MATERNITY_WARD_BEDS |
| BEDS_MATERNITY_WARD_NO_BIRTH | all groups | CLASS_MATERNITY, CLASS_NO_BIRTH_EVENT, CLASS_NON_ZERO_LOS | none | FRM_BED_OCCUPANCY | MATERNITY_WARD_NO_BIRTH_OCC, MATERNITY_WARD_NO_BIRTH_ANNUAL_OPERATIONAL_DAYS | MATERNITY_WARD_NO_BIRTH_BEDS |
| ROOMS_MATERNITY_BIRTH | normal delivery | CLASS_MATERNITY, CLASS_BIRTH_NORMAL | MATERNITY_NORMAL_DELIVERY_BIRTH_ROOM_LOS | FRM_BED_OCCUPANCY | MATERNITY_BIRTH_ROOM_OCC, MATERNITY_BIRTH_ROOM_ANNUAL_OPERATIONAL_DAYS | NORMAL_DELIVERY_MATERNITY_BIRTH_ROOMS |
| ROOMS_MATERNITY_BIRTH | assisted delivery | CLASS_MATERNITY, CLASS_BIRTH_ASSISTED | MATERNITY_ASSISTED_DELIVERY_BIRTH_ROOM_LOS | FRM_BED_OCCUPANCY | MATERNITY_BIRTH_ROOM_OCC, MATERNITY_BIRTH_ROOM_ANNUAL_OPERATIONAL_DAYS | ASSISTED_DELIVERY_MATERNITY_BIRTH_ROOMS |
| ROOMS_MATERNITY_BIRTH | elective C-section | CLASS_MATERNITY, CLASS_BIRTH_ELECTIVE_CSECTION | MATERNITY_ELECTIVE_CSECTION_BIRTH_ROOM_LOS | FRM_BED_OCCUPANCY | MATERNITY_BIRTH_ROOM_OCC, MATERNITY_BIRTH_ROOM_ANNUAL_OPERATIONAL_DAYS | ELECTIVE_C_SECTION_MATERNITY_BIRTH_ROOMS |
| ROOMS_MATERNITY_BIRTH | non-elective C-section | CLASS_MATERNITY, CLASS_BIRTH_NONELECTIVE_CSECTION | MATERNITY_NONELECTIVE_CSECTION_BIRTH_ROOM_LOS | FRM_BED_OCCUPANCY | MATERNITY_BIRTH_ROOM_OCC, MATERNITY_BIRTH_ROOM_ANNUAL_OPERATIONAL_DAYS | NON_ELECTIVE_C_SECTION_MATERNITY_BIRTH_ROOMS |