SELECT IFNULL(MAX(PtPayer_ID),0)+1 As pPtPayer_ID FROM #Request.prefix_db_agency#.pPtPayer SELECT IFNULL(MAX(Elig_ID),0)+1 As pElig_ID FROM #Request.prefix_db_agency#.Eligibility SELECT Sub_HIC FROM #Request.prefix_db_agency#.pPtPayer WHERE PtPayer_ID = AND Patient_ID = AND Status = LIMIT 1 SELECT * FROM #Request.prefix_db_agency#.Eligibility WHERE Patient_ID = AND PtPayer_ID = AND Status = SELECT Pay_ID, Loc_ID, Status, Output, Payer_No, Submitter_ID, Receiver_ID, Pay_Name, Pay_Street, Pay_City, Pay_State, Pay_Zip, Pay_Phone, Pay_Contact, Identification_Code_Qualifier, Agency_Biller, Biller_First, Biller_Type, Biller_Last_or_Company, Biller_NPI, Biller_Submitter_ID, Pay_Website, Web_User, Web_Pass FROM #Request.prefix_db_agency#.pPayer WHERE Pay_ID = AND Status = ~" & chr(13)& chr(10) & "GS*HS*#Receiver_ID#*#Receiver_ID#*#DateFormat(NOW(),"yymmdd")#*#creationtime#*#getTimeZone.Natl_Provider_ID#*X*005010X279A1~"& chr(13)& chr(10) & "ST*270*#Eligiunique_ID#*005010X279A1~"& chr(13)& chr(10) & "BHT*0022*13*#Eligiunique_ID#*#creationdate#*#creationtime#~"& chr(13)& chr(10) & "HL*1**20*1~" & chr(13)& chr(10)> Insert Into #Request.prefix_db_agency#.Eligibility (Patient_ID, PtPayer_ID, Status,batch, line270,Verification_Date, Notes, Date_Create, Created_by, Date_Change, Change_by) VALUES ( , , , , , , , , , , ) Please find below error when we send eligibility file into Innovalon due to FTP connection error
FTP Error: #errorMessage#
Error Details: #errorDetail#
UPDATE #Request.prefix_db_agency#.Eligibility SET line270 = , Date_Change = , Change_by = WHERE Patient_ID = AND PtPayer_ID = SELECT IFNULL(MAX(PtPayer_ID),0)+1 As pPtPayer_ID FROM #Request.prefix_db_agency#.pPtPayer UPDATE #Request.prefix_db_agency#.pPtPayer SET Status = , Record_Mod_Date = , Change_by = Where PtPayer_ID = Insert Into #Request.prefix_db_agency#.pPtPayer (PtPayer_ID,Patient_ID, Status, Payer_ID, Pt_Relationship,Sub_HIC, Sub_First, Sub_Last, Sub_Mid, Sub_Street, Sub_City, Sub_State, Sub_Zip, Sub_Gender, Sub_DOB, Plan_Program, Plan_type,MSP_code, Policy_Group_Number, Policy_Group_Name, Payer_Responsibility, Util_Force, Deductible_Amount, Deductible_Met, Copay_Amount, OP_Amount, OP_Amount_Met, Coinsurance, Date_Start, Date_End, Part_A_Start, Part_A_Term, Part_B_Start, Part_B_Term, Deductible_Out_Net, Deductible_Remaining, Copay_Out_Net, OP_Out_Net, OP_Remaining, Coinsurance_Out_Net, Record_Creation_Date, Created_by, Record_Mod_Date, Change_by) VALUES ( , , , , , , , , , , , , , , , , , , , , , , , , , , , , , NULL, , NULL, , , , , , , , , , , , , , ) UPDATE #Request.prefix_db_agency#.pPtPayer SET Status = 2 Where PtPayer_ID = '#Trim(url.PPID)#'