Managing surgical waiting lists through dynamic priority scoring - Datasets

A dataset containing the deidentified patient and clinical factor data used in the associated simulation study. The CSV file contains patient data used to inform arrival distributions and historical summary statistics for model calibration, covering an eight-month in 2019. The JSON file contains clinical factor weights for each general surgery procedure included in the study with associated clinical factor sub-levels. The DOCX file contains supplementary material used in conjunction with the clinical factor selection forms for each procedure to provide examples of considerations that may be used for certain clinical criteria.

Data-specific information for: patientData.csv
Patient data used to inform arrival distributions and historical summary statistics for model calibration, covering 8 months in 2019.

Number of columns: 17

Number of rows: 846

Column headings:
INDEX = numerical index

ID = assigned patient ID for purposes of this study

HISTORICAL_ASSIGNED_CATEGORY = the urgency category the patient was historically treated under

HISTORICAL_PLACED_ON_LIST_DATE_EPOCH = the number of days from an epoch a patient was placed on the list historically

HISTORICAL_OPERATION_DATE_EPOCH = the number of days from an epoch of a patient was admitted to surgery historically

DAYS_WAITING = the difference between HISTORICAL_PLACED_ON_LIST_DATE_EPOCH and HISTORICAL_OPERATION_DATE_EPOCH in days

PROCEDURE = the surgical procedure for which the patient was historically placed on the waiting list

OR_TIME = the total operating theatre duration in minutes (sum of PROCEDURE_TIME and CHANGEOVER_TIME)

PROCEDURE_TIME = the duration of the respective procedure in minutes

CHANGEOVER_TIME = the duration of the required changeover in minutes

C1 = clinical factor score 1 weight for the respective procedure and sub-level (from clinicalFactorWeights.json)

C2 = clinical factor score 2 weight for the respective procedure and sub-level (from clinicalFactorWeights.json)

C3 = clinical factor score 3 weight for the respective procedure and sub-level (from clinicalFactorWeights.json)

C4 = clinical factor score 4 weight for the respective procedure and sub-level (from clinicalFactorWeights.json)

C5 = clinical factor score 5 weight for the respective procedure and sub-level (from clinicalFactorWeights.json)

FACTORS_SUM = the sum of C1..C5

ASSIGNED_CATEGORY = the revised urgency category assigned to the patient upon clinician review of case files when collecting clinical factor data

Data-specific information for: clinicalFactorWeights.json
Clinical factor weights for each procedure and associated clinical factor sub-levels.

Number of variables: 10

General form of data structure:
CX = clinical factor X

CX_LY = clinical factor X level Y

CX_LY_weight = weight of clinical factor X level Y

{

  "Procedure 1": {

    "C1": {

      "C1_L1": "C1_L1_weight",

      "C1_L2": "C1_L2_weight",

      "C1_L3": "C1_L3_weight"

    },

    "C2": {

      "C2_L1": "C2_L1_weight",

      "C2_L2": "C2_L2_weight",

      "C2_L3": "C2_L3_weight"

    },

    "C3": {

      "C3_L1": "C3_L1_weight",

      "C3_L2": "C3_L2_weight",

      "C3_L3": "C3_L3_weight"

    },

    "C4": {

      "C4_L1": "C4_L1_weight",

      "C4_L2": "C4_L2_weight",

      "C4_L3": "C4_L3_weight"

    },

    "C5": {

      "C5_L1": "C5_L1_weight",

      "C5_L2": "C5_L2_weight",

      "C5_L3": "C5_L3_weight"

    }

  }

}

Data-specific information for: Clinical Factor Selection Form Supplementary Information and Definitions.docx
Supplementary material is provided to be used in conjunction with the clinical factor selection forms for each procedure, to provide examples of considerations that may be used for specific clinical criteria.