Changeset 19785 in main

Timestamp:

02/03/20 19:55:25 (3 years ago)

Author:

TongZheng_UT

Message:

epht hddb fixes

Location:

adopters/ut/trunk/src/main/webapps/ibisph-content/xml/query/module/hddb

Files:

• EPHTHDDBCntyHosp.xml (modified) (2 diffs)
• EPHTHDDBCntyHosp_COPD.xml (modified) (4 diffs)

adopters/ut/trunk/src/main/webapps/ibisph-content/xml/query/module/hddb/EPHTHDDBCntyHosp.xml

@@ -686 +686 @@
         <PARAMETER>
           <NAME>data_where</NAME>
-          <VALUE>heatcase in (1) or heatcase2 in (1) and dutcnty=1</VALUE>
+          <VALUE>heatcase2 in (1)  </VALUE>
         </PARAMETER>
       </PARAMETERS>
@@ -1064 +1064 @@
         <PARAMETER>
           <NAME>data_where</NAME>
-          <VALUE>heatcase in (1) or heatcase2 in (1) and dutcnty=1</VALUE>
+          <VALUE>heatcase2 in (1) </VALUE>
         </PARAMETER>
         <!--PARAMETER>

adopters/ut/trunk/src/main/webapps/ibisph-content/xml/query/module/hddb/EPHTHDDBCntyHosp_COPD.xml

@@ -57 +57 @@
       <VALUE>0</VALUE>
     </PARAMETER>
-    <PARAMETER>
+        
+    <!--PARAMETER>
       <NAME>sasdata</NAME>
       <VALUE>copd_ncdm_2017</VALUE>
-    </PARAMETER>
+    </PARAMETER-->
     <!--PARAMETER>
       <NAME>saspopdata</NAME>
@@ -91 +92 @@
           <VALUE>data_frame/CountHosp_COPD.def</VALUE>
         </PARAMETER>
+                <PARAMETER>
+      <NAME>data_where</NAME>
+      <VALUE>copd2=1</VALUE>
+    </PARAMETER>
       </PARAMETERS>
       <CRITERIA>
@@ -178 +183 @@
           <VALUE>data_frame/CrudeRateHospCO_cv.def</VALUE>
         </PARAMETER>
-        
+        <PARAMETER>
+      <NAME>data_where</NAME>
+      <VALUE>copd2=1</VALUE>
+    </PARAMETER>
       </PARAMETERS>
       <CRITERIA>
@@ -269 +277 @@
                 <PARAMETER>
           <NAME>data_where</NAME>
-          <VALUE>AgeGrp_NCDM_18>=6</VALUE>
+          <VALUE>AgeGrp18>=6 and copd2=1</VALUE>
         </PARAMETER>
       </PARAMETERS>