You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Introduce Fee Schedule History so that fee schedule changes are auditable:
add a history table and trigger to record changes going forward, and backfill the table with the 2025-01-03 snapshot produced in #32829.
Scope
Database (migration)
Create Fee Schedule History table (schema and columns as per design).
Add trigger(s) on the relevant fee schedule table(s) to insert/update history rows on INSERT/UPDATE/DELETE.
Backfill
After the migration is deployed to the target environment, run a one-time load to insert the data from Ticket 32829 export into the history table, with effective/snapshot date 2025-01-03, as the first historical records.