Conversion from our old diagnosis schema to ICD10/CCI: Difference between revisions
| Line 11: | Line 11: | ||
{{Discuss | who = Pagasa | 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. Pagasa, pls save a copy of the original one. TY --[[User:JMojica|JMojica]] 08:54, 2022 February 18 (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: | Query to delete records from before we went life: | ||
DELETE from L_ICD10 | DELETE from L_ICD10 | ||