Created a staging table to represent all RxNorm products.
Created a mart for product-level information - potentially useful for many applications in the future.
Created a specific mart for Brand Product RXCUI → Related Clinical Product RXCUI → NDCs related to that Clinical Product RXCUI → FDA Start Marketing Dates.
Rationale
Two marts requested by customer.
Product mart could be used generally for other things.
Fixes #278
Explanation
Created a staging table to represent all RxNorm products. Created a mart for product-level information - potentially useful for many applications in the future. Created a specific mart for Brand Product RXCUI → Related Clinical Product RXCUI → NDCs related to that Clinical Product RXCUI → FDA Start Marketing Dates.
Rationale
Two marts requested by customer.
Product mart could be used generally for other things.
Additional Info
See documentation here
brand_products_with_related_ndcs https://dbt.sagerx.io/#!/model/model.sagerx.brand_products_with_related_ndcs
products https://dbt.sagerx.io/#!/model/model.sagerx.products