SELECT patient.Last_Name_M0040, patient.First_Name_M0040, Employee.Last_Name, ScheduleItems.ScheduleItems_ID, ScheduleItems.Assessment_Tracker_ID, ScheduleItems.Visit_Date, ScheduleItems.Rev_Code, ScheduleItems.StartTime, ScheduleItems.EndTime, ScheduleItems.Total_Units, ScheduleItems.Mileage, ScheduleItems.HCPCS, ScheduleItems.Progress_Note, ScheduleItems.Total_EClaim,ScheduleItems.Patient_ID, Assessment_New.Assessment_Tracker_ID, Assessment_New.Certification_end, Payer.Payer_ID, Payer.Output_Type, Payer.Payer_Number, Payer.PayName 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, #Request.prefix_db_agency#.Diagnosis WHERE patient.Patient_ID = ScheduleItems.Patient_ID AND ScheduleItems.Visit_Date < NOW() AND ScheduleItems.Employee_ID = Employee.Employee_ID AND ScheduleItems.Payer_ID = Payer.Payer_ID AND ScheduleItems.Deleted <> 1 AND Assessment_New.Assessment_Tracker_ID = ScheduleItems.Assessment_Tracker_ID AND Assessment_New.Assessment_Tracker_ID = Diagnosis.Assessment_Tracker_ID AND Diagnosis.Primary_Diagnosis = '1' AND ScheduleItems.Agency_ID = #session.AgencyID# AND Payer.Output_Type = 'UB82-1500' AND (ScheduleItems.EClaimed <> 1 OR ScheduleItems.EClaimed IS NULL) Group by ScheduleItems_ID ORDER BY Last_Name_M0040, Visit_Date

Billing Administration

UB82 visits waiting to be billed

Check visits you want billed. Items in red need correction before exporting. 50 records displayed at a time.

Visit Compliance


Last, First	Visit Date	Employee	Start	End	Units	Rev Code	HCPCS	Total	Bill
#Last_Name_M0040#, #First_Name_M0040#	#DateFormat(Visit_Date, "mm/dd/yy")#	#Last_Name#	#StartTime#	#EndTime#	#Total_Units#0	#Rev_Code# 0	#HCPCS# 0	#LSCurrencyFormat(Total_EClaim, "local")##LSCurrencyFormat(Total_EClaim, "local")#