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.

As of 18:59, 2017 September 16 (CDT), some of the discussion about this continues in Task Team Meeting - Rolling Agenda and Minutes.

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

Procedures / CCI

Procedure data will be stored in the L_CCI table. The codes will be provided in the s_CCI table.

Special consideration will need to be given to:

• Registry Patient Type#Conversion from our old diagnosis schema to ICD10/CCI

Collection Interface

Patient viewer tab ICD10 will be added in Patient Viewer.

Need to address Facilitating diagnosis entries.

Documentation

Tina will import articles for each new DX onto the wiki. Where possible the new article will contain a link to the related old article(s). All will need to be reconciled with current diagnoses.

See also:

• Diagnoses that likely have criteria based on article size

Conversion

• Template:Discussion How will we import dxs that are in s_alldiagnoses but not currently allowed to be collected? Ttenbergen 18:37, 2017 September 18 (CDT)

• Template:Discussion CCI - should we move the imaging labs collection in with this? Emailed Allan... Ttenbergen 19:51, 2017 September 18 (CDT)

• Template:Discussion CCI, should we include a location of procedure? We keep discussing similar concepts and procedure on unit would have impact on workload. Emailed Allan. Ttenbergen 19:51, 2017 September 18 (CDT)

• Template:Discussion What will we do with Category:Task Elements; they don't fit into ICD10/CCI (or do they)? emailed Allan. Ttenbergen 20:17, 2017 September 18 (CDT)

• Template:Discussion are any ICD10s always in pairs/triplets/etc? if we have column for this we can do cross-checks. Any other cross checks like that? Emailed Allan. Ttenbergen 20:29, 2017 September 18 (CDT)