Conversion from our old diagnosis schema to ICD10/CCI

This article outlines how we will transition from the 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

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. Ttenbergen 21:41, 2022 February 17 (CST) OK. Pagasa, pls save a copy of the original one. TY --JMojica 08:54, 2022 February 18 (CST) With this query below it will delete all test ICD10 entered up to Dec 31,2018.

• SMW

• Cargo

• Categories

PTorres 15:35, 2022 March 28 (CDT)

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.