Migrate CANs from MAPS

[johndeange]

User Story

As a budget team member, I would like to have the CANs that are/were present in MAPS available in OPS in order to manage them effectively within OPS.

Acceptance Criteria

• [ ] A point-in-time snapshot of CAN tuples that are in the MAPS Oracle DB are available in one schema or another in the OPS Postgres DB using guidelines from OPRE about which attributes should persist or be dropped
• [ ] Additional CAN data is able to be provided by OPRE in a spreadsheet and imported into OPS by some manner allowing for any extra attributes of an OPS CAN
• [ ] If the CAN already exists in OPS, then the ingestion process should update the CAN instead of creating a new one.

---

Tasks

UX

Dev

• [x] #2657
• [x] #2658
• [x] #2662
• [ ] #2659
• [ ] #2660
• [ ] #2661

Definition of Done Checklist

• [ ] UI works as designed (UX team)
• [ ] PR(s) have been merged to main
• [ ] Design/tech debt eliminated
• [ ] New design/tech debt documented (if applicable)
• [ ] Build process updated
• [ ] Documentation updated or added ~- [ ] Feature flags/toggles created~

Additional Context & Resources

[jonnalley]

@johndeange should we specify something in the AC that alludes to upserting such that we don't have duplicate data or concurrency issues if repeated iterations of the migration are executed ?