Replace names in rate_chain

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,, effectiveDate,, policy_type_items.rateChain

from policy_type_items

join policy_types on = policy_type_items.policyTypeId

join effective_dates on = policy_types.effectiveId

where rateChain like ‘%Coverage M – Med Pay%’

order by

Replace the name

To replace the name, run the following script:


Additional information

For more information, read PR 4920.