Query s tmp QASeptic tmp no dx: Difference between revisions

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..."
 
mNo edit summary
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = If "QAInf" entry is present in [[L_TmpV2]] then
| DIC_summary = Has [[QA Septic Shock]] tmp entry and no dx
* program must be "CC"
| DIC_related_concepts = [[QA Septic Shock]]
* 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_app = CCMDB.mdb
Line 12: Line 10:


Approximate implementation date, this is the first mention in a change log so it was present before.
Approximate implementation date, this is the first mention in a change log so it was present before.
This query uses the following sub-queries:
* s_tmp_QAInf__dx
* s_tmp_QAInf__tmp


== ICD10 dxs ==
== ICD10 dxs ==