SELECT Distinct Payer_ID, PayName FROM #Request.prefix_db_agency#.Payer WHERE Agency_ID = #session.AgencyID# AND PayerStatus = 'active' ORDER BY PayName SELECT StateName, StateAbbr FROM #Request.prefix_db_lookup#.States ORDER BY StateName

New Patient Payer Information

Update Patient Payer Information

SELECT Patient_ID,Payer_ID,InsuredIDNumber,Insured_PolicyNumber,InsuredName,RelationShip_to_Insured,insured_street, insured_city,insured_state,insured_zip,insured_dob,insured_gender,HealthBenefitPlan,FamilyPlan from #Request.prefix_db_agency#.patientpayer Where PatientPayer_ID = '#url.PPID#'

Payer
Insured's Number
Insured's Name
Patient's Relationship
Insured's Policy, group or FECA Number
Insured's StreetAddress
Insured's City
State
Date of Birth
Gender	checked > Male checked > Female
Is there another health benefit plan	Yes No Yes No Yes No
EPSDT/Family Plan (child health component of Medicaid)