select TurboClaim from #Request.prefix_db_agency#.Payer where Payer_ID = '#urlpayerid#' SELECT patient.Patient_ID, patient.Last_Name_M0040, patient.First_Name_M0040, patient.EligAuto, Employee.Last_Name, Payer.PayName, ScheduleItems.ScheduleItems_ID,ScheduleItems.Payer_ID,ScheduleItems.ApproveBill, ScheduleItems.Visit_Date, ScheduleItems.StartTime, ScheduleItems.EndTime, ScheduleItems.Nonbillable, 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 patient.Primary_ReferringPhys_ID_M0072 != 0 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 ScheduleItems.Payer_ID = '#urlpayerid#' AND ScheduleItems.Output_Type = '#outtype#' AND ScheduleItems.Deleted = 0 AND ScheduleItems.Missed = 'No' AND ScheduleItems.Nonbillable = 0 AND ScheduleItems.Total_Units != 0 AND ScheduleItems.EClaimed = 0 AND ScheduleItems.Visit_Date < NOW() AND Assessment_New.Deleted = 0 AND patient.patient_id = '#FORM.pid#' AND ScheduleItems.Visit_Date >= #CreateODBCDate(FORM.df)# AND ScheduleItems.Visit_Date <= #CreateODBCDate(FORM.dt)# 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 Select distinct(Patient_ID) as Patient_ID, Last_Name_M0040, First_Name_M0040 from Get_Bills ORDER BY Last_Name_M0040, First_Name_M0040 asc SELECT Payer_ID FROM #Request.prefix_db_agency#.Payer where TeamBill = 1

#Get_Bills.PayName# CMS 1500s Ready to Bill

Check visits you want billed. Items in red should be corrected before exporting.

search :

From :

To :

Patient :

There are no records


Last, First	Assessment	Visit Date	Employee	Units	Rev Code	HCPCS	Total	Bill	Authorize?
#Last_Name_M0040#, #First_Name_M0040# (elig rejected) (elig accepted)	SOC ROC - #DateFormat(Certification_Start, "mm/dd/yy")# - #DateFormat(Certification_End, "mm/dd/yy")#	#DateFormat(Visit_Date, "mm/dd/yy")#	#Last_Name#	#Total_Units# 0	#Rev_Code# 0	#HCPCS# 0	#LSCurrencyFormat(Total_EClaim, "local")# -	checked>	checked