Lines

Gen 3

Lines

Replace names in rate_chain

Important: Internal only.

Problem

When a Rate Chain references a Line Item that had its name changed, you need to find and replace the name.

Solution

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

from policy_type_items

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:

bin/quickfix_scripts/replace_category_name_reference.py.

Additional information

For more information, read PR 4920.