The CSV files downloaded from https://www.nlm.nih.gov/research/umls/rxnorm/docs/rxnormfiles.html are loaded into Postgres.

run_setup(
  conn,
  conn_fun = "pg13::local_connect()",
  schema = "rxnorm",
  rrf_path,
  rxrel_tables = c("rxnorm_to_brand_and_generic"),
  rxtra_tables = c("rxnorm_validity_status"),
  verbose = TRUE,
  render_sql = TRUE,
  render_only = FALSE,
  checks = c("conn_status", "conn_type"),
  log_schema = "public",
  log_table_name = "setup_rxnorm_log",
  log_release_date
)

Arguments

conn

Connection to a Postgres database.

schema

Target schema for the RxNorm load, Default: 'rxnorm'.

rrf_path

Path to the unpacked RxNorm files.

rxrel_tables

(Optional) Which RxRel schema tables to process for this run?

rxtra_tables

(Optional) Which RxTra schema tables to process for this run?

log_schema

Schema for the table that logs the process, Default: 'public'

log_table_name

Name of log table, Default: 'setup_rxnorm_log'

log_release_date

(Required) RxNorm Monthly Release Date.