Healthcare Associated Infections and Healthcare Associated Conditions

These measures are meant to track and indicate the rate of occurrence of conditions or infections that arise as an outcome or result of medical treatment.  

Helpful Queries: 

Getting Measures that are considered HAIs:

select a.* from measures as a, measure_groups_measures as b 

where a.measure_id = b.measure_id 

 and b.measure_group_id= 48

and a.author_measure_id like 'HA%'

Getting Measures that are considered HACs:

select a.* from measures as a, measure_groups_measures as b 

where a.measure_id = b.measure_id 

and b.measure_group_id= 49

Getting Measures that are considered either HAIs or HACs:

select a.* from measures as a, measure_groups_measures as b 

where a.measure_id = b.measure_id 

and b.measure_group_id in (48,49)

and a.author_measure_id like 'HA%'

Measures: