CCMDB Wiki

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

← Older editNewer edit →
PTorres (talk | contribs)
CCMDB_legit, approved
1,617 edits
Line 8: Line 8:
* 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 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
* 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 ==
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Conversion_from_our_old_diagnosis_schema_to_ICD10/CCI"