FDA Orange Book data contains a column for strength, but it is formatted so differently from the strength columns available in other FDA data (i.e. NDC catalog). Therapeutic equivalency codes (TE codes) from Orange Book are at the dose form-route-strength level yet without a map between the strengths in Orange Book and FDA NDC catalog, I'm finding it impossible to know that a given NDC has a given TE code. The closest you could get would be to say that a given Application Number (i.e. ANDA012345) has products with 1 to n TE codes.
Mapping the strengths between the two data sources seems tedious and error prone; however, Orange Book data also contains a "Product Number" (i.e. 001, 002, 003) field that - if included at the product NDC level in other FDA NDC data sources - could be a reliable map between the two sources.
Can this be added, or is there another way to accomplish this?