Query check ICD10 trach dxs consistent: Difference between revisions

← Older edit Newer edit →

@@ Line 18: / Line 18: @@
 ** CCI
 *** [[Tracheostomy creation]]
+== old query SQL ==
+{{Collapsable| always = click to expand old query | full =
+SELECT l_log.pat_id,
+       has_trach_implying_code.pat_id,
+       has_hasTrach_code.pat_id,
+       *
+FROM   ((SELECT l_log.pat_id,
+               l_cci_picklist.cci_picklist_code,
+               l_icd10.icd10_code
+        FROM   (l_log
+                INNER JOIN l_cci_picklist
+                        ON l_log.pat_id = l_cci_picklist.pat_id)
+               INNER JOIN l_icd10
+                       ON l_log.pat_id = l_icd10.pat_id
+        WHERE  (( ( l_icd10.icd10_code ) = "j95.00"
+                   OR ( l_icd10.icd10_code ) = "j95.02"
+                   OR ( l_icd10.icd10_code ) = "j95.08"
+                   OR ( l_icd10.icd10_code ) = "j95.03" ))
+                OR (( ( l_cci_picklist.cci_picklist_code ) = "1.gj.77" ))) AS
+       has_trach_implying_code
+        RIGHT JOIN l_log
+                ON has_trach_implying_code.pat_id = l_log.pat_id)
+       LEFT JOIN (SELECT l_icd10.pat_id,
+                         l_icd10.icd10_code
+                  FROM   l_icd10
+                  WHERE  (( ( l_icd10.icd10_code ) = "z93.0" ))) AS
+                 has_hasTrach_code
+              ON l_log.pat_id = has_hasTrach_code.pat_id
+WHERE  ( ( ( l_log.pat_id ) = [param] )
+         AND ( ( has_trach_implying_code.pat_id ) IS NOT NULL )
+         AND ( ( has_hasTrach_code.pat_id ) IS NULL ) );  }}
 == Log ==