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
This is a follow-up to
#1794 - which it builds
upon.
## Summary
Fixes#1746
### Time to review: __10 mins__
## Changes proposed
Adds transformation logic for the assistance listing (formerly CFDA)
tables.
## Context for reviewers
The transformations are pretty uneventful, the only complexity is that
the legacy Oracle database doesn't have a foreign key between the
`TopportunityCfda` table and the `Topportunity` table and there are
~2300 orphaned cfda records that we wouldn't be able to import, so we
additionally need to validate that the opportunity exists when we try to
transform the data, and if not, we just mark it as "transformed" and do
nothing with it.
There is some basic work on relationships between the staging tables +
more factories for setting up the data which will be ongoing /
@jamesbursa is also looking into.
---------
Co-authored-by: nava-platform-bot <platform-admins@navapbc.com>
Summary
Handles transforms for the assistance listing table
https://app.gitbook.com/o/cFcvhi6d0nlLyH2VzVgn/s/v1V0jIH7mb7Yb3jlNrgk/engineering/learnings/opportunity-endpoint-data-model#opportunity-assistance-listing
Acceptance criteria
No response
The text was updated successfully, but these errors were encountered: