SELECT patient.Last_Name_M0040, patient.First_Name_M0040, Employee.Last_Name, Employee.First_Name, ScheduleItems.ScheduleItems_ID, ScheduleItems.Assessment_Tracker_ID, ScheduleItems.Visit_Date, ScheduleItems.Rev_Code, ScheduleItems.StartTime, ScheduleItems.EndTime, ScheduleItems.Total_Units, ScheduleItems.Mileage, ScheduleItems.Progress_Note,ScheduleItems.Patient_ID, Assessment_New.Assessment_Tracker_ID, Assessment_New.Certification_end, Payer.Payer_ID, Payer.Output_Type FROM #Request.prefix_db_agency#.ScheduleItems, #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.Diagnosis, #Request.prefix_db_lookup#.Employee,#Request.prefix_db_agency#.Payer, #Request.prefix_db_agency#.Assessment_New WHERE patient.Patient_ID = ScheduleItems.Patient_ID AND ScheduleItems.Visit_Date < NOW() AND Diagnosis.Patient_ID = patient.Patient_ID AND ScheduleItems.Employee_ID = Employee.Employee_ID AND ScheduleItems.Payer_ID = Payer.Payer_ID AND Assessment_New.Assessment_Tracker_ID = ScheduleItems.Assessment_Tracker_ID AND patient.Status = 'active' AND Diagnosis.Primary_Diagnosis = 1 AND ScheduleItems.Agency_ID = #session.AgencyID# AND (ScheduleItems.Bill_Type = '811') AND Payer.Output_Type = 'Medicare' AND (ScheduleItems.EClaimed <> 1 OR ScheduleItems.EClaimed IS NULL) ORDER BY patient.Last_Name_M0040, ScheduleItems.ScheduleItems_ID SELECT patient.Last_Name_M0040, patient.First_Name_M0040, Employee.Last_Name, Employee.First_Name, ScheduleItems.ScheduleItems_ID, ScheduleItems.Visit_Date, ScheduleItems.Rev_Code, ScheduleItems.StartTime, ScheduleItems.EndTime, ScheduleItems.Total_Units, ScheduleItems.Mileage, Payer.PayName, ScheduleItems.Patient_ID FROM #Request.prefix_db_agency#.ScheduleItems, #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.Diagnosis, #Request.prefix_db_lookup#.Employee, #Request.prefix_db_agency#.Payer WHERE patient.Patient_ID = ScheduleItems.Patient_ID AND Diagnosis.Patient_ID = patient.Patient_ID AND ScheduleItems.Employee_ID = Employee.Employee_ID AND ScheduleItems.Payer_ID = Payer.Payer_ID AND patient.Status = 'inactive' AND Diagnosis.Primary_Diagnosis = 1 AND ScheduleItems.Agency_ID = #session.AgencyID# AND ScheduleItems.Bill_Type = '322' AND Payer.PayName = 'Medicare' AND (ScheduleItems.EClaimed <> 1 OR ScheduleItems.EClaimed IS NULL) ORDER BY patient.Last_Name_M0040, ScheduleItems.ScheduleItems_ID

Billing Administration

Active patients listed below are automatically selected for download. Un-check visits you don't want billed. Inactive patients must be selected to be billed.

Final Claim Visits waiting to be billed
Last Name, First SOC Visit Date Employee Name Start Time End Time Units Note? Mileage Bill
#DateFormat(Visit_Date, "mm/dd/yyyy")# #Last_Name#, #First_Name# #StartTime# #EndTime# #Total_Units# yes no #Mileage#
Inactive patients not billed
Last Name, First SOC/Visit Date Employee Name Mileage Bill
#DateFormat(Visit_Date, "mm/dd/yyyy")# #Last_Name#, #First_Name# #Mileage#