SELECT patient.Agency_ID AS Adency_ID, patient.Patient_ID AS Patient_ID, patient.Last_Name_M0040 AS LastName, patient.First_Name_M0040 AS FirstName, patient.Middle_Initial_M0040 AS Middle, patient.status AS status, ScheduleItems.StartTime, ScheduleItems.End_Time, ScheduleItems.Total_Units, ScheduleItems.Mileage, ScheduleItems.ScheduleItems_ID,ScheduleItems.Patient_ID, Employee.Last_Name AS Emp_Last, Employee.First_Name AS Emp_First, Employee.LastName AS Phys_Last, Payer.PayName FROM #Request.prefix_db_agency#.ScheduleItems, #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.Assessment_New, #Request.prefix_db_lookup#.Agency, #Request.prefix_db_lookup#.Physician, #Request.prefix_db_agency#.Diagnosis, #Request.prefix_db_lookup#.Employee, #Request.prefix_db_agency#.Payer WHERE ScheduleItems.Assessment_Tracker_ID = Assessment_New.Assessment_Tracker_ID AND patient.Patient_ID = ScheduleItems.Patient_ID AND Agency.Agency_ID = patient.Agency_ID AND patient.Primary_ReferringPhys_ID_M0072 = Physician.Physician_ID AND Assessment_New.Assessment_Tracker_ID = Diagnosis.Assessment_Tracker_ID AND ScheduleItems.Payer_ID = Payer.Payer_ID AND Diagnosis.Patient_ID = patient.Patient_ID AND ScheduleItems.Employee_ID = Employee.Employee_ID AND patient.Status = 'active' AND Payer.PayName <> 'Medicare' AND Payer.PayName <> 'Medicaid' AND Diagnosis.Primary_Diagnosis = 1 AND ScheduleItems.Agency_ID = #session.AgencyID# AND ScheduleItems.EClaimed <> 1 ORDER BY patient.Last_Name_M0040, ScheduleItems.ScheduleItems_ID SELECT patient.Agency_ID AS Adency_ID, patient.Patient_ID AS Patient_ID, patient.Last_Name_M0040 AS LastName, patient.First_Name_M0040 AS FirstName, patient.Middle_Initial_M0040 AS Middle, patient.status AS status, ScheduleItems.Mileage, ScheduleItems.ScheduleItems_ID,ScheduleItems.Patient_ID, Employee.Last_Name AS Emp_Last, Employee.First_Name AS Emp_First, Employee.LastName AS Phys_Last, Payer.PayName FROM #Request.prefix_db_agency#.ScheduleItems, #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.Assessment_New, #Request.prefix_db_lookup#.Agency, #Request.prefix_db_lookup#.Physician, #Request.prefix_db_agency#.Diagnosis, #Request.prefix_db_lookup#.Employee WHERE ScheduleItems.Assessment_Tracker_ID = Assessment_New.Assessment_Tracker_ID AND patient.Patient_ID = ScheduleItems.Patient_ID AND Agency.Agency_ID = patient.Agency_ID AND patient.Primary_ReferringPhys_ID_M0072 = Physician.Physician_ID AND Assessment_New.Assessment_Tracker_ID = Diagnosis.Assessment_Tracker_ID AND Diagnosis.Patient_ID = patient.Patient_ID AND ScheduleItems.Employee_ID = Employee.Employee_ID AND patient.Status = 'inactive' AND Diagnosis.Primary_Diagnosis = 1 AND ScheduleItems.Agency_ID = #session.AgencyID# AND ScheduleItems.EClaimed <> 1 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.

Last Name, First SOC Visit Date Employee Name Physician Payer Start Time End Time Units Mileage Bill
#DateFormat(Visit_Date, "mm/dd/yyyy")# #Emp_Last#, #Emp_First# #Phys_Last# #PayName# #StartTime# #EndTime# #Total_Units# #Mileage#
Inactive patients not billed
Last Name, First SOC/Visit Date Employee Name Mileage Bill
#DateFormat(Visit_Date, "mm/dd/yyyy")# #Emp_Last#, #Emp_First# #Mileage#