SELECT
patient.Patient_ID, patient.Last_Name_M0040, patient.First_Name_M0040, Employee.Last_Name, Payer.PayName,
ScheduleItems.ScheduleItems_ID, ScheduleItems.Visit_Date, ScheduleItems.StartTime, ScheduleItems.EndTime,
ScheduleItems.Total_Units, ScheduleItems.Rev_Code, ScheduleItems.HCPCS, ScheduleItems.Total_EClaim,
Assessment_New.Assessment_Reason_M0100, Assessment_New.Certification_Start, Assessment_New.Certification_End,
ScheduleItems.Invoice_ID
FROM #Request.prefix_db_agency#.ScheduleItems, #Request.prefix_db_agency#.patient, #Request.prefix_db_lookup#.Employee, #Request.prefix_db_agency#.Payer, #Request.prefix_db_agency#.Assessment_New
WHERE ScheduleItems.Agency_ID = #session.AgencyID#
AND patient.Patient_ID = ScheduleItems.Patient_ID
AND patient.Status <> 'deleted'
AND ScheduleItems.Employee_ID = Employee.Employee_ID
AND ScheduleItems.Payer_ID = Payer.Payer_ID
AND ScheduleItems.Assessment_Tracker_ID = Assessment_New.Assessment_Tracker_ID
AND ScheduleItems.Visit_Date < NOW()
AND ScheduleItems.Payer_ID = '#url.ID#'
AND ScheduleItems.Output_Type = '#url.type#'
AND ScheduleItems.EClaimed = 0
AND ScheduleItems.Deleted <> 1
AND ScheduleItems.Missed <> 'Yes'
AND (Assessment_New.Deleted IS Null OR Assessment_New.Deleted = '0')
AND (Assessment_New.Archive IS Null OR Assessment_New.Archive = '0')
AND Assessment_New.Certification_Start <> '0000-00-00'
AND Assessment_New.Certification_End <> '0000-00-00'
Group by ScheduleItems_ID
ORDER BY Last_Name_M0040, First_Name_M0040, Assessment_New.Assessment_Tracker_ID, Visit_Date
#Get_Bills.PayName# UB04s Ready to Bill
Check visits you want billed. Items in red should be corrected before exporting.