Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (→Instructions) |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 23: | Line 23: | ||
# 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 | # 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 [[s_CCI_Categories_sort table]] | # update [[s_CCI_Categories_sort table]] | ||
#* run [[s_CCI_Categories_sort_missing]]; if there is any content, paste it into [[s_CCI_Categories_sort table]] and assign sorting numbers | #* run [[query s_CCI_Categories_sort_missing]]; if there is any content, paste it into [[s_CCI_Categories_sort table]] and assign sorting numbers | ||
# update info in scoring tables | # 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 Comorbidities in ICD10 codes]] with content from from column "wikiline" of the [[S ICD10_APACHE_Comorbids query]] | ||
Revision as of 10:33, 2023 April 27
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 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
- 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