which duration column to use

[aylapear]

Tests table

• study_duration_unit
• exposure_duration_unit
  • This may be the most important because it is one of the core field to be picked

Results table

• obs_duration_unit

Currently using the obs_duration_unit

[aylapear]

Angeline said

• use study duration but if study duration = NC or NA then use observed duration.

[aylapear]

Updated compile function to do the switch and make a general duration column from the two before joining it to code description table:

 # add duration unit info
    # use study duration but if study duration is missing use observed duration
    dplyr::mutate(
      duration_mean = dplyr::if_else(
        !is.na(.data$study_duration_mean),
        .data$study_duration_mean,
        .data$obs_duration_mean
      ),
      duration_unit = dplyr::if_else(
        !is.na(.data$study_duration_mean),
        .data$study_duration_unit,
        .data$obs_duration_unit
      ),
      duration_unit = dplyr::if_else(
        !stringr::str_detect(.data$duration_mean, "NC"),
        .data$duration_unit,
        .data$obs_duration_unit
      ),
      duration_mean = dplyr::if_else(
        !stringr::str_detect(.data$duration_mean, "NC"),
        .data$duration_mean,
        .data$obs_duration_mean
      )
    ) |>
    dplyr::left_join(
      db_duration_unit_codes, by = c("duration_unit" = "code")
    ) |>