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, ScheduleItems.Progress_Note, ScheduleItems.Patient_ID, 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 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 = 'active' AND Diagnosis.Primary_Diagnosis = 1 AND ScheduleItems.Agency_ID = #session.AgencyID# AND ScheduleItems.Bill_Type = '81A' 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.

NOEs waiting to be submitted
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#