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.Bill_Type, ScheduleItems.Payer_ID, ScheduleItems.Rev_CodeID,
ScheduleItems.Rev_Code, ScheduleItems.HCPCS, ScheduleItems.Visit_Date, ScheduleItems.Visit_Type,
ScheduleItems.StartTime, ScheduleItems.EndTime, ScheduleItems.Assessment_Tracker_ID, ScheduleItems.ScheduleItems_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#
GROUP BY PayName
ORDER BY PayName
SELECT Rev_CodeID, Rev_Code, HCPCS, Visit_Type, Payer_ID
FROM #Request.prefix_db_agency#.Revenue_Code
WHERE Agency_ID = #session.AgencyID#
AND Payer_ID = #GetSched.Payer_ID#
And EClaim_Price IS NOT NULL
And Quick_Books_Price IS NOT NULL
SELECT Homebound_Status
FROM #Request.prefix_db_agency#.Assessment_New
WHERE Assessment_New.Assessment_Tracker_ID = #GetSched.Assessment_Tracker_ID#