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 |
| SPACES_SDEC | all groups | ['CLASS_SDEC'] | ['SDEC_SPACES_LOS'] | FRM_FLOW_SPACE | ['SDEC_SPACES_UTIL', 'SDEC_SPACES_ANNUAL_OPERATIONAL_HOURS'] | SDEC_SPACES |
| ROOMS_OP_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_OP_CONSULT_ROOMS |
| ROOMS_OP_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_OP_CONSULT_ROOMS |
| ROOMS_OP_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'] | OP_VIRTUAL_CONSULT_ROOMS |
| ROOMS_OP_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'] | OP_PROC_ROOMS |
| BEDS_DAYCASE_RECOVERY | Adult medical | ['CLASS_DAYCASE', 'CLASS_AGE_ADULT', 'CLASS_MEDICAL'] | ['DAYCASE_RECOVERY_ADULT_MEDICAL_LOS'] | ['FRM_RECOVERY_OCCUPANCY'] | ['DAYCASE_RECOVERY_ADULT_MEDICAL_OCC', 'DAYCASE_RECOVERY_ANNUAL_OPERATIONAL_HOURS'] | ADULT_MEDICAL_DAYCASE_RECOVERY_BEDS |
| BEDS_DAYCASE_RECOVERY | Adult surgical | ['CLASS_DAYCASE', 'CLASS_AGE_ADULT', 'CLASS_SURGICAL'] | ['DAYCASE_RECOVERY_ADULT_SURGICAL_LOS'] | ['FRM_RECOVERY_OCCUPANCY'] | ['DAYCASE_RECOVERY_ADULT_SURGICAL_OCC', 'DAYCASE_RECOVERY_ANNUAL_OPERATIONAL_HOURS'] | ADULT_SURGICAL_DAYCASE_RECOVERY_BEDS |
| BEDS_DAYCASE_RECOVERY | Paediatric medical | ['CLASS_DAYCASE', 'CLASS_AGE_CHILD', 'CLASS_MEDICAL'] | ['DAYCASE_RECOVERY_PAEDIATRIC_MEDICAL_LOS'] | ['FRM_RECOVERY_OCCUPANCY'] | ['DAYCASE_RECOVERY_PAEDIATRIC_MEDICAL_OCC', 'DAYCASE_RECOVERY_ANNUAL_OPERATIONAL_HOURS'] | PAEDIATRIC_MEDICAL_DAYCASE_RECOVERY_BEDS |
| BEDS_DAYCASE_RECOVERY | Paediatric surgical | ['CLASS_DAYCASE', 'CLASS_AGE_CHILD', 'CLASS_SURGICAL'] | ['DAYCASE_RECOVERY_PAEDIATRIC_SURGICAL_LOS'] | ['FRM_RECOVERY_OCCUPANCY'] | ['DAYCASE_RECOVERY_PAEDIATRIC_SURGICAL_OCC', 'DAYCASE_RECOVERY_ANNUAL_OPERATIONAL_HOURS'] | PAEDIATRIC_SURGICAL_DAYCASE_RECOVERY_BEDS |
| BEDS_DAYCASE_ENDOSCOPY_RECOVERY | All groups | ['CLASS_DAYCASE', 'CLASS_ENDOSCOPY'] | ['DAYCASE_ENDOSCOPY_RECOVERY_LOS'] | ['FRM_RECOVERY_OCCUPANCY'] | ['DAYCASE_ENDOSCOPY_RECOVERY_OCC', 'DAYCASE_ENDOSCOPY_RECOVERY_ANNUAL_OPERATIONAL_HOURS'] | DAYCASE_ENDOSCOPY_RECOVERY_BEDS |
| ROOMS_ENDOSCOPY_PROC | All groups | ['CLASS_DAYCASE', 'CLASS_ENDOSCOPY'] | ['ENDOSCOPY_PROC_TIME'] | ['FRM_TIME_UTIL'] | ['ENDOSCOPY_PROC_UTIL', 'ENDOSCOPY_PROC_ANNUAL_OPERATIONAL_HOURS'] | ENDOSCOPY_PROC_ROOMS |
| 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'] | ['DAYCASE_RENAL_ANNUAL_SESSION_CAPACITY_PER_BED'] | DAYCASE_RENAL_BEDS |
| SPACES_HAEM_ONC_TRT | All groups | ['CLASS_DAYCASE', 'CLASS_HAEM_ONC', 'CLASS_HAS_PROCEDURE'] | ['HAEM_ONC_TREATMENT_TIME'] | ['FRM_TIME_UTIL'] | ['HAEM_ONC_TREATMENT_UTIL', 'HAEM_ONC_ANNUAL_OPERATIONAL_HOURS'] | HAEM_ONC_TRT_SPACES |
MOVE TO EXTERNAL YAML FILE AS FUN AREAS ARE COMPLETED
| Functional area | Subgroup | Classification IDs | Workload Assumptions | Formula ID | Operational Assumptions | Capacity Output |
|---|---|---|---|---|---|---|
| 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 |
| 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_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 |
| 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 |