Update of JMDC

Prerequisites:

• Schema DevV5 with copies of tables concept, concept_relationship and concept_synonym from ProdV5, fully indexed.

1. Run create_source_tables.sql and additional_DDL.sql
2. Upload the source file in the JMDC table
3. Run load_stage_1.sql. Before running the script, manually identify new packs and add them to aut_pc_stage table (ingredients,dose forms and dosages; brand names and suplliers if applicable)
4. Manually fill *_to_map tables and re-upload them as *_mapped.
5. Run load_stage_2.sql
6. Run build_RxE.sql and generic_update: devv5.GenericUpdate();