Process the RxNorm Validity Table — process_rxnorm_validity

Retrieve and cache concept batches by its validity status from the RxNav REST API and write a table that maps an input RxCUI or RxNorm code to its most current RxCUI or RxNorm code.

process_rxnorm_validity_status(
  conn,
  conn_fun = "pg13::local_connect(verbose = {verbose})",
  processing_schema = "process_rxnorm_validity_status",
  destination_schema = "rxtra",
  rm_processing_schema = TRUE,
  checks = "",
  verbose = TRUE,
  render_sql = TRUE,
  render_only = FALSE,
  prior_version = NULL,
  prior_api_version = "3.1.174"
)

Details

Default Schema: rxtra

Time Requirement: Approximately 30 minutes to an hour

Resource Requirements:

RxNorm schema
RxNorm API