SELECT DISTINCT si.Rev_Code,si.Visit_Type,si.HCPCS,si.Visit_Date,si.Total_Units,si.Total_Eclaim ,si.ScheduleItems_ID FROM #Request.prefix_db_agency#.ScheduleItems si WHERE si.invoice_id = '#url.inv#' AND si.Agency_ID = '#session.agencyid#' AND si.deleted = 0 select p.TurboClaim,p.Payer_ID from #Request.prefix_db_agency#.Payer p JOIN #Request.prefix_db_agency#.Invoices i on i.PatientPayer_ID = p.Payer_ID where i.invoice_id = '#url.inv#' SELECT ScheduleItems.ScheduleItems_ID, ScheduleItems.Rev_Code, ScheduleItems.HCPCS, ScheduleItems.Visit_Date, ScheduleItems.Total_Units, ScheduleItems.Total_EClaim, ScheduleItems.Payer_ID, ScheduleItems.Assessment_Tracker_ID FROM #Request.prefix_db_agency#.ScheduleItems WHERE ScheduleItems.ScheduleItems_ID IN () Insert Into #Request.prefix_db_lookup#.Claim (Agency_Id, ScheduleItems_ID, Rev_Code, HCPCS, Total_Units, Visit_Date, Total_EClaim, Assessment_Tracker_ID, Payer_ID, Ticket) values ('#session.AgencyId#', '#ScheduleItems_Id#', '#Rev_Code#', '#HCPCS#', #decimalformat(Total_Units)#, #Visit_Date#, #NumberFormat(Total_EClaim,'_____.__')#, #Assessment_Tracker_ID#, #Payer_ID#, 1) Insert Into #Request.prefix_db_lookup#.ClaimII (Agency_Id, ScheduleItems_ID) values ('#session.AgencyId#', '#ScheduleItems_Id#') SELECT s.ScheduleItems_ID, s.Revenue_Code, s.HCPCS, s.Total_Units, s.Visit_Date, s.Assessment_Tracker_ID, s.Payer_ID, s.Total_Price, s.Ticket FROM #Request.prefix_db_lookup#.Supply_Sched s, #Request.prefix_db_lookup#.ClaimII c WHERE s.ScheduleItems_ID = c.ScheduleItems_ID and s.Deleted = 0 Insert Into #Request.prefix_db_lookup#.ClaimII (ScheduleItems_ID, Rev_Code, HCPCS, Total_Units, Total_EClaim, Assessment_Tracker_ID, Payer_ID, Ticket) values ('#ScheduleItems_Id#', '#Revenue_Code#', '#HCPCS#', #decimalformat(Total_Units)#,#NumberFormat(Total_Price,'_____.__')#, #Assessment_Tracker_ID#, #Payer_ID#, 1) Insert Into #Request.prefix_db_lookup#.Claim (Agency_Id, ScheduleItems_ID, Rev_Code, HCPCS, Total_Units, Assessment_Tracker_ID, Payer_ID, Total_EClaim, Ticket) SELECT '#session.AgencyId#', ScheduleItems_ID, Rev_Code, HCPCS, Total_Units, Assessment_Tracker_ID, Payer_ID, Total_EClaim, 1 From #Request.prefix_db_lookup#.ClaimII Where Assessment_Tracker_ID != 0 DELETE FROM ClaimII SELECT DISTINCT Claim.ScheduleItems_ID, i.Invoice_ID,i.InvoiceTotal, i.PayerBalance,i.assessment_tracker_id ,i.errors,i.TOB,i.Internal_control_number, i.claim_status,i.Error_description,i.PatientPayer_ID, i.patient_id, ID,claim_bill.Type_of_Bill , Assignment_Accept ,Submitter_ID , Receiver_ID , Agency_Name ,Agent_FEIN , Agency_Contact ,Agency_Contact_Phone , PayName , ANPI,Agency_Address1 ,Agency_City , Agency_State ,Agency_Zip , Last_Name_M0040 ,First_Name_M0040 , HI_Claim_Number ,Street_Address ,City , State_M0050 ,Zip_M0060 ,DOB_M0066 ,Gender_M0069 ,Payer_Number ,PayAdd1 ,PayCity ,PayState ,PayZip ,Certification_start ,claim_bill.Certification_end , Start_of_Care_M0030 ,Source_of_Admission ,Admission_Status ,Claim_Key ,HHRG_175_Score ,HHRG_230_Score ,HHRG_250_Score ,HHRG_390_Score , HHRG_420_Score ,HHRG_440_Score ,MSA_Code ,Referring_LastName as LastName,Referring_FirstName as FirstName ,Referring_PNPI as PNPI ,Certifying_LastName , Certifying_FirstName , Certifying_PNPI,Agency_Assigned_ID,Telephone, Assessment_Reason_M0100 ,(SELECT MIN(Visit_Date) FROM #Request.prefix_db_lookup#.Claim WHERE Agency_Id = '#session.AgencyId#' AND Assessment_Tracker_Id = i.Assessment_Tracker_Id ) AS FirstVisitDate ,(SELECT MIN(Total_Units) FROM #Request.prefix_db_lookup#.Claim WHERE Agency_Id = '#session.AgencyId#' AND Assessment_Tracker_Id = i.Assessment_Tracker_Id ) AS Units,Claim.* FROM #Request.prefix_db_agency#.claim_bill JOIN #Request.prefix_db_agency#.Invoices i ON claim_bill.Invoice_ID = i.Invoice_ID JOIN #Request.prefix_db_lookup#.Claim ON Claim.Assessment_Tracker_Id = i.Assessment_Tracker_ID WHERE i.invoice_id = '#url.inv#' AND i.Agency_ID = '#Session.AgencyId#' AND i.Deleted <> 1 AND i.InvoiceTotal > 0 AND Claim.Total_EClaim > '0.0000' SELECT * FROM #Request.prefix_db_agency#.Assessment_New WHERE Assessment_Tracker_ID = #Getdata.Assessment_Tracker_ID# SELECT * FROM #Request.prefix_db_agency#.Payer WHERE Payer_ID = #Getdata.PatientPayer_ID# ~" & chr(13)& chr(10) & "GS*HC*#GetData.Submitter_ID#*#GetData.Receiver_ID#*#DateFormat(Now(), "YYYYMMDD")#*#DateFormat(Now(), "HHMM")#*#GS06#*X*005010X223A2~" & chr(13)& chr(10) & "ST*837*#ST02#*005010X223A2~" & chr(13)& chr(10) & "BHT*0019*00*00000#YB#*#DateFormat(Now(), "YYYYMMDD")#*#DateFormat(Now(), "HHMM")#*CH~" & chr(13)& chr(10) & "NM1*41*2*#UCase(GetData.Agency_Name)#*****46*#GetData.Agent_FEIN#~" & chr(13)& chr(10) & "PER*IC*#UCase(GetData.Agency_Contact)#*TE*#Left(GetData.Agency_Contact_Phone,3)##Mid(GetData.Agency_Contact_Phone,5,3)##Mid(GetData.Agency_Contact_Phone,9,4)#~" & chr(13)& chr(10) & "NM1*40*2*#UCase(GetData.PayName)#*****46~"& chr(13)& chr(10) & "HL*1**20*1~" & chr(13)& chr(10) & "PRV*BI*PXC*251E00000X~" & chr(13)& chr(10) & "NM1*85*2*#UCase(GetData.Agency_Name)#*****XX*#GetData.ANPI#~" & chr(13)& chr(10) & "N3*#UCase(GetData.Agency_Address1)#~" & chr(13)& chr(10) & "N4*#UCase(GetData.Agency_City)#*#UCase(GetData.Agency_State)#*#GetData.Agency_Zip#~" & chr(13)& chr(10)> A>#Right(GetData.Type_of_Bill,1)#**A*Y*Y*********~"& chr(13)& chr(10) & "DTP*434*RD8*#DateFormat(GetData.Certification_start,"yyyymmdd")#-#DateFormat(GetData.Certification_end,"yyyymmdd")#~"& chr(13)& chr(10) & "DTP*435*DT*#DateFormat(GetData.Start_of_Care_M0030,"yyyymmdd")#0001~"& chr(13)& chr(10) & "CL1*9*#GetData.Source_of_Admission#*#GetData.Admission_Status#~"& chr(13)& chr(10) & "REF*G1*#GetData.Claim_Key#~"& chr(13)& chr(10) & "HI*ABK>#Replace(GetData.HHRG_175_Score, ".", "", "ALL")#~"& chr(13)& chr(10) > #Replace(GetData.HHRG_230_Score, ".", "", "ALL")#*" > #Replace(GetData.HHRG_250_Score, ".", "", "ALL")#*" > #Replace(GetData.HHRG_390_Score, ".", "", "ALL")#*" > #Replace(GetData.HHRG_420_Score, ".", "", "ALL")#*" > #Replace(GetData.HHRG_440_Score, ".", "", "ALL")#~" & chr(13)& chr(10) > 61>>>#GetData.MSA_Code#~"& chr(13)& chr(10) & "NM1*71*1*#UCase(GetData.LastName)#*#UCase(GetData.FirstName)#****XX*#GetData.PNPI#~"& chr(13)& chr(10) & "LX*1~"& chr(13)& chr(10) & "SV2*0023*HP>#Trim(GetAssessments.HIPPS_Code)#*0*UN*#Trim(GetData.Units)#~"& chr(13)& chr(10) & "DTP*472*D8*#DateFormat(GetData.FirstVisitDate,"yyyymmdd")#~"& chr(13)& chr(10) > #Trim(QCode)#*.01*UN*1~"& chr(13)& chr(10) & "DTP*472*D8*#DateFormat(GetData.FirstVisitDate,"yyyymmdd")#~" & chr(13)& chr(10) > SELECT * FROM #Request.prefix_db_agency#.ScheduleItems s JOIN #Request.prefix_db_agency#.Revenue_Code r WHERE s.Rev_CodeID = r.Rev_CodeID AND s.ScheduleItems_ID = #GetData.ScheduleItems_ID# #Trim(GetData.HCPCS)#*#Trim(NumberFormat(GetData.Total_EClaim,'_____.__'))#*UN*#NumberFormat(TotalUnits)#~"& chr(13)& chr(10) & "DTP*472*D8*#DateFormat(GetData.Visit_Date,"yyyymmdd")#~"& chr(13)& chr(10)> Select s.ScheduleItems_ID, s.Invoice_Id,s.Patient_ID, s.Assessment_Tracker_ID, s.Payer_ID, s.Agency_ID, (Select Amount from #Request.prefix_db_agency#.Payments where Invoice_ID = s.Invoice_ID limit 1) as Paid, (Select PaymentDate from #Request.prefix_db_agency#.Payments where Invoice_ID = s.Invoice_ID limit 1) as PaymentDate, (select PayerBalance from #Request.prefix_db_agency#.Invoices where Invoice_ID = s.Invoice_ID limit 1) AS PayerBalance from #Request.prefix_db_agency#.ScheduleItems s where s.ScheduleItems_ID in(#Form.ScheduleItems_ID#) order by Patient_ID asc select distinct(scheduleitems_id) from GetData UPDATE #Request.prefix_db_agency#.Invoices SET DateSent = NOW(), MethodSent = 'Electronic', InvoiceTotal = #invoiceTotal#, PayerBalance = 0.00, Internal_control_number = '#CONTROL#' ,Record_Modified_By = '#Session.EmployeeId#' ,Record_Modified_Date = #now()# WHERE Invoice_ID = #Invoice_ID# SELECT * FROM #Request.prefix_db_agency#.Payments WHERE Invoice_ID = '#Invoice_ID#' UPDATE #Request.prefix_db_agency#.Payments SET PaymentDate = #CreateODBCDateTime(Now())#,#CreateODBCDateTime(Now())#, Amount = #Pad#, 0.00, PaymentMethod = 'Electronic', WriteOffAmount = '0.00', WriteOffType = '0.00', Internal_control_number = '#CONTROL#' ,Record_Modified_By = '#Session.EmployeeId#' ,Record_Modified_Date = #now()# WHERE Invoice_ID = #Invoice_ID# Update #Request.prefix_db_agency#.Invoices SET claim_status = 'Waiting' ,Record_Modified_By = '#Session.EmployeeId#' ,Record_Modified_Date = #now()# WHERE Invoice_ID = #Invoice_ID# UPDATE #Request.prefix_db_agency#.ScheduleItems SET EClaimed = 1 ,EClaimed_Final = 1 ,Invoice_ID = #Invoice_ID# ,Export_Date = #CreateODBCDateTime(Now())# WHERE ScheduleItems_ID IN (#thelist#) AND Assessment_Tracker_ID = #Assessment_Tracker_ID# select distinct(scheduleitems_id) from GetData UPDATE #Request.prefix_db_agency#.ScheduleItems SET EClaimed = 1, EClaimed_Final = 1, Nonbillable = 0, Export_Date = #CreateODBCDateTime(Now())# WHERE ScheduleItems_ID IN (#thelist#) DELETE FROM #Request.prefix_db_lookup#.Claim WHERE Claim.Agency_Id = '#session.AgencyId#'

Turbo Claims Export

Once again Files Submitted by TurboClaim!!

Final Claim Visits Ready for Export to PC-ACE

No Final Claim visits ready