CCMDB Wiki

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

← Older edit
m Text replacement - "[[Category: " to "[[Category:"
 
(6 intermediate revisions by 3 users 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 = Julie | 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)
}}
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 53: Line 43:
{{Related Articles}}
{{Related Articles}}


[[Category: ICD10/CCI Conversion| *]]
[[Category:ICD10/CCI Conversion| *]]
[[Category:ICD10 | * ]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Conversion_from_our_old_diagnosis_schema_to_ICD10/CCI"