User Tools

Site Tools


documentation:vocabulary_etl

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
documentation:vocabulary_etl [2016/01/21 10:08]
hardhouse
documentation:vocabulary_etl [2016/03/29 12:49] (current)
hardhouse add ICD10CM
Line 71: Line 71:
 | HCPCS| CMS website | http://​www.cms.gov/​Medicare/​Coding/​HCPCSReleaseCodeSets/​Alpha-Numeric-HCPCS.html | https://​www.cms.gov/​Medicare/​Coding/​HCPCSReleaseCodeSets/​Downloads/​2016-Alpha-Numeric-HCPCS-File.zip | | HCPCS| CMS website | http://​www.cms.gov/​Medicare/​Coding/​HCPCSReleaseCodeSets/​Alpha-Numeric-HCPCS.html | https://​www.cms.gov/​Medicare/​Coding/​HCPCSReleaseCodeSets/​Downloads/​2016-Alpha-Numeric-HCPCS-File.zip |
 | ICD9CM and ICD9Proc | CMS website | http://​www.cms.gov/​Medicare/​Coding/​ICD9ProviderDiagnosticCodes/​codes.html| http://​www.cms.gov/​Medicare/​Coding/​ICD9ProviderDiagnosticCodes/​Downloads/​ICD-9-CM-v32-master-descriptions.zip | | ICD9CM and ICD9Proc | CMS website | http://​www.cms.gov/​Medicare/​Coding/​ICD9ProviderDiagnosticCodes/​codes.html| http://​www.cms.gov/​Medicare/​Coding/​ICD9ProviderDiagnosticCodes/​Downloads/​ICD-9-CM-v32-master-descriptions.zip |
 +| ICD10CM | CDC website | http://​www.cdc.gov/​nchs/​icd/​icd10cm.htm | ftp://​ftp.cdc.gov/​pub/​Health_Statistics/​NCHS/​Publications/​ICD10CM/​20xx/​ICD10CM_FY20xx_code_descriptions.zip |
 | LOINC| LOIC website | https://​loinc.org/​downloads/​files/​loinc-table-csv-text-format| http://​loinc.org/​downloads/​files/​loinc-table-csv-text-format/​loinc-table-file-csv-text-format/​download | | LOINC| LOIC website | https://​loinc.org/​downloads/​files/​loinc-table-csv-text-format| http://​loinc.org/​downloads/​files/​loinc-table-csv-text-format/​loinc-table-file-csv-text-format/​download |
 | LOINC| LOIC website | https://​loinc.org/​downloads/​files/​loinc-multiaxial-hierarchy| http://​loinc.org/​downloads/​files/​loinc-multiaxial-hierarchy/​loinc-multiaxial-hierarchy-file/​download | | LOINC| LOIC website | https://​loinc.org/​downloads/​files/​loinc-multiaxial-hierarchy| http://​loinc.org/​downloads/​files/​loinc-multiaxial-hierarchy/​loinc-multiaxial-hierarchy-file/​download |
Line 104: Line 105:
   * ICD10   * ICD10
   * ICD9CM   * ICD9CM
 +  * ICD10CM
   * ICD9Proc   * ICD9Proc
   * LOINC   * LOINC
Line 616: Line 618:
   - Run load_stage.sql   - Run load_stage.sql
   - Run generic_update.sql (from working directory)   - Run generic_update.sql (from working directory)
- 
  
 ==== Step 16 ==== ==== Step 16 ====
Line 631: Line 632:
   - Run load_stage.sql   - Run load_stage.sql
   - Run generic_update.sql (from working directory)   - Run generic_update.sql (from working directory)
 +
 +
 +
  
 ==== Step 17 ==== ==== Step 17 ====
 +
 +=== Overview ===
 +
 +Download the ICD10CM datasets. Decompress the gzipped files. Run the ETL script to create the staging tables schema and load the datasets. ​
 +
 +=== Details ===
 +
 +  - Run create_source_tables.sql
 +  - Download ftp://​ftp.cdc.gov/​pub/​Health_Statistics/​NCHS/​Publications/​ICD10CM/​20xx/​ICD10CM_FY20xx_code_descriptions.zip
 +  - Extract icd10cm_order_20xx.txt and rename to icd10cm.txt
 +  - Load into icd10cm_table with icd10cm.ctl
 +  - Unzip icd10cm2snomed.zip and load into icd10cm2snomed with icd10cm2snomed.ctl
 +  - Run load_stage.sql
 +  - Run generic_update.sql (from working directory)
 +
 + 
 +==== Step 18 ====
  
 === Overview === === Overview ===
Line 643: Line 664:
   - Run drug_strength.sql   - Run drug_strength.sql
  
-==== Step 18 ====+==== Step 19 ====
  
 === Overview === === Overview ===
Line 656: Line 677:
   - Run manual_changes_15-Mar-2015.sql ​   - Run manual_changes_15-Mar-2015.sql ​
  
-==== Step 19 ====+==== Step 20 ====
  
 === Overview === === Overview ===
documentation/vocabulary_etl.txt ยท Last modified: 2016/03/29 12:49 by hardhouse