SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = SELECT svc_eligibility FROM #Request.prefix_db_lookup#.Agency WHERE Agency_ID = LIMIT 1 SELECT p.*,pp.PtPayer_ID, py.Pay_Name, pp.Payer_Responsibility FROM #dbAgencyQuoted#.pPatients p JOIN #dbAgencyQuoted#.pPtPayer pp ON pp.Patient_ID = p.Patient_ID JOIN #dbAgencyQuoted#.pPayer py ON pp.Payer_ID = py.Pay_ID WHERE p.Status IN (0,1,4) AND pp.status = 0 AND pp.SUB_HIC = AND trim(p.Pt_Last) = AND trim(p.Pt_First) = order by pp.Payer_Responsibility ASC filearray -
enddate_array -
Pay_No - #Pay_No#
Patient_ID - #getpatients.Patient_ID#Not Found
Sub_HIC - #Sub_HIC#
eligibility_start_date - #eligibility_start_date#
eligibility_end_date - #eligibility_end_date#
PRP - #PRP#
primarypayer - #primarypayer#
foundpayer - #foundpayer#
payername - #payername#
pay_name - #getpatients.Pay_Name#Not Found
alert_message- #alert_message#
PartA_B - #PartA_B#
Part_A_Start - #Part_A_Start#
Part_B_Start - #Part_B_Start#
Query Record Count - #getpatients.recordcount#0 (Query not executed)
UPDATE #dbAgencyQuoted#.pPtPayer SET Eligi_messages = '#alert_message#'NULL WHERE PtPayer_ID IN (#PtPayer_IDs#) AND status = '0' SELECT Elig_ID FROM #dbAgencyQuoted#.Eligibility WHERE Patient_ID = AND PtPayer_ID = AND IFNULL(DATE_FORMAT(Verification_Date, '%Y-%m-%d'), '') = AND IFNULL(DATE_FORMAT(Start_Date, '%Y-%m-%d'), '') = AND IFNULL(DATE_FORMAT(Expiration_Date, '%Y-%m-%d'), '') = ORDER BY Elig_ID DESC LIMIT 1 INSERT IGNORE into #dbAgencyQuoted#.Eligibility ( Patient_ID, PtPayer_ID, Status, line270, line271,batch, Verification_Date, Start_Date, Expiration_Date, Notes, Date_Create, Created_by, Date_Change, Change_by) VALUES ('#Patient_ID#','#ptpayer_id#', #Eligibility_status#, '#fileContent#',NULL,1, '#Verification_Date#', '#Part_A_Start#','#eligibility_start_date#', '#eligibility_end_date#', 'Automated eligibility', #now()#, #session.employeeid#, #now()#, #session.employeeid#) SELECT LAST_INSERT_ID() as LastInsertID SELECT Elig_ID FROM #dbAgencyQuoted#.Eligibility_Detail WHERE Elig_ID = AND IFNULL(DATE_FORMAT(Date_Start, '%Y-%m-%d'), '') = AND IFNULL(DATE_FORMAT(Date_End, '%Y-%m-%d'), '') = AND IFNULL(Sub_HIC, '') = LIMIT 1 INSERT IGNORE into #dbAgencyQuoted#.Eligibility_Detail ( Elig_ID, Status, Date_Start, Date_End, Duration, Rev_CodeID, Sub_HIC, Sub_Gender, Sub_DOB, Plan_Program, Plan_type, Policy_Group_Number, Policy_Group_Name, Deductible_Amount, Deductible_Met, Copay_Amount, OP_Amount, OP_Amount_Met, Coinsurance, valid_submission, Error_code, Rejection_code, Eligibility_date, Eligibility_time, Date_Create, Created_by, Date_Change, Change_by) VALUES ('#Elig_ID#',0,'#Part_A_Start#''#eligibility_start_date#'NULL, '#eligibility_end_date#'NULL,NULL,0,'#SUB_HIC#', '#Sub_Gender#','#Sub_DOB#', '#Plan_Program#','#Plan_type#','#Policy_Group_Number#','#Policy_Group_Name#', '#Deductible_Amount#','#Deductible_Met#','#Copay_Amount#','#OP_Amount#', '#OP_Amount_Met#','#Coinsurance#','#valid_submission#','#Error_code#','#Rejection_code#', "#Eligibility_date#", "#Eligibility_time#", #now()#, #session.employeeid#, #now()#, #session.employeeid#) UPDATE #dbAgencyQuoted#.pPtPayer SET Date_Start = '#eligibility_start_date#', Date_End = '#eligibility_end_date#', Part_A_Start = '#Part_A_Start#', Part_B_Start = '#Part_B_Start#', Plan_type = '#Plan_type#', Eligi_messages = '#alert_message#'NULL, Deductible_Amount = '#Deductible_Amount#', Deductible_In_Net = '#Deductible_In_Net#', Deductible_Out_Net = '#Deductible_Out_Net#', Deductible_Remaining = '#Deductible_Remaining#', Deductible_Met = '#Deductible_Met#', OP_Amount = '#OP_Amount#', OP_In_Net = '#OP_In_Net#', OP_Out_Net = '#OP_Out_Net#', OP_Remaining = '#OP_Remaining#', OP_Amount_Met = '#OP_Amount_Met#', Copay_Amount = '#Copay_Amount#', Copay_In_Net = '#Copay_In_Net#', Copay_Out_Net = '#Copay_Out_Net#', Coinsurance = '#Coinsurance#', Coinsurance_In_Net = '#Coinsurance#', Coinsurance_Out_Net = '#Coinsurance#' WHERE PtPayer_ID = '#ptpayer_id#' AND status = '0'