Soft delete existing Austin Transportation Department and Public Works rows in moped_fund_sources table
Create a new row called Austin Transportation and Public Works
Update existing moped_proj_funding records that have funding_source_id set to either the ids for ATD or Public Works to be the id for the new Austin Transportation and Public Works id
This should show as an update in the project activity log so users can audit what changed
Double check that we aren't showing soft-deleted funding sources in the app anywhere
Out of Scope
Creating a special activity log entry to capture this event. The existing activity event that captures editing the funding source is great.
To reflect the reorganization in the funding sources table, we need to update the lookups to show that ATD and Public Works merged to create TPW. Here is the SchemaSpy page to see the table relationships - https://db-docs.austinmobility.io/atd-moped-production/tables/moped_fund_sources.html.
In Scope
moped_fund_sourcestablemoped_proj_fundingrecords that havefunding_source_idset to either the ids for ATD or Public Works to be the id for the new Austin Transportation and Public Works idOut of Scope