m4_prescriptions: Access prescribed medications

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 prescriptions table containing data about prescribed medications. Information includes the name of the drug, coded identifiers including the Generic Sequence Number (GSN) and National Drug Code (NDC), the product strength, the formulary dose, and the route of administration.

Usage

m4_prescriptions(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 prescriptions table:

(PKEY pharmacy_id)

(FKEY subject_id) -> patients table

(FKEY hadm_id) -> admissions table

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

script <- m4_prescriptions(con, cohort = 10177976)
dim(script)

bigrquery::dbDisconnect(con)

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