nemsqar (version 1.0.0)

respiratory_02: Respiratory-02 Calculation

Description

The respiratory_02 function calculates metrics for pediatric and adult respiratory populations based on pre-defined criteria, such as low oxygen saturation and specific medication or procedure codes. It returns a summary table of the overall, pediatric, and adult populations, showing counts and proportions.

Usage

respiratory_02(
  df = NULL,
  patient_scene_table = NULL,
  response_table = NULL,
  vitals_table = NULL,
  medications_table = NULL,
  procedures_table = NULL,
  erecord_01_col,
  incident_date_col = NULL,
  patient_DOB_col = NULL,
  epatient_15_col,
  epatient_16_col,
  eresponse_05_col,
  evitals_12_col,
  emedications_03_col,
  eprocedures_03_col,
  ...
)

Value

A tibble summarizing results for the Adults, Peds, and all records with the following columns:

measure: The name of the measure being calculated. pop: Population type (Adults, Peds, All). numerator: Count of EMS responses originating from a 911 request for patients with hypoxia during which oxygen is administered. denominator: Total count of incidents. prop: Proportion of EMS responses originating from a 911 request for patients with hypoxia during which oxygen is administered. prop_label: Proportion formatted as a percentage with a specified number of decimal places.

Arguments

df

A data frame containing incident data with each row representing an observation.

patient_scene_table

A data.frame or tibble containing at least epatient and escene fields as a fact table.

response_table

A data.frame or tibble containing at least the eresponse fields needed for this measure's calculations.

vitals_table

A data.frame or tibble containing at least the evitals fields needed for this measure's calculations.

medications_table

A data.frame or tibble containing only the emedications fields needed for this measure's calculations.

procedures_table

A data.frame or tibble containing only the eprocedures fields needed for this measure's calculations.

erecord_01_col

Column name for eRecord.01, used to form a unique patient ID.

incident_date_col

Column that contains the incident date. This defaults to NULL as it is optional in case not available due to PII restrictions.

patient_DOB_col

Column that contains the patient's date of birth. This defaults to NULL as it is optional in case not available due to PII restrictions.

epatient_15_col

integer Column giving the calculated age value.

epatient_16_col

Column giving the provided age unit value.

eresponse_05_col

Column name for response codes (e.g., incident type).

evitals_12_col

Column name for oxygen saturation (SpO2) values.

emedications_03_col

Column name for medication codes.

eprocedures_03_col

Column name for procedure codes.

...

arguments passed to dplyr::summarize().

Author

Nicolas Foss, Ed.D., MS

Examples

# Synthetic test data
  test_data <- tibble::tibble(
    erecord_01 = c("R1", "R2", "R3", "R4", "R5"),
    epatient_15 = c(34, 5, 45, 2, 60),  # Ages
    epatient_16 = c("Years", "Years", "Years", "Months", "Years"),
    eresponse_05 = rep(2205001, 5),
    emedications_03 = c("Oxygen", "Oxygen", "Oxygen", "Oxygen", "Oxygen"),
    evitals_12 = c(60, 59, 58, 57, 56),
    eprocedures_03 = rep("applicable thing", 5)
  )

  # Run the function
  respiratory_02(
    df = test_data,
    erecord_01_col = erecord_01,
    epatient_15_col = epatient_15,
    epatient_16_col = epatient_16,
    eresponse_05_col = eresponse_05,
    emedications_03_col = emedications_03,
    evitals_12_col = evitals_12,
    eprocedures_03_col = eprocedures_03
  )