request.general = CreateObject("component","components.general.general").init(); plantype_lookup = request.general.get_answers('Plan_type','payer_form'); MSPcode_lookup = request.general.get_answers('MSP_code','payer_form'); PayerResponsibility_lookup_old = request.general.get_answers('Payer_Responsibility','payer_form'); M0150_lookup = request.general.get_answers('M0150','payer_form'); SELECT Distinct Pay_ID, Pay_Name,M0150 FROM #Request.prefix_db_agency#.pPayer WHERE Loc_ID = #session.AgencyID# AND Status = 0 ORDER BY Pay_Name SELECT StateName, StateAbbr FROM #Request.prefix_db_lookup#.States ORDER BY StateName SELECT * FROM #Request.prefix_db_agency#.pPtContacts WHERE Status = 0 ORDER BY Contact_ID DESC SELECT Patient_ID,PtPayer_ID,Status,SUB_HIC,Payer_ID,Sub_First,Sub_Last,Sub_Mid,Pt_Relationship,Sub_Street, Policy_Group_Number,Policy_Group_Name,Payer_Responsibility,MSP_code,M0150,Deductible_Amount,Deductible_Met, Copay_Amount,OP_Amount,OP_Amount_Met,Coinsurance,Date_Start,Date_End, Deductible_In_Net,Deductible_Out_Net,Deductible_Remaining,Copay_In_Net,Copay_Out_Net,OP_In_Net,OP_Out_Net, OP_Remaining,Coinsurance_In_Net,Coinsurance_Out_Net,Part_A_Start,Part_A_Term,Part_B_Start,Part_B_Term, Sub_City,Sub_State,Sub_Zip,Sub_DOB,Sub_Gender,Plan_type,Plan_Program,Util_Force from #Request.prefix_db_agency#.pPtPayer Where PtPayer_ID = 0 AND status < 2 SELECT * from #Request.prefix_db_agency#.pPtPayer Where PtPayer_ID = '#url.PPID#' AND pPtPayer.status < 2 UPDATE #Request.prefix_db_agency#.pPtPayer SET Sub_First = "#GetP.Pt_First#", Sub_Mid = "#GetP.Pt_Middle#", Sub_Last = "#GetP.Pt_Last#", Sub_Street = "#GetP.Pt_Street#", Sub_City = "#GetP.Pt_City#", Sub_State = "#GetP.Pt_State#", Sub_Zip = "#GetP.Pt_Zip#", Sub_Gender = "#GetP.Pt_Gender#", Sub_DOB = '#Dateformat(GetP.Pt_DOB,"yyyy-mm-dd")#' Where PtPayer_ID = '#url.PPID#' AND pPtPayer.status < 2 SELECT Patient_ID,PtPayer_ID,pPtPayer.Status,SUB_HIC,Payer_ID,Sub_First,Sub_Last,Sub_Mid,Pt_Relationship,Sub_Street, Policy_Group_Number,Policy_Group_Name,Payer_Responsibility,MSP_code,pPtPayer.M0150,Deductible_Amount,Deductible_Met, Copay_Amount,OP_Amount,OP_Amount_Met,Coinsurance,Date_Start,Date_End, Deductible_In_Net,Deductible_Out_Net,Deductible_Remaining,Copay_In_Net,Copay_Out_Net,OP_In_Net,OP_Out_Net, OP_Remaining,Coinsurance_In_Net,Coinsurance_Out_Net,Part_A_Start,Part_A_Term,Part_B_Start,Part_B_Term, Sub_City,Sub_State,Sub_Zip,Sub_DOB,Sub_Gender,Plan_type,Plan_Program,Util_Force from #Request.prefix_db_agency#.pPtPayer Where PtPayer_ID = '#url.PPID#' AND pPtPayer.status < 2 SELECT Patient_ID,pPtPayer.Status,PtPayer_ID,Sub_First,Pt_Relationship,Sub_Street,Policy_Group_Number,MSP_code, pPayer.Output,LEFT(pPayer.M0150,1) AS M0150,pPayer.Output, Sub_City,Sub_State,Sub_Zip,Sub_DOB,Sub_Gender,Plan_type,Plan_Program,Pay_Name,0 AS priorAuthorization,pPtPayer.* FROM #Request.prefix_db_agency#.pPtPayer left outer join #Request.prefix_db_agency#.pPayer ON pPayer.Pay_ID = pPtPayer.Payer_ID Where Patient_ID = and pPtPayer.Payer_ID <> 0 and pPtPayer.status < 2 AND pPayer.status = 0 order by Payer_ID asc SELECT * FROM GetAllPatientPayer WHERE PtPayer_ID = '#url.PPID#' SELECT * FROM GetAllPatientPayer WHERE Payer_Responsibility = 'P - Primary' SELECT * FROM GetAllPatientPayer WHERE Payer_Responsibility = 'S - Secondary' SELECT * FROM #Request.prefix_db_lookup#.answer_lookup WHERE answer_label = AND form_type = AND deleted != 1 AND answer NOT IN ('S - Secondary','T - Tertiary') AND answer NOT IN ('P - Primary','T - Tertiary') AND answer NOT IN ('P - Primary','S - Secondary') ORDER BY answer_order,answer_id SELECT * FROM #Request.prefix_db_agency#.pSchedules WHERE PtPayer_ID = '#GetPatientPayer.PtPayer_ID#' AND Invoice_ID = 0 AND status = 0

Alert!

#url.message#

SELECT Eligibility FROM #Request.prefix_db_agency#.pPayer WHERE Pay_ID = AND Status = 0 LIMIT 1 SELECT * FROM #Request.prefix_db_agency#.Eligibility WHERE Patient_ID = #session.cs.patientid# AND PtPayer_ID = #url.PPID# AND Status = 0 AND donot_display =0

Eligibility Required

Please add the Eligibility for this payer

#GetP.Pt_First# #GetP.Pt_Last# - NEW PAYER UPDATE PAYER