Translation of Dx Data from CCMDB schema to ICD10/CCI

From CCMDB Wiki
Revision as of 12:26, 5 March 2018 by Ttenbergen (talk | contribs) (→ICD10)
Jump to navigation Jump to search

This page explains how we will translate old dx code entries to the new ICD10/CCI model as part of Category:ICD10 Data Conversion.

ICD10

The translation mapping for the ICD10 side is stored in the s_ICD10_AllDiagnoses_translation table. Data in the L_Dxs table is mapped from this using the sz_dx_to_ICD10 query.

The translation will be done using a modified copy (fork) of CFE called CFE_ICD10_CCI_mapping.accdb can be found in X:ccmdb\ICD10/CCI_Mapping.

Template:Discussion Emailed Julie link to this wiki page so she can start testing the translation. Julie, please have a look at the output of the sz_dx_to_ICD10 query.Ttenbergen 12:26, 2018 March 5 (CST)

Template:Discussion Currently confirming that none of the codes in ICD10 after original import will affect this. Proceeding with check of translation because we can always tweak the query, and there will likely be other issues found. Ttenbergen 12:26, 2018 March 5 (CST)

background

Excel workbook from Allan Garland, used by Tina, can be found on X:ccmdb\ICD10/CCI_Mapping\archive. This is no longer the master version, see s_ICD10_AllDiagnoses_translation table.

CCI

Template:Discussion We don't have a translation mapping for CCI yet. Ttenbergen 11:47, 2018 March 5 (CST)

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Translation_of_Dx_Data_from_CCMDB_schema_to_ICD10/CCI&oldid=107210"