DB lookup during ingestion of CANBACs

[johndeange]

User Story

As a Budget Team Member, I do not want to duplicate data in the CAN spreadsheets when ingesting the CANBACs.

Acceptance Criteria

• When ingesting the a table of CAN data, if the row in the spreadsheet has empty values for OPRE-added fields, e.g. portfolio or funding partner, then look for a CANFundingDetails record in the database with the same "allotment" and "allowance" and if a record is found, use its values to populate the empty OPRE-added fields.

---

Tasks

UX

Dev

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

• Any additional information that would be useful to share about this work
• Dependencies, constraints?
• Info already known or found, previous work that's been done?