SELECT pEmployee.Emp_Last, pPayer.Pay_ID, "" AS terms, pPatients.Pt_City, pPatients.Pt_State, pPatients.Pt_Zip, pPatients.Pt_Street, pPatients.Patient_ID, pPatients.Pt_Last, pPatients.Pt_First, pPayer.Pay_Street, pPayer.Pay_Name, pSchedules.Schedule_ID, pSchedules.Visit_Date, pSchedules.StartTime, pSchedules.EndTime, 0 AS Total_Hours,pSchedules.Assmt_ID, pRevenue_Code.Rev_Code, pSchedules.Skill, pRevenue_Code.HCPCS, pSchedules.Total_EClaim, pSchedules.Invoice_ID, pAssessments.F26 AS Assessment_Reason_M0100, pAssessments.F177 AS Certification_Start, pAssessments.F178 AS Certification_End, pRevenue_Code.EClaim_Price, pRevenue_Code.Description FROM #Request.prefix_db_agency#.pSchedules LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee on pEmployee.Emp_ID = pSchedules.Emp_ID AND pSchedules.status = 0 JOIN #Request.prefix_db_agency#.pPtPayer ON pPtPayer.PtPayer_ID = pSchedules.PtPayer_ID AND pPtPayer.status = 0 JOIN #Request.prefix_db_agency#.pPayer ON pPtPayer.Payer_ID = pPayer.Pay_ID AND pPayer.status = 0 JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pSchedules.Patient_ID AND pPatients.status < 2 JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_ID AND pAssessments.status = 0 JOIN #Request.prefix_db_agency#.pRevenue_Code on pRevenue_Code.Rev_CodeID = pSchedules.Rev_ID WHERE pSchedules.Visit_Date < NOW() AND pPayer.Pay_ID = '#url.ID#' AND pSchedules.EClaimed = 0 AND pSchedules.Missed = 0 AND pSchedules.Schedule_ID IN (#schid#) Group by Schedule_ID ORDER BY Pt_Last, Pt_First, pSchedules.Assmt_ID, Visit_Date SELECT pEmployee.Emp_Last, pPayer.Pay_ID, pPatients.Pt_City, pPatients.Pt_State, pPatients.Pt_Zip, pPatients.Pt_Street, pPatients.Patient_ID, pPatients.Pt_Last, pPatients.Pt_First, pPayer.Pay_Street, pPayer.Pay_Name, pSchedules.Schedule_ID, pSchedules.Visit_Date, pSchedules.StartTime, pSchedules.EndTime, 0 AS Total_Hours,pSchedules.Assmt_ID, pRevenue_Code.Rev_Code, pSchedules.Skill, pRevenue_Code.HCPCS, pSchedules.Total_EClaim, pSchedules.Invoice_ID, pAssessments.F26 AS Assessment_Reason_M0100, pAssessments.F177 AS Certification_Start, pAssessments.F178 AS Certification_End, pRevenue_Code.EClaim_Price, pRevenue_Code.Description FROM #Request.prefix_db_agency#.pSchedules LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee on pEmployee.Emp_ID = pSchedules.Emp_ID AND pSchedules.status = 0 JOIN #Request.prefix_db_agency#.pPtPayer ON pPtPayer.PtPayer_ID = pSchedules.PtPayer_ID AND pPtPayer.status = 0 JOIN #Request.prefix_db_agency#.pPayer ON pPtPayer.Payer_ID = pPayer.Pay_ID AND pPayer.status = 0 JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pSchedules.Patient_ID AND pPatients.status < 2 JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_ID AND pAssessments.status = 0 JOIN #Request.prefix_db_agency#.pRevenue_Code on pRevenue_Code.Rev_CodeID = pSchedules.Rev_ID WHERE pSchedules.Visit_Date < NOW() AND pPayer.Pay_ID = '#url.ID#' AND pSchedules.EClaimed = 0 AND pSchedules.Missed = 0 AND pSchedules.Schedule_ID IN (#schid#) Group by pSchedules.Assmt_ID ORDER BY Pt_Last, Pt_First, pSchedules.Assmt_ID, Visit_Date

Something Went wrong. Please connect with your admin

 INSERT INTO #Request.prefix_db_agency#.Invoices ( PatientPayer_ID ,Agency_ID ,Patient_ID ,Assmt_ID ,DateSent ,MethodSent ,Output ,InvoiceTotal ,PayerBalance ,WhereTreated ,Record_Created_By ,Record_Created_Date ,Record_Modified_By ,Record_Modified_Date ) VALUES ( '#GetData.Pay_ID#' ,'#session.agencyid#' ,'#GetData.Patient_ID#' ,'#GetData.Assmt_ID#' ,NOW() ,'PDF' ,'PDF' ,#invoiceTotal# ,#invoiceTotal# ,"" ,'#Session.EmployeeId#' ,#now()# ,'#Session.EmployeeId#' ,#now()# ) SELECT LAST_INSERT_ID() as LastInsertID INSERT INTO #Request.prefix_db_agency#.Payments ( Invoice_ID ,PatientPayer_ID ,PaymentDate ,Amount ,PaymentMethod ,WriteOffAmount ,WriteOffType ,Record_Created_By ,Record_Created_Date ,Record_Modified_By ,Record_Modified_Date ) VALUES ( '#Last_Invoice_ID.LastInsertID#', '#GetData.Pay_ID#', #CreateODBCDateTime(Now())#, '0.00', 'Electronic', '0.00', '0.00' ,'#Session.EmployeeId#' ,#now()# ,'#Session.EmployeeId#' ,#now()# )
#UCase(getTimeZone.Agency_Name)#
 Invoice
#UCase(getTimeZone.Agency_Address1)#
#UCase(getTimeZone.Agency_City)# #UCase(getTimeZone.Agency_State)# #getTimeZone.Agency_Zip#
Date Invoice#
#DateFormat(now(),"mm/dd/yyyy")# #Last_Invoice_ID.LastInsertID#
Bill To

  #UCase(GetAssessmentTracker.Pt_First)# #UCase(GetAssessmentTracker.Pt_Last)#
  #UCase(GetAssessmentTracker.Pt_Street)#
  #UCase(GetAssessmentTracker.Pt_City)# #GetAssessmentTracker.Pt_State# #GetAssessmentTracker.Pt_Zip#
Visit Type Quantity Date Rate Time In Time Out Amount
#Trim(GetData.Skill)# - #Trim(GetData.Description)#
 #NumberFormat(TotalHours,'_____.__')# Hour(s)
 #DateFormat(GetData.Visit_Date,"mm/dd/yyyy")#
 #Trim(GetData.EClaim_Price)#
 #timeformat(GetData.StartTime,'hh:mm:ss tt')#
 #timeformat(GetData.EndTime,'hh:mm:ss tt')#
 #NumberFormat(GetData.Total_EClaim,'_____.__')#
Total
$#NumberFormat(invoiceTotal,'_____.__')#
Phone# Fax# E-mail
(#areaCode#) #firstThree#-#lastFour# (#areaCode#) #firstThree#-#lastFour# #getTimeZone.Agency_Contact_Email#
UPDATE #Request.prefix_db_agency#.pSchedules SET EClaimed = 1, Invoice_ID = #invoiceid#, Export_Date = #CreateODBCDateTime(Now())# WHERE Schedule_ID in (#GetData_Schedule_ID#) AND Assmt_ID = #GetAssessmentTracker.Assmt_ID#
Page #cfdocument.currentpagenumber#