Conversion from our old diagnosis schema to ICD10/CCI

From CCMDB Wiki
Revision as of 10:48, 2022 February 18 by JMojica (talk | contribs) (→‎Timeline)
Jump to navigation Jump to search

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)
  • SMW


  • Cargo


  • Categories

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

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:

Dx Code mapping was not possible:

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: