m4_pharmacy: Access formulary, dosing, and other information for...

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 pharmacy table containing data of detailed information regarding filled medications which were prescribed to the patient. Pharmacy information includes the dose of the drug, the number of formulary doses, the frequency of dosing, the medication route, and the duration of the prescription.

Usage

m4_pharmacy(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 pharmacy table:

(PKEY pharmacy_id)

(FKEY subject_id) -> patients table

(FKEY hadm_id) -> admissions table

(FKEY poe_id) -> poe table

(FKEY pharmacy_id) -> prescriptions table

(FKEY pharmacy_id) -> emar 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
)

evt <- m4_pharmacy(con, cohort = 10177976)
dim(evt)

bigrquery::dbDisconnect(con)

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