Translation of Dx Data from CCMDB schema to ICD10/CCI

From CCMDB Wiki
Revision as of 12:14, 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.

Template:Discussion Currently confirming that none of the codes in ICD10 after original import ‎ will affect this. Once that is done, we need to do a translation of the old dxs to new ones.

background

Excel workbook from Allan Garland, used by Tina, can be found on X:ccmdb\!ICD10_Mapped

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=107207"