Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m (→Instructions: corrections for newer version of MS Access) |
||
| Line 15: | Line 15: | ||
#* '''[[s_CCI_Categories_Collection_Mode table]]''' | #* '''[[s_CCI_Categories_Collection_Mode table]]''' | ||
#* [[s_ICD10_Categories table]] | #* [[s_ICD10_Categories table]] | ||
# click "External Data" at the top, then "Text file" | # click "External Data" at the top, then "New Data Source", "From file", "Text file" | ||
# browse to the file you made above, e.g. cci.txt | # browse to the file you made above, e.g. cci.txt | ||
# click the "append a copy of the records to table" radio button and select the table; use table s_CCI_Categories | # 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 | ||
# Click next twice (the first correctly defaults to "delimited", the second correctly defaults to "semicolon") | # Click next twice (the first correctly defaults to "delimited", the second correctly defaults to "semicolon") | ||
# click finish | # click finish | ||
Revision as of 14:10, 2022 October 26
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.
- open CCI Categories for CCMDB.accdb and ICD10 Categories for CCMDB.accdb
- 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)
- copy the codes
- 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
- open CCMDB.accdb
- open and delete all records from the three tables:
- click "External Data" at the top, then "New Data Source", "From file", "Text file"
- browse to the file you made above, e.g. cci.txt
- 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
- Click next twice (the first correctly defaults to "delimited", the second correctly defaults to "semicolon")
- click finish
- repeat from "click external data" for the other file and table
- 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.
- 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
- Roll out the change