SELECT *
FROM #Request.prefix_db_agency#.Payer
WHERE Payer_Id = '#url.Id#'
SELECT StateName, StateAbbr
FROM #Request.prefix_db_lookup#.States
ORDER BY StateName
SELECT Agency_ID, Agency_Name
FROM #Request.prefix_db_lookup#.Agency
WHERE Agency_ID = #url.AID#
SELECT Authority_Level as AuthorityLevelID, AuthorityLevelDesc
FROM #Request.prefix_db_lookup#.AuthorityLevels
Payer Information
Change Payer Information
Agency: #getA.Agency_Name#
MHCB BILLS THIS PAYER MHCB does not bill this payer.