Note: Only BriteCore staff can access the database.
When a Rate Chain references a Line Item that had its name changed, you need to find and replace the name.
Find all instances of the name
To find all instances of the name, run the following script:
select policy_type_items.id, policy_types.name, effectiveDate, policy_type_items.name, policy_type_items.rateChain
join policy_types on policy_types.id = policy_type_items.policyTypeId
join effective_dates on effective_dates.id = policy_types.effectiveId
where rateChain like ‘%Coverage M – Med Pay%’
order by policy_type_items.name
Replace the name
To replace the name, run the following script:
For more information, read PR 4920.