Sha256: 427beb995dd1db932e6ff679ff84714fc444ae1351ed4f21c7b935de711bfd14

Contents?: true

Size: 349 Bytes

Versions: 177

Compression:

Stored size: 349 Bytes

Contents

SELECT
  units.name,
  count(stats.id) AS patient_count,
  0 as percentage_hb_gt_100,
  0 as percentage_urr_gt_65,
  0 as percentage_phosphate_lt_1_8,
  0 as percentage_access_fistula_or_graft,
  0 as avg_missed_hd_time
  FROM (hd_patient_statistics stats
  JOIN hospital_units units ON ((units.id = stats.hospital_unit_id)))
  GROUP BY units.name;

Version data entries

177 entries across 177 versions & 1 rubygems

Version Path
renalware-core-2.1.1 db/views/reporting_hd_overall_audit_v02.sql
renalware-core-2.1.0 db/views/reporting_hd_overall_audit_v02.sql
renalware-core-2.0.167 db/views/reporting_hd_overall_audit_v02.sql
renalware-core-2.0.166 db/views/reporting_hd_overall_audit_v02.sql
renalware-core-2.0.165 db/views/reporting_hd_overall_audit_v02.sql
renalware-core-2.0.164 db/views/reporting_hd_overall_audit_v02.sql
renalware-core-2.0.163 db/views/reporting_hd_overall_audit_v02.sql
renalware-core-2.0.162 db/views/reporting_hd_overall_audit_v02.sql
renalware-core-2.0.161 db/views/reporting_hd_overall_audit_v02.sql
renalware-core-2.0.160 db/views/reporting_hd_overall_audit_v02.sql
renalware-core-2.0.159 db/views/reporting_hd_overall_audit_v02.sql
renalware-core-2.0.158 db/views/reporting_hd_overall_audit_v02.sql
renalware-core-2.0.157 db/views/reporting_hd_overall_audit_v02.sql
renalware-core-2.0.156 db/views/reporting_hd_overall_audit_v02.sql
renalware-core-2.0.155 db/views/reporting_hd_overall_audit_v02.sql
renalware-core-2.0.153 db/views/reporting_hd_overall_audit_v02.sql
renalware-core-2.0.152 db/views/reporting_hd_overall_audit_v02.sql
renalware-core-2.0.151 db/views/reporting_hd_overall_audit_v02.sql
renalware-core-2.0.149 db/views/reporting_hd_overall_audit_v02.sql
renalware-core-2.0.148 db/views/reporting_hd_overall_audit_v02.sql