Recategorization of CORPS OF ENGINEERS - CIVIL WORKS (USACE) as DEPARTMENT OF DEFENSE (DOD)
- 8 days ago
I'm working on replicating an analysis on Army Corps of Engineers contracts we did a couple of years ago. We have the old files we pulled in July 2019 and the new ones I just pulled this week, July 2021. I used a FY2012 file as an example, and it looks like the vast majority of contracts that had funding agency CORPS OF ENGINEERS - CIVIL WORKS (USACE) in the 2019 data have been recategorized and now have funding agency DEPARTMENT OF DEFENSE (DOD) in the current, 2021 data (using "contract_transaction_unique_key" to match on).
Why was this change made? Is there a different variable that indicates which contracts are (and/or were) USACE funded?
- 6 days ago
Have you tried looking at the awarding_sub_agency / funding_sub_agency. (The latter is blank unless different from the awarded, but important if you want to distinguish funding).
I think there was some evolution in the granularity of the agency code used in the contract_transaction_unique_key, which may be the source of the discrepancy. However, the fields I mentioned are more detailed and should break out USACE consistently.0Comment actions
- 6 days ago
Yes, the funding_ and awarding_ sub_agency_name/code appears to just be Dept. Of the Army. So, still no clarity on which contracts once were/might still be categorized as USACE but no longer are.
Is there any documentation on why, when, or how this change was made? Which contracts were recategorized and why? If there might be some other variable that indicates when the USACE is involved in/funding a project?
Please sign in to leave a comment.