SELECT Patient_ID, Last_Name_M0040 AS Last_Name, First_Name_M0040 AS First_Name, Middle_Initial_M0040 AS Middle FROM #Request.prefix_db_agency#.patient WHERE Patient_ID = #session.cs.patientid# AND Agency_ID = #session.AgencyID# SELECT PatientPayer_ID,patientpayer.Payer_ID,Patient_ID,InsuredIDNumber,InsuredName,RelationShip_to_Insured ,insured_street,insured_city,insured_state,insured_zip,insured_dob,insured_gender,HealthBenefitPlan,FamilyPlan,PayName,PriorAuthorization from #Request.prefix_db_agency#.patientpayer,#Request.prefix_db_agency#.Payer Where Patient_ID = #session.cs.patientid# and patientpayer.payer_id=Payer.payer_id and patientpayer.Payer_ID <> 0 order by PatientPayer_ID asc

pm = CreateObject("Component", "PatientMenu"); pm.getPatientMenu(#session.cs.PatientId#);

#getP.Last_Name#, #getP.First_Name# #getP.Middle# - Payers List

Add New PatientPayer

PayerName	Insured's Name	Insured's Number	Prior Authorization
#PayName# #PayName#	#InsuredName#	#InsuredIDNumber#	select count(Benefit_ID) as Benefitcount from #Request.prefix_db_agency#.benefits where payer_ID=#GetPatientPayer.Payer_ID# Prior Authorization Prior Authorization
No PatientPayer Records for #getP.Last_Name#, #getP.First_Name# #getP.Middle#