NDC to package size + inner NDCs
Description
This is a mart that maps from NDC to total package size. For example, if an NDC represents a carton that contains 10 syringes that each have 0.5 mL in them, the total package size would be 5 mL (1 carton x 10 syringes x 0.5 mL = 5 mL).
In the process of building this mart, we will likely capture data for inner / outer NDCs. For example, if each of those syringes has an NDC, we can consider those “inner” NDCs and associate them with the “outer” carton NDC which is the thing that pharmacies actually purchase.
Source data
Options for source data for this:
- DailyMed
- Use XML Templates to get packaging details. Most comprehensive, but most gnarly way to do this.
- FDA NDC Directory
- Use the
packagedescription
column and RegEx important parts out of it. I already have a branch started to do this. - Not sure the coverage of FDA NDC vs DailyMed SPLs.
- DailyMed API
- The DailyMed API has structured package information, but I remember it missing some piece of the puzzle. Maybe Part numbers? Seemed like a bug to me.
Table info
ndc_to_package_size
ndc_to_inner_ndcs