SELECT Patient_ID, First_Name_m0040, Last_Name_m0040, Middle_Initial_M0040
From #Request.prefix_db_agency#.patient
Where Agency_ID = #session.AgencyID#
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.Payer_ID, ScheduleItems.Visit_Date, ScheduleItems.ScheduleItems_ID,
ScheduleItems.StartTime, ScheduleItems.EndTime, ScheduleItems.Assessment_Tracker_ID, Assessment_New.Certification_Start,
Assessment_New.Certification_End, Assessment_New.Assessment_Reason_M0100, Assessment_New.Assessment_Tracker_ID, ScheduleItems.Telephony_Yes
From #Request.prefix_db_agency#.ScheduleItems, #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.Assessment_New
Where ScheduleItems.ScheduleItems_ID = #url.ID#
AND ScheduleItems.Assessment_Tracker_ID = Assessment_New.Assessment_Tracker_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#
GROUP BY PayName
ORDER BY PayName
SELECT Homebound_Status
FROM #Request.prefix_db_agency#.Assessment_New
WHERE Assessment_New.Assessment_Tracker_ID = #GetSched.Assessment_Tracker_ID#