m4_emar: Access Electronic Medicine Administration Records (eMAR)

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

Description

This functions provides base access to the emar table from the hospital module. These data are collected by barcode scanning of medications at the time of administration.

Usage

m4_emar(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 table:

(PKEY emar_id, emar_seq)

(FKEY subject_id) -> patients table

(FKEY hadm_id) -> admissions table

(FKEY emar_id, emar_seq) -> emar_detail table

(FKEY pharmacy_id) -> pharmacy table

(FKEY pharmacy_id) -> prescriptions table

(FKEY poe_id) -> poe 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
)

emar <- m4_emar(con, cohort = 10137012)
dim(emar)

bigrquery::dbDisconnect(con)

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