usaspending-api icon indicating copy to clipboard operation
usaspending-api copied to clipboard

[PIPE-407/411/412] Additional TransactionSearch Fields (Postgres)

Open dpb-bah opened this issue 2 years ago • 0 comments

Description: Adding transaction normalized/fabs/fpds columns to transaction search. See ticket comment and spreadsheet for details.

Technical details:

  • Does include migration

Requirements for PR merge:

  1. [x] Unit & integration tests updated
  2. API documentation updated
  3. [ ] Necessary PR reviewers:
    • [ ] Backend
    • Frontend <OPTIONAL>
    • Operations <OPTIONAL>
    • Domain Expert <OPTIONAL>
  4. Matview impact assessment completed
  5. Frontend impact assessment completed
  6. [x] Data validation completed
  7. Appropriate Operations ticket(s) created
  8. [x] Jira Tickets
  9. [x] PIPE-407 PIPE-411 PIPE-412:
    • [x] Link to this Pull-Request
    • Performance evaluation of affected (API | Script | Download)
    • Before / After data comparison
  10. [ ] Merged after https://github.com/fedspendingtransparency/usaspending-api/pull/3581

Area for explaining above N/A when needed:

dpb-bah avatar Sep 14 '22 16:09 dpb-bah