Include DailyMed in all_ndc_descriptions mart

[jrlegrand]

Problem Statement

As of writing this, there are 8626 extra NDCs in DailyMed. UPDATE: there are 5600-ish not-NULL NDCs... but I spot checked a couple and the NULL NDCs actually appear to have NDCs in DailyMed. So part of this might be figuring out why the NULLs are NULL too.

Extra NDCs as of writing: extra_dailymed_ndcs.csv

Criteria for Success

There are 8k+ extra NDCs in all_ndc_descriptions.

Wherever possible, we use RxNorm relationships to map to RxNorm descriptions (this is available already as a data source).

If no RxNorm name exists, we need to create a DailyMed name - similar to how we do for FDA NDC Directory.

Additional Information

Run this query to see how many NDCs are currently additional in DailyMed:

select * from
sagerx_dev.stg_dailymed__ndcs dm
left join sagerx_dev.all_ndc_descriptions ndc
	on ndc.ndc = dm.ndc11
where ndc.ndc is null