select distinct Sch.Patient_Id, pt.Last_Name_M0040 AS Last_Name, pt.First_Name_M0040 AS First_Name, pt.Status from #Request.prefix_db_agency#.ScheduleItems Sch,#Request.prefix_db_agency#.authorizations au,
#Request.prefix_db_agency#.patient pt where Sch.Rev_Code = au.Revenue_Code AND Sch.Payer_ID = au.Payer_ID AND Sch.Patient_ID = au.Patient_ID and Sch.Visit_Date between au.StartDate and au.EndDate and Sch.Patient_Id = pt.Patient_Id and Sch.Auth_Id = 0
and pt.Agency_ID = #session.AgencyID#
and pt.Status = 'active'
order by Last_Name, First_Name