CCMDB Wiki

Query s tmp QASeptic Dx no tmp ICD10: Difference between revisions

Newer edit →
Created page with "{{Data Integrity Check | DIC_summary = If "QAInf" entry is present in L_TmpV2 then * program must be "CC" * the '''corresponding''' diagnosis must exist | DIC_related_conc..."
 
m Text replacement - "CCMDB.mdb" to "CCMDB.accdb"
(14 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = If "QAInf" entry is present in [[L_TmpV2]] then
| DIC_summary = CC patient has [[Septic Shock]]/[[Shock, septic]] dx and no  [[QA Septic Shock]] tmp entry
* program must be "CC"
| DIC_related_concepts = QA Septic Shock;  Septic Shock; Shock, septic
* the '''corresponding''' diagnosis must exist
| DIC_related_concepts = [[QA Infection]], [[QA Infection CLI]], [[QA Infection VAP]]
| DIC_firmness = hard check
| DIC_firmness = hard check
| DIC_app = CCMDB.mdb
| DIC_timing =
| DIC_coding = Query s tmp QAInf dx no tmp
| DIC_app = CCMDB.accdb
| DIC_status = needs review
| DIC_coding = query ''s_tmp_QASeptic_Dx_no_tmp_ICD10''
| DIC_implementation_date = 2009-12-29
| DIC_status = implemented
| DIC_implementation_date = 2018-11-06
}}
}}


Approximate implementation date, this is the first mention in a change log so it was present before.
== Log ==
 
* 2018-12-24 - removed query ''s_tmp_QASeptic_Dx_no_tmp'' as part of move to ICD10
This query uses the following sub-queries:
* 2018-11-06 - added query ''s_tmp_QASeptic_Dx_no_tmp_ICD10'' to also check for this in ICD10
* s_tmp_QAInf__dx
* 2012-11-01 - initial implementation; Approximate implementation date, this is the first mention in a change log so it was present before.
* s_tmp_QAInf__tmp
 
== ICD10 dxs ==
{{Discuss | who = Allan | question =
* what will be the ICD10 codes to use for this cross check? }}


== Related articles ==
== Related articles ==
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_s_tmp_QASeptic_Dx_no_tmp_ICD10"