SELECT Employee.Employee_ID, Employee.Last_Name, Employee.First_Name
FROM #Request.prefix_db_lookup#.Employee
WHERE Employee.Agency_ID = #session.AgencyID#
AND Employee.Status = 'active' AND Employee.EmployeeType != 'Physician'
Group by Employee.employee_id
Order by Employee.Last_Name
Select patient.Patient_ID, patient.First_Name_M0040, patient.Last_Name_M0040, patient.Middle_Initial_M0040,
ScheduleItems.ScheduleItems_ID, ScheduleItems.Mileage, ScheduleItems.PayMileage,ScheduleItems.Missed, ScheduleItems.Progress_Note,
ScheduleItems.Employee_ID, ScheduleItems.EmpPay_ID, ScheduleItems.Visit_Type,
ScheduleItems.Paperwork, ScheduleItems.Travel, ScheduleItems.Payer_ID,
ScheduleItems.Rev_Code, ScheduleItems.Rev_CodeID,
ScheduleItems.Visit_Date, ScheduleItems.HCPCS,
ScheduleItems.StartTime, ScheduleItems.EndTime, ScheduleItems.Visit_Notes,
ScheduleItems.Assessment_ID,
ScheduleItems.Assessment_Tracker_ID,
ScheduleItems.Telephony_Yes
From #Request.prefix_db_agency#.ScheduleItems, #Request.prefix_db_agency#.patient, #Request.prefix_db_lookup#.Agency
Where ScheduleItems.ScheduleItems_ID = #session.cs.ScheduleID#
AND ScheduleItems.Agency_ID = #session.AgencyID#
AND ScheduleItems.Agency_ID = Agency.Agency_ID
AND ScheduleItems.Patient_ID = patient.Patient_ID
Select patient.Patient_ID, patient.First_Name_M0040, patient.Last_Name_M0040, patient.Middle_Initial_M0040
From #Request.prefix_db_agency#.patient
Where patient.Patient_ID = #Session.CS.PatientID#
SELECT Assessment_Reason_M0100 as visit_type
from #Request.prefix_db_agency#.Assessment_New
where assessment_tracker_id = #Session.CS.AssessmentTrackerID#
and assessment_id = #Session.CS.AssessmentID#
Select Certification_Start as Cert_Start1, Certification_End as Cert_End1, Assessment_Reason_M0100
from #Request.prefix_db_agency#.Assessment_New where Assessment_Tracker_ID = #GetSched.Assessment_Tracker_ID#
SELECT Assessment_Reason_M0100, Assessment_Tracker_ID, Assessment_ID, Certification_Start AS Cert_Start, Certification_End AS Cert_End, Assessment_Completed_M0090,Admission_Status
FROM #Request.prefix_db_agency#.Assessment_New
WHERE Patient_ID = #GetSched.Patient_ID#
AND Deleted <> 1
AND (Assessment_Reason_M0100 LIKE '1%' OR Assessment_Reason_M0100 LIKE '4%' OR Assessment_Reason_M0100 LIKE '%Evaluation%' OR Assessment_Reason_M0100 LIKE '%Hospice%')
ORDER BY Assessment_Completed_M0090 Desc
SELECT Employee_Payroll.EmpPay_ID, Employee_Payroll.Employee_ID, Agency_Payroll.Visit_Type, Agency_Payroll.Description
FROM #Request.prefix_db_agency#.Employee_Payroll, #Request.prefix_db_agency#.Agency_Payroll
WHERE Agency_Payroll.Agency_ID = #session.AgencyID#
AND Employee_Payroll.Payroll_ID = Agency_Payroll.Payroll_ID
AND Employee_Payroll.Employee_ID = #GetSched.Employee_ID#
ORDER BY Employee_Payroll.Employee_ID,Employee_Payroll.EmpPay_ID
SELECT Payer_ID, PayName, Output_Type
FROM #Request.prefix_db_agency#.Payer
WHERE Agency_ID = #session.AgencyID#
ORDER BY PayName
SELECT Rev_Code, Rev_CodeID, 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 Rev_Code, Rev_CodeID, HCPCS, Visit_Type, Payer_ID
FROM #Request.prefix_db_agency#.Revenue_Code
WHERE Agency_ID = #session.AgencyID#
And EClaim_Price IS NOT NULL
And Quick_Books_Price IS NOT NULL
And Payer_ID = #GetSched.Payer_ID#
SELECT Homebound_Status
FROM #Request.prefix_db_agency#.Assessment_New
WHERE Assessment_New.Assessment_Tracker_ID = #GetSched.Assessment_Tracker_ID#
Edit #GetSched.Visit_Type# Visit for #GetSched.last_name_m0040#, #getsched.first_name_m0040#