search

makegov / tango-public

Issue reporting for Tango.
2 stars 0 forks source link

Entities and Bulk Entities Endpoint Has Incorrect Awards Summary Data #8

Open Danlobaton opened 1 month ago

Danlobaton commented 1 month ago

Describe the bug
The /entities/${uei} and /entities/bulk endpoints return either a list of entities or a single entity. Each entity contains an awards_summary nested object. Upon review, we noticed that the data in the awards_summary does not match what we retrieve from the Tango contracts and subawards endpoints.

For example, the entity response for Visual Connections (UEI P6C4HFH2RBB3) from Tango shows discrepancies when compared with the awards data. When summing the total field for each agency's prime_awards under this entity, the total is under $100 million. However, using the /contracts endpoint in Tango to calculate the obligated amounts for Visual Connections results in approximately $115.2 million.

Steps to Reproduce

  1. Request the /entities/bulk response.
  2. In the response, locate the Visual Connections entity with UEI P6C4HFH2RBB3.
  3. Sum the total field under the prime_awards object for each agency.
  4. The result will be around $54 million instead of the expected $115.2 million.

Expected behavior
The awards_summary totals should align with the obligated amounts retrieved from the Tango /contracts endpoint for the same entity.

Screenshots
If applicable, add screenshots to illustrate the discrepancy.

Additional context
Please provide further details on the data source used for calculating the prime award totals, as this discrepancy significantly impacts reporting accuracy.

A similar issue happens when we add up the dollar amounts for the subcontracts of the entity response.

vdavez commented 1 month ago

Thanks @Danlobaton! I'll investigate this one.