Polaris SA allows you to configure things so that you can have patron’s being submitted to collections without having a collection agency fee applied to their account.
Although there are some instances where this might be desired, you should still consider checking for misconfigurations. Especially since during COVID many libraries adjusted their policies and in changing them back they may have missed an important option.
This SQL helps you check for those instances:
select *
from (
SELECT OrganizationID
FROM polaris.polaris.organizationspppp op
JOIN polaris.polaris.collectionagencyfees caf
ON caf.orgid = op.organizationid
WHERE op.attrid = 1365 -- CA Minimum balance
AND op.organizationid IN (SELECT organizationid
FROM polaris.polaris.organizationspppp
WHERE attrid = 1359
AND value = 'Yes') -- CA Enabled
AND caf.minamount > op.value
union all
select 0
) d
order by d.OrganizationID desc