SELECT Payer.PayName, Agency.Agency_Name, Payer.Output_Type, Payer.Payer_ID
FROM #Request.prefix_db_agency#.Payer, #Request.prefix_db_lookup#.Agency
Where Payer.Agency_ID = Agency.Agency_ID
AND Payer.Output_Type <> 'Medicare'
AND Agency.Status = 'active'
And Agency.QBInUse = 1
AND Payer.QB_Export = 0
Order by Agency_Name
Payer ListSuperadmin Home