This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Last revision Both sides next revision | ||
documentation:vocabulary_etl [2016/01/21 10:08] hardhouse |
documentation:vocabulary_etl [2016/03/29 12:49] 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 === |