Update of NDC
Prerequisites:
- Schema DevV5 with copies of tables concept, concept_relationship and concept_synonym from ProdV5, fully indexed.
- RxNorm must be loaded first
- Working directory NDC.
- Create package ApiGrabber using \working\packages\APIgrabber
- Run create_source_tables.sql
- Download NDC code distrbution file Open the site http://www.fda.gov/Drugs/InformationOnDrugs/ucm142438.htm
- Download the latest NDC Database File.
- Extract the product.txt file.
- Load product.txt into PRODUCT using control file of the same name
- Download additional source for SPL concepts and relationships from http://dailymed.nlm.nih.gov/dailymed/spl-resources-all-drug-labels.cfm and http://dailymed.nlm.nih.gov/dailymed/spl-resources-all-mapping-files.cfm
- Full Releases of HUMAN PRESCRIPTION LABELS, HUMAN OTC LABELS, HOMEOPATHIC LABELS and REMAINDER LABELS (1st link)
- SPL-RXNORM MAPPINGS (2d link)
- Extract LABELS using unzipxml.sh and load xml files using loadxml.ctl
- Extract rxnorm_mappings.zip and load rxnorm_mappings.txt using rxnorm_mappings.ctl
- Run parse_XML.sql
- Run load_stage.sql (with updated pVocabularyDate = latest update of vocabulary)
- Run generic_update.sql (from working directory)