ICD10CN upload/update

Prerequisites

• Basic knowledge of the OMOP representation of the ICD10 vocabulary
• Schema DevV5 with copies of tables concept, concept_relationship and concept_synonym from ProdV5, fully indexed.
• SNOMED and ICD10 must be loaded first
• Working directory dev_icd10cn

Sequence of actions

1. Download the latest ICD-10-CN version here
2. Unzip CONCEPT.csv, CONCEPT_RELATIONSHIP.csv (password required) and rename to icd10cn_concept.csv (we use modified version of this file) and icd10cn_concept_relationship.csv
3. Run create_source_tables.sql
4. Run in devv5 (with fresh vocabulary date and version):

SELECT sources.load_input_tables('ICD10CN',TO_DATE('20160101','YYYYMMDD'),'2016 Release');

5. Run the FastRecreate:

SELECT devv5.FastRecreateSchema('dev_icd10'); 

6. Run load_stage.sql
7. Run generic_update:

SELECT devv5.GenericUpdate();

8. Run manual_checks_after_generic.sql