SELECT Agency.Agency_Name, ScheduleItems.Visit_Date, ScheduleItems.ScheduleItems_ID, ScheduleItems.Total_Units, ScheduleItems.EmpPay_ID, ScheduleItems.Payer_ID, ScheduleItems.Visit_Type AS 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, Employee.Skill, Assessment_New.Certification_End, Assessment_New.Assessment_Reason_M0100 AS Reason, Assessment_New.Homebound_Status AS Home, 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#.Employee_Payroll, #Request.prefix_db_agency#.Agency_Payroll, #Request.prefix_db_agency#.Assessment_New WHERE ScheduleItems.Agency_ID = Agency.Agency_ID And Agency.QBInUse = 1 AND Agency.Status = 'active' AND ScheduleItems.Visit_Date <> '0000-00-00' AND Assessment_New.Certification_Start <> '0000-00-00' AND Assessment_New.Certification_End <> '0000-00-00' AND patient.Patient_ID = ScheduleItems.Patient_ID AND Assessment_New.Assessment_Tracker_ID = ScheduleItems.Assessment_Tracker_ID AND (Assessment_New.Assessment_Reason_M0100 LIKE '1%' or Assessment_New.Assessment_Reason_M0100 LIKE '4%') AND Assessment_New.Certification_End IS NOT NULL AND Assessment_New.HIPPS_Code <> '' AND Assessment_New.Homebound_Status > 0 AND Assessment_New.QB_Export >= 1 AND ScheduleItems.Employee_ID = Employee.Employee_ID AND ScheduleItems.Visit_Date < NOW() AND ScheduleItems.Employee_ID <> 0 AND ScheduleItems.Total_Units > 0 AND ScheduleItems.StartTime <> '00:00:00' AND ScheduleItems.EmpPay_ID <> 0 AND ScheduleItems.EmpPay_ID = Employee_Payroll.EmpPay_ID AND ScheduleItems.Output_Type = 'Medicare' AND ScheduleItems.Deleted <> 1 AND Employee_Payroll.Payroll_ID = Agency_Payroll.Payroll_ID AND ScheduleItems.QB_Export = 0 ORDER BY Agency_Name, LastName, Certification_End, Visit_Date, StartTime Visit List Superadmin Home

Unexported Final Claim Visits

Agency Last First Cert End Visit Date Employee Skill Units
#Agency_Name#
#LastName#
#FirstName#
#DATEFORMAT(Certification_End,"mm/dd/yyyy")#
#DATEFORMAT(Visit_Date,"mm/dd/yyyy")#
#ELast#
#Skill#
#Total_Units#