Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb

Our ICD10 diagnosis codes are all in one or more ICD10 Categories. Our CCI Procedure codes are all in one or more CCI Categories. These CCI Categories are also used to tell CCMDB.accdb which CCI Collection Mode to use for a procedure. The wiki is the single point of truth for this information, but when it is changed on the wiki it needs to be manually imported into CCMBD. The process for that is as follows.

Instructions

This process takes about 15 minutes if all goes right.

1. open CCI Categories for CCMDB.accdb and ICD10 Categories for CCMDB.accdb
2. in each, select all codes (it's a long list, and the easiest way to do it is to highlight the first part of the first code, scroll to the bottom, and shift-click on the end of the last code to select)
3. copy the codes
4. paste each set of codes into a separate text file and name them, e.g. cci.txt and icd.txt
   • delete the duplicate x3x3 code from the CCI list
5. open CCMDB.accdb
6. open and delete all records from the three tables:
   • s_CCI_Categories table
   • s_CCI_Categories_Collection_Mode table
   • s_ICD10_Categories table
7. click "External Data" at the top, then "New Data Source", "From file", "Text file"
8. browse to the file you made above, e.g. cci.txt
9. click the "append a copy of the records to table" radio button and select the table; use table s_CCI_Categories resp. s_ICD10_Categories
10. Click next twice (the first correctly defaults to "delimited", the second correctly defaults to "semicolon")
11. click finish
12. repeat from "click external data" for the other file and table
13. double-click query s_CCI_Categories_Collection_Mode_Maker to populate s_CCI_Categories_Collection_Mode table; this had to be a table rather than a query because using a query would have made records in the CCI subforms not editable
14. update s_CCI_Categories_sort table
    • run query s_CCI_Categories_sort_missing; if there is any content, paste it into s_CCI_Categories_sort table and assign sorting numbers
15. update info in scoring tables
    • refresh APACHE Comorbidities in ICD10 codes with content from from column "wikiline" of the S ICD10_APACHE_Comorbids query
    • refresh APACHE Acute Dxs in ICD10 codes with content from from column "wikiline" of the s_ICD10_APACHE_Dx query
    • refresh Charlson Comorbidities in ICD10 codes with content from from column "wikiline" of the s_ICD10_Charlson_Comorbids query
16. Roll out the change

Log

• 2023-04-27 - completed