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

From CCMDB Wiki
Jump to navigation Jump to search
Line 9: Line 9:
* 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


{{Discuss | who = Julie | question =
{{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)
* 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. --[[User:JMojica|JMojica]] 08:54, 2022 February 18 (CST) }}
Query to delete records from before we went life:  
Query to delete records from before we went life:  
  DELETE from L_ICD10
  DELETE from L_ICD10

Revision as of 09:54, 2022 February 18

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. --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:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Conversion_from_our_old_diagnosis_schema_to_ICD10/CCI&oldid=154864"