select 0 AS TurboClaim from #Request.prefix_db_agency#.pPayer where Pay_ID = '#url.ID#' SELECT pPatients.Patient_ID, pPatients.Pt_Last, pPatients.Pt_First, pEmployee.Emp_Last, ( SELECT count(*) FROM #Request.prefix_db_agency#.Eligibility WHERE Patient_ID = pAssessments.Patient_ID AND PtPayer_ID = pPtPayer.PtPayer_ID AND Status = 0 ) AS Eligi, CASE WHEN pAssessments.F177 < '2020-01-01' THEN "FIRST FINAL" WHEN DATEDIFF(pSchedules.Visit_Date,pAssessments.F177) < 30 THEN "FIRST FINAL" WHEN DATEDIFF(pSchedules.Visit_Date,pAssessments.F177) >= 30 THEN "SECOND FINAL" ELSE "" END as claim_type, CASE WHEN DATEDIFF(pSchedules.Visit_Date,pAssessments.F177) < 30 THEN pAssessments.F177 WHEN DATEDIFF(pSchedules.Visit_Date,pAssessments.F177) >= 30 THEN DATE_ADD(pAssessments.F177, INTERVAL 30 DAY) ELSE pAssessments.F177 END as start_date, CASE WHEN DATEDIFF(pSchedules.Visit_Date,pAssessments.F177) < 30 THEN DATE_ADD(pAssessments.F177, INTERVAL 30 DAY) WHEN DATEDIFF(pSchedules.Visit_Date,pAssessments.F177) >= 30 THEN pAssessments.F178 ELSE pAssessments.F178 END as end_date, CASE WHEN DATEDIFF(pSchedules.Visit_Date,pAssessments.F177) <= 30 THEN true WHEN DATEDIFF(pSchedules.Visit_Date,pAssessments.F177) > 30 AND DATEDIFF(now(),pAssessments.F177) >= 30 THEN true WHEN pAssessments.F178 <= NOW() THEN TRUE ELSE false END as bill, pPayer.Pay_Name, pSchedules.Schedule_ID,pSchedules.PtPayer_ID, pSchedules.Nonbillable,pSchedules.Assmt_ID, pSchedules.Visit_Date, pSchedules.StartTime, pSchedules.EndTime, pSchedules.Total_Units, pSchedules.Rev_ID, '' AS Total_EClaim, '' AS Output_Type, '' AS EClaimed, pAssessments.F26 AS Assessment_Reason_M0100, pAssessments.F177, pAssessments.F178, pSchedules.Invoice_ID, pPayer.Pay_ID ,pPtPayer.Payer_ID,pRevenue_Code.Rev_Code, pRevenue_Code.HCPCS FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pSchedules.Patient_ID JOIN #Request.prefix_db_lookup#.pEmployee ON pSchedules.Emp_ID = pEmployee.Emp_ID JOIN #Request.prefix_db_agency#.pPtPayer ON pSchedules.PtPayer_ID = pPtPayer.PtPayer_ID JOIN #Request.prefix_db_agency#.pPayer ON pPayer.Pay_Id = pPtPayer.Payer_ID JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pRevenue_Code ON pSchedules.Rev_ID = pRevenue_Code.Rev_CodeID WHERE pPayer.Pay_ID = '#url.ID#' AND pPatients.Status < 2 -- AND pAssessments.F26 = 1 -- AND pSchedules.Progress_Note = 1 AND pSchedules.Visit_Date < NOW() AND pSchedules.status = 0 AND pSchedules.Missed = 0 AND pSchedules.Invoice_ID = 0 AND pSchedules.Nonbillable = 0 AND pAssessments.Status = 0 AND pSchedules.Total_units > 0 AND pPatients.Patient_ID = '#FORM.pid#' AND pSchedules.Visit_Date >= #CreateODBCDate(FORM.df)# AND pSchedules.Visit_Date <= #CreateODBCDate(FORM.dt)# GROUP BY Schedule_ID ORDER BY Pt_Last, Pt_First, pAssessments.Assmt_ID, Visit_Date SELECT DISTINCT Patient_ID, Pt_Last, Pt_First FROM Get_Bills ORDER BY Pt_Last, Pt_First SELECT Pay_ID AS Payer_ID FROM #Request.prefix_db_agency#.pPayer

Result set

There are no records

Last, First	Assessment	Final Type	Visit Date	Employee	Units	Rev Code	HCPCS	Total		Authorize
#Pt_Last#, #Pt_First#	SOC RECERT - #DateFormat(start_date, "mm/dd/yy")# - #DateFormat(end_date, "mm/dd/yy")#	* #claim_type#	#DateFormat(Visit_Date, "mm/dd/yy")#	#Emp_Last#	#Total_Units# 0	#Rev_Code# #HIPPS_Code# RAP not billed	#HCPCS# 0	#LSCurrencyFormat(Total_EClaim, "local")# #LSCurrencyFormat(Total_EClaim, "local")#	checked>	checked>