INSERT IGNORE INTO #Request.prefix_db_agency#.claim_bill (Type_of_Bill , Assignment_Accept ,Submitter_ID,Receiver_ID,PayName,Payer_Number,PayAdd1 ,PayCity,PayState,PayZip ,Referring_PNPI,MSA_Code, Agency_Name,Agency_State,Agency_ZIP,Agency_City,Agency_Address1,Agency_Contact_Phone,Agent_FEIN,ANPI,HI_Claim_Number,Agency_Assigned_ID,First_Name_M0040, Last_Name_M0040, State_M0050,Admission_Status,Zip_M0060,City, Street_Address ,Telephone ,DOB_M0066,Gender_M0069,Certification_Start,Certification_End , Start_of_Care_M0030,Source_of_Admission ,Assessment_Reason_M0100,Claim_Key,HHRG_175_Score,HHRG_230_Score,HHRG_250_Score,HHRG_390_Score ,HHRG_420_Score,HHRG_440_Score ,Referring_FirstName ,Referring_LastName, Invoice_ID) VALUES ('#Trim(form.TOB)#', '', '#Trim(form.Submitter_ID)#', '#Trim(form.Receiver_ID)#', '#Trim(form.PayName)#', '#Trim(form.Payer_Number)#', '#Trim(form.PayAdd1)#', '#Trim(form.PayCity)#', '#Trim(form.PayState)#', '#Trim(form.PayZip)#', '', '#Trim(form.MSA_Code)#', '#Trim(form.Agency_Name)#', '#Trim(form.Agency_State)#', '#Trim(form.Agency_ZIP)#', '#Trim(form.Agency_City)#', '#Trim(form.Agency_Address1)#', '#Trim(form.Agency_Contact_Phone)#', '#Trim(form.Agent_FEIN)#', '#Trim(form.Natl_Provider_ID)#', '#Trim(form.HI_Claim_Number)#', '#Trim(form.agency_assigned_id)#', '#Trim(form.firstname)#', '#Trim(form.lastname)#', '#Trim(form.State_M0050)#', '#Trim(form.Admission_Status)#', '#Trim(form.Zip_M0060)#', '#Trim(form.City)#', '#Trim(form.Street_Address)#', '#Trim(form.phone)#', #CreateODBCDate(form.DOB_M0066)#, '#Trim(form.gender)#', #CreateODBCDate(form.Certification_Start)#, #CreateODBCDate(form.Certification_End)#, #CreateODBCDate(form.Start_of_care_M0030)#, '#Trim(form.Source_of_Admission)#', '#Trim(form.Assessment_Reason_M0100)#', '#Trim(form.Claim_Key)#', '#Trim(form.HHRG_175_Score)#' , '#Trim(form.HHRG_230_Score)#', '#Trim(form.HHRG_250_Score)#', '#Trim(form.HHRG_390_Score)#', '#Trim(form.HHRG_420_Score)#', '#Trim(form.HHRG_440_Score)#', '#Trim(form.First_Name)#', '#Trim(form.Last_Name)#', '#url.inv#') UPDATE #Request.prefix_db_agency#.claim_bill SET Type_of_Bill = '#Trim(form.TOB)#', Agency_Name ='#Trim(form.Agency_Name)#', Agency_State = '#Trim(form.Agency_State)#', Agency_ZIP = '#Trim(form.Agency_ZIP)#', Agency_City = '#Trim(form.Agency_City)#', Agency_Address1 = '#Trim(form.Agency_Address1)#', Agency_Contact_Phone = '#Trim(form.Agency_Contact_Phone)#', Agent_FEIN = '#Trim(form.Agent_FEIN)#', ANPI ='#Trim(form.Natl_Provider_ID)#', HI_Claim_Number = '#Trim(form.HI_Claim_Number)#', Agency_Assigned_ID = '#Trim(form.agency_assigned_id)#', First_Name_M0040 = '#Trim(form.firstname)#', Last_Name_M0040 = '#Trim(form.lastname)#', State_M0050 = '#Trim(form.State_M0050)#', Admission_Status = '#(form.Admission_Status)#', Zip_M0060 = '#Trim(form.Zip_M0060)#', City = '#Trim(form.City)#', Street_Address = '#Trim(form.Street_Address)#', Telephone = '#Trim(form.phone)#', DOB_M0066 = #CreateODBCDate(form.DOB_M0066)#, Gender_M0069 = '#Trim(form.gender)#', Certification_Start = #CreateODBCDate(form.Certification_Start)#, Certification_End = #CreateODBCDate(form.Certification_End)#, Start_of_Care_M0030 = #CreateODBCDate(form.Start_of_care_M0030)#, Source_of_Admission = '#Trim(form.Source_of_Admission)#', Assessment_Reason_M0100 = '#Trim(form.Assessment_Reason_M0100)#', Claim_Key = '#Trim(form.Claim_Key)#', HHRG_175_Score = '#Trim(form.HHRG_175_Score)#' , HHRG_230_Score = '#Trim(form.HHRG_230_Score)#', HHRG_250_Score = '#Trim(form.HHRG_250_Score)#', HHRG_390_Score = '#Trim(form.HHRG_390_Score)#', HHRG_420_Score = '#Trim(form.HHRG_420_Score)#', HHRG_440_Score = '#Trim(form.HHRG_440_Score)#', Referring_FirstName = '#Trim(form.First_Name)#', Referring_LastName = '#Trim(form.Last_Name)#' WHERE Invoice_ID = '#url.inv#' AND ID = '#form.IDS#' SELECT DISTINCT rc.Rev_Code,si.Visit_Type,rc.HCPCS,si.Visit_Date,si.Total_Units,si.Total_Eclaim ,si.Schedule_ID,i.Output AS Output_Type FROM #Request.prefix_db_agency#.Invoices i JOIN #Request.prefix_db_agency#.pSchedules si ON si.invoice_id = i.invoice_id RIGHT OUTER JOIN #Request.prefix_db_agency#.pRevenue_Code rc on rc.Rev_CodeID = si.Rev_ID WHERE i.invoice_id = '#url.inv#' AND i.Agency_ID = '#session.agencyid#' AND si.status = 0 UPDATE #Request.prefix_db_agency#.pSchedules SET Skill = '#form.Visit_Type#', Visit_Date = '#DateFormat(form.Visit_Date,"yyyy-mm-dd")#', Total_Units = '#form.Total_Units#', Total_Eclaim = '#form.Total_Eclaim#' WHERE Schedule_ID = '#GETSID.Schedule_ID#' UPDATE #Request.prefix_db_agency#.pSchedules SET Skill = '#VT#', Visit_Date = '#DateFormat(VD,"yyyy-mm-dd")#', Total_Units = '#TTU#', Total_Eclaim = '#TTE#' WHERE Schedule_ID = '#ID#' UPDATE #Request.prefix_db_lookup#.Supply_Sched SET Revenue_Code = '#Revenue_Code#', HCPCS = '#HCPCS#', Visit_Date = '#DateFormat(Visit_Date,"yyyy-mm-dd")#', Total_Units = '#Total_Units#', Total_Price = '#Total_Price#' WHERE Supply_Sched_ID = '#Supply_Sched_ID#' UPDATE #Request.prefix_db_agency#.Invoices SET InvoiceTotal = '#Trim(form.InvoiceTotal)#', TOB = '#Trim(form.TOB)#', Error_description = '#Trim(form.Error_description)#', Comment = '#Trim(form.Error_description)#', Record_Modified_By = '#Session.EmployeeId#', Record_Modified_Date = #now()# where invoice_id='#url.inv#' select 0 AS TurboClaim,p.Pay_ID from #Request.prefix_db_agency#.pPayer p JOIN #Request.prefix_db_agency#.Invoices i on i.PatientPayer_ID = p.Pay_ID where i.invoice_id = '#url.inv#'
HEALTH INSURANCE UB04 CLAIM FORM

Your changes have been Successfully Updated!!

Need to Resubmit Claim? Click Upload button.
 Go to Rejected claim Go to Claim Awaiting Payment