m4_emar_detail: Access supplementary information for electronic...

In hdshea/MIMIC4db: Package for building, loading and referencing the Google BigQuery verion of the MIMIC-IV

Description

This function provides base access to the emar_detail table containing data for each medicine administration made in the EMAR table. Information includes the associated pharmacy order, the dose due, the dose given, and many other parameters associated with the medical administration.

Usage

m4_emar_detail(con, cohort = NULL, ...)

Arguments

con	A bigrquery::bigquery() DBIConnection object, as returned by DBI::dbConnect() with an appropriate bigrquery::bigquery() DBI driver specified in the call.
cohort	an optional vector of patient IDs defining the cohort of interest
...	additional optional passed along parameters.

Details

Table attributes for emar_detail table:

(PKEY emar_id, emar_seq, parent_field_ordinal)

(FKEY subject_id) -> patients table

(FKEY emar_id, emar_seq) -> emar table

(FKEY pharmacy_id) -> pharmacy table

(FKEY pharmacy_id) -> prescriptions table

Value

a tibble with the results.

Examples

# To run examples, you must have the BIGQUERY_TEST_PROJECT environment
# variable set to name of project which has billing set up and to which
# you have write access.
con <- bigrquery::dbConnect(
  bigrquery::bigquery(),
  project = bigrquery::bq_test_project(),
  quiet = TRUE
)

edet <- m4_emar_detail(con, cohort = 10137012)
dim(edet)

bigrquery::dbDisconnect(con)

hdshea/MIMIC4db documentation built on Dec. 20, 2021, 3:45 p.m.