SELECT Agency.Agency_Name, ScheduleItems.Visit_Date, ScheduleItems.ScheduleItems_ID, ScheduleItems.Total_Units,
ScheduleItems.EmpPay_ID, ScheduleItems.Payer_ID, ScheduleItems.Bill_Type,
patient.First_Name_M0040 AS FirstName, patient.Last_Name_M0040 AS LastName, patient.Patient_ID,
Employee.Last_Name AS ELast, Employee.First_Name AS EFirst, Employee.Employee_ID,
Payer.Output_Type, Payer.PayName,
Employee_Payroll.EmpPay_ID, Employee_Payroll.Payroll_ID,
Agency_Payroll.Payroll_ID, Agency_Payroll.Visit_Type, Agency_Payroll.Description
FROM #Request.prefix_db_lookup#.Agency, #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.ScheduleItems, #Request.prefix_db_lookup#.Employee,#Request.prefix_db_agency#.Payer, #Request.prefix_db_agency#.Employee_Payroll, #Request.prefix_db_agency#.Agency_Payroll
WHERE ScheduleItems.Agency_ID = Agency.Agency_ID
AND patient.Patient_ID = ScheduleItems.Patient_ID
AND ScheduleItems.Employee_ID = Employee.Employee_ID
AND ScheduleItems.Visit_Date < NOW()
AND ScheduleItems.Employee_ID <> 0
AND ScheduleItems.Total_Units > 0
AND ScheduleItems.EmpPay_ID <> 0
AND ScheduleItems.Payer_ID = Payer.Payer_ID
AND ScheduleItems.EmpPay_ID = Employee_Payroll.EmpPay_ID
AND ScheduleItems.Deleted <> 1
AND Employee_Payroll.Payroll_ID = Agency_Payroll.Payroll_ID
AND Payer.Output_Type <> 'Medicare'
AND ScheduleItems.QB_Export = 0
And Agency.QBInUse = 1
AND Agency.Status = 'active'
ORDER BY Agency_Name, LastName, PayName, Visit_Date, StartTime
Visit ListSuperadmin Home