coderxio / sagerx

Open drug data pipelines curated by pharmacists.

https://coderx.io/sagerx

Other

45 stars 12 forks source link

New marts - Product RXCUI information + Related Generic NDCs for Brand Product RXCUIs #278

Closed jrlegrand closed 4 months ago

jrlegrand commented 5 months ago

Problem Statement

Two new marts to be generated and exported to s3.

Criteria for Success

Product-level RXCUI information - could be useful in general as a product-level data source

Product-level RXCUI
Product-level RxNorm description
SCD / GPCK = generic
SBD / BPCK = brand
Brand Name (if exists)
Ingredient Name
Strength
Dose Form

Related Generic NDCs for Brand Product RXCUIs

Brand Product RXCUI → Related Clinical Product RXCUI → NDCs related to that Clinical Product RXCUI → FDA Start Marketing Dates

Additional Information

NOTE: this is a starting point - not comprehensive definition of brand vs generic