SELECT Patient_ID, First_Name_m0040, Last_Name_m0040, Middle_Initial_M0040
From #Request.prefix_db_agency#.patient
Where Agency_ID = #session.AgencyID#
AND status = 'active'
Order By Last_Name_m0040
SELECT Employee_ID, Last_Name, First_Name
FROM #Request.prefix_db_lookup#.Employee
WHERE Agency_ID = #session.AgencyID#
AND Status = 'active' AND EmployeeType != 'Physician'
Order by Last_Name
Select patient.Patient_ID, patient.First_Name_M0040, patient.Last_Name_M0040, patient.Middle_Initial_M0040,
ScheduleItems.Employee_ID, ScheduleItems.Visit_Type, ScheduleItems.Payer_ID,
ScheduleItems.Visit_Date, ScheduleItems.EClaimed,
ScheduleItems.Assessment_Tracker_ID
From #Request.prefix_db_agency#.ScheduleItems, #Request.prefix_db_agency#.patient
Where ScheduleItems.ScheduleItems_ID = #url.ID#
AND ScheduleItems.Agency_ID = #session.AgencyID#
AND ScheduleItems.Patient_ID = patient.Patient_ID
SELECT Payer_ID, PayName
FROM #Request.prefix_db_agency#.Payer
WHERE Agency_ID = #session.AgencyID#
ORDER BY PayName