search

fedspendingtransparency / usaspending-api

Server application to serve U.S. federal spending data via a RESTful API
https://www.usaspending.gov
Creative Commons Zero v1.0 Universal
310 stars 113 forks source link

[DEV-11488] Add program_activity_name and program_activity_code to Awards, Transactions, and Subawards #4203

Open aguest-kc opened 1 month ago

aguest-kc commented 1 month ago

Description: Adds two new fields (program_activity_names and program_activity_codes) to the Awards, Transactions, and Subawards tables and Elasticsearch indexes.

Technical details: These two new fields are being added to help improve query performance when filtering on program activities and avoid using the database for these searches.

Requirements for PR merge:

  1. [x] Unit & integration tests updated
  2. [x] Necessary PR reviewers:
    • [x] Backend
  3. [x] Data validation completed
  4. [x] Appropriate Operations ticket(s) created
  5. [x] Jira Ticket DEV-11488:
    • [x] Link to this Pull-Request

Area for explaining above N/A when needed:

2. API documentation updated
No API documentation is affected by this change.

4. Matview impact assessment completed
No matviews are affected by this change.

5. Frontend impact assessment completed
The frontend is not impacted by this change.