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

[jrlegrand]

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