View source for 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. '''
# 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: 
#* [[s_CCI_Categories table]]
#* '''[[s_CCI_Categories_Collection_Mode table]]'''
#* [[s_ICD10_Categories table]]
# 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]]
# [[Rolling out changes| Roll out the change]]

== Log ==
* 2023-04-27 - completed 

== Related articles == 
{{Related Articles}}

[[Category:CCI]]
[[Category:ICD10]]
[[Category:CCMDB.accdb]]