View source for Conversion from our old diagnosis schema to ICD10/CCI

This article outlines how we will transition from the [[:Category:Diagnosis Coding (old)|old diagnosis schema]] to [[ICD10]] and [[CCI]]. Process has been in the works since at least 2016.
 
== Timeline ==
* 2018-May-ish: request to collect ICD10 and CCI data for at least two patients per week
* 2018-08-01 implementation of CCMDB.accdb cross-checks starts 
* 2010-10-18:  [[Primary Admit Diagnosis]] needs to be entered for all patients, old style DX 
* 2018-10-01 all initial cross-checks implemented
* 2018-12-01 implementation of CFE/TISS cross checks complete; suggestion of full ICD10/CCI coding for pts expected to be discharged after 2019-01-01 
* 2019-01-01 - enter complete [[ICD10 collection]] and [[CCI Collection]] for patients with [[Dispo DtTm]] >= 2019-01-01

{{Discuss | who = Julie | question =
* We have ICD10 data with all sorts of inconsistencies from before 2019-01-01; would it be better to delete this data? If so, here is the query Pagasa would need to run, so just change the name over to Pagasa. [[User:Ttenbergen|Ttenbergen]] 21:41, 2022 February 17 (CST)
}}
Query to delete records from before we went life: 
 DELETE from L_ICD10
 Where Exists
 ( Select *  
 FROM L_Log 
 where  L_Log.D_ID = L_ICD10.D_ID 
 AND (((L_Log.Dispo_DtTm)<#1/1/2019#)) );

== Data ==
* [[Admit Type for APACHE II#Conversion from our old diagnosis schema to ICD10/CCI]]
** also see [[Previous_Location_field#Heart_Cath_Lab_vs_OR_as_previous_location]] in this regard

=== Diagnoses / [[ICD10]] ===
Diagnosis data will be stored in the [[L_ICD10 table]]. The codes will be provided by the [[s_ICD10 table]]. 

Special consideration will need to be given to:
* [[List of diagnoses affecting Overstay Project]].
* [[Dispo_field]] - organ donor check. 
* [[R Filter Field]]

Dx Code mapping was not possible:
* [[Translation of Dx Data from CCMDB schema to ICD10/CCI]]

=== Procedures  / [[CCI]] ===
See [[CCI Data Structure]].

== Collection Interface ==
[[Patient Viewer Tab ICD10]], [[Patient Viewer Tab CCI_Pick]] and [[Patient Viewer Tab CCI_Comp]] have been added in [[Patient Viewer]].

Completion of new items for CCI/ICD10 in [[CCMDB.accdb Data Integrity Checks]].

== Documentation / wiki ==
=== [[ICD10 collection]] ===
Articles for each new DX are available on the wiki. Where possible the new article will contain a link to the related old article(s). See [[ICD10 Diagnosis List]].

=== [[CCI Collection]] ===
Articles are now on wiki, see [[CCI Picklist]] and [[CCI Component]].

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

[[Category: ICD10/CCI Conversion| *]]