Select a.member_id,
a.event_seq,
u.ccms_user_last_name,
a.admission_date,
a.actual_discharge_date,
Max(case when a.actual_los > 19 then a.actual_los else 0 end) as [Actual LOS],
Max(case when a.discharge_status = '62' then a.discharge_status else 0 end) as [DC to Inpt Rehab Facility],
Max(case when a.discharge_status = '63' then a.discharge_status else 0 end) as [DC to Long Term Care Hosp],
Max(case when a.admission_source = '4' then a.admission_source else 0 end) as [Transfer from a Hospital],
Max(case when a.admission_source = '5' then a.admission_source else 0 end) as [Transfer from a SNF],
Max(case when a.admission_source = '6' then a.admission_source else 0 end) as [Transfer from Another Facility],
Max(case when d.clinical_day_type = 'IC' then d.clinical_day_type else 0 end) as [ICU]
from ccmsdba.event_admission a, ccmsdba.event_admission_days d, ccmsdba.ccms_all_users u
where (a.admission_date between '2009-01-01 00:00:00' and '2009-01-31 00:00:00'
or a.actual_discharge_date between '2009-01-01 00:00:00' and '2009-01-31 00:00:00')
and a.member_id = d.member_id 
and a.event_seq = d.event_seq
and u.ccms_id = a.event_manager
and a.event_manager not in (150, 222, 148, 175, 173, 335, 400, 169, 176, 166, 162, 178, 159, 157, 413, 155, 152, 151)
Group by a.member_id, a.event_seq, u.ccms_user_last_name, a.admission_date,a.actual_discharge_date

quote:

---

Originally posted by lbeese

Thanks for your help. I think I have figured it out.

---