Update FABS/FPDS data for the updated agencies

Description

A/C:

  • Come up with SQL to update FABS and FPDS such that

    • any records under FREC 1130 are now associated with the CGAC 164

    • any records under FREC 1136 are now associated with the CGAC 166

    • update the awarding_agency_code
      and funding agency code

  • update the updated_at such that they will be repulled by USAS

  • Update the Deploy Coordination document associated with this sprint to include this step for the real deployment

Not user testable

Activity

Show:
Alisa Burdeyny
April 28, 2021, 3:57 PM
Edited

While the above is more than sufficient for our purposes in this ticket, if we ever have to update a larger agency, the queries below would be more efficient overall, simply not necessary for such small agencies though.

Alisa Burdeyny
April 28, 2021, 3:47 PM
Edited

One query for each of the tables:

Epic Link

Sprint

Assignee

Alisa Burdeyny

Reporter

Daniel Boos

Components

Labels

Priority

Medium

Story Points

3