Conversion from our old diagnosis schema to ICD10/CCI: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
PTorres (talk | contribs)
m Text replacement - "[[Category: " to "[[Category:"
 
(3 intermediate revisions by the same user not shown)
Line 6: Line 6:
* 2010-10-18:  [[Primary Admit Diagnosis]] needs to be entered for all patients, old style DX  
* 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-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  
* 2018-12-01 implementation of CFE/TISS [[cross check]]s 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
* 2019-01-01 - enter complete [[ICD10 collection]] and [[CCI Collection]] for patients with [[Dispo DtTm]] >= 2019-01-01
 
* 2022-03-28 - deleted all test ICD10 entered up to Dec 31,2018.
{{Discuss | who = Pagasa | 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)
** OK. Pagasa, pls save a copy of the original one. TY --[[User:JMojica|JMojica]] 08:54, 2022 February 18 (CST)
With this query below it will delete all test ICD10 entered up to Dec 31,2018. }}
 
[[User:PTorres|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 ==
== Data ==
Line 57: Line 43:
{{Related Articles}}
{{Related Articles}}


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

Latest revision as of 10:32, 30 July 2025

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
  • 2022-03-28 - deleted all test ICD10 entered up to Dec 31,2018.

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: