Skip to content

Implement Fee Schedule History (table, trigger, and backfill of 2025-01-03 snapshot) #32830

@Jxio

Description

@Jxio

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    PayWork for Pay Team

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions