This page summarizes federal procurement activity for award 0020 under agency ID 9700 during the last full year. The award recorded 26 actions with total obligated amount of -$1,128,436.47.
Award Number
Award Number 9700 / 0020 Federal Contract Action Summary (Last Year)
Award number 0020 for agency 9700 shows 26 recorded actions in the last full year and net obligations of -$1.13 million.
Total obligated values are shown as reported for the selected analysis window and reflect the exact net amount of -$1,128,436.47.
Agency ID
9700
PIID
0020
Type
Award
Total Obligated
-1.13 million
-1,128,436.47
Actions
26
Average Action Value
-43,401.40
Overview
For the last full year, award 0020 under agency ID 9700 shows a net obligated total of -$1,128,436.47 across 26 actions. The average action value was -$43,401.40, indicating negative net obligation activity across the recorded actions. This page is limited to the provided award and analysis window.
How to use this page
Use this page to review the award-level obligation pattern, action count, and average action value for the last full year. It supports quick comparison with other awards or agency records using the same FPDS query structure.
Top Agencies
SELECT
content__award__purchaserInformation__contractingOfficeAgencyID AS agency_id,
content__award__purchaserInformation__contractingOfficeAgencyID__name AS agency_name,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count,
formatReadableQuantity(sum(content__award__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
content__award__awardID__awardContractID__agencyID = '9700' AND content__award__awardID__awardContractID__PIID = '0020'
AND content__award__purchaserInformation__contractingOfficeAgencyID IS NOT NULL
AND content__award__purchaserInformation__contractingOfficeAgencyID != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
agency_id,
agency_name
ORDER BY total_obligated DESC
LIMIT 10| Agency ID | Agency Name | Total Obligated | Readable | Actions |
|---|---|---|---|---|
| 1700 | DEPT OF THE NAVY | 160,823.00 | 160.82 thousand | 3 |
| 97AK | DEFENSE INFORMATION SYSTEMS AGENCY (DISA) | 1,028.77 | 1.03 thousand | 2 |
| 97ZS | U.S. SPECIAL OPERATIONS COMMAND (USSOCOM) | -204.00 | -204.00 | 1 |
| 9763 | DEFENSE CONTRACT MANAGEMENT AGENCY (DCMA) | -121,457.00 | -121.46 thousand | 4 |
| 5700 | DEPT OF THE AIR FORCE | -197,192.04 | -197.19 thousand | 5 |
| 2100 | DEPT OF THE ARMY | -971,435.20 | -971.44 thousand | 11 |
Insight
Over the last 1 year for PIID 0020 under agency 9700, obligations are concentrated in a small number of component agencies, with the Department of the Navy posting the largest positive total at 160.82 thousand across 3 awards. Most other activity is negative, led by the Department of the Army (-971.44 thousand across 11 awards), followed by the Department of the Air Force (-197.19 thousand) and DCMA (-121.46 thousand), indicating substantial downward adjustments or deobligations outweighing positive funding. Smaller positive obligations appear at DISA (1.03 thousand across 2 awards), while USSOCOM shows a minor negative amount (-204) on a single award.
Top Vendors
SELECT
vendor_name,
cage_code,
total_obligated,
award_count,
formatReadableQuantity(total_obligated) AS total_obligated_readable
FROM
(
SELECT
content__award__vendor__vendorHeader__vendorName AS vendor_name,
ifNull(content__award__vendor__vendorSiteDetails__entityIdentifiers__cageCode, '') AS cage_code,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count
FROM fpds.data
WHERE
content__award__awardID__awardContractID__agencyID = '9700' AND content__award__awardID__awardContractID__PIID = '0020'
AND content__award__vendor__vendorHeader__vendorName IS NOT NULL
AND content__award__vendor__vendorHeader__vendorName != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
vendor_name,
cage_code
)
ORDER BY total_obligated DESC
LIMIT 10| Vendor | CAGE Code | Total Obligated | Readable | Actions |
|---|---|---|---|---|
| AECOM TECHNICAL SERVICES, INC. | 4L767 | 85,823.00 | 85.82 thousand | 2 |
| P & S CONSTRUCTION INC. | 1SRR2 | 75,000.00 | 75.00 thousand | 1 |
| ULTISAT, INC. | 3H9E0 | 3,434.33 | 3.43 thousand | 1 |
| GOODRICH CORPORATION (2680) | 05WL4 | 0.00 | 0.00 | 1 |
| THE BOEING COMPANY | 18355 | 0.00 | 0.00 | 1 |
| QINETIQ INC. | 1TAV2 | 0.00 | 0.00 | 1 |
| ADVANCED INFORMATION ENGINEERI | 92325 | 0.00 | 0.00 | 1 |
| OCEANEERING INTERNATIONAL, INC | 1TVU1 | 0.00 | 0.00 | 1 |
| EAN HOLDINGS, LLC | 680E4 | -204.00 | -204.00 | 1 |
| VERTEX MODERNIZATION AND SUSTAINMENT LLC | 96JA0 | -2,026.87 | -2.03 thousand | 1 |
Insight
Obligations for PIID 0020 over the last 1 year are concentrated among a small number of vendors, led by AECOM TECHNICAL SERVICES, INC. at $85.82 thousand across 2 awards and P & S CONSTRUCTION INC. at $75.00 thousand on 1 award. After these two, obligated amounts drop sharply to ULTISAT, INC. at $3.43 thousand, while most remaining vendors show zero obligations on a single award. Two vendors reflect negative obligations—VERTEX MODERNIZATION AND SUSTAINMENT LLC (-$2.03 thousand) and EAN HOLDINGS, LLC (-$204)—indicating downward adjustments within the period.
Top NAICS
SELECT
content__award__productOrServiceInformation__principalNAICSCode AS naics_code,
content__award__productOrServiceInformation__principalNAICSCode__description AS naics_name,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count,
formatReadableQuantity(sum(content__award__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
content__award__awardID__awardContractID__agencyID = '9700' AND content__award__awardID__awardContractID__PIID = '0020'
AND content__award__productOrServiceInformation__principalNAICSCode IS NOT NULL
AND content__award__productOrServiceInformation__principalNAICSCode != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
naics_code,
naics_name
ORDER BY total_obligated DESC
LIMIT 10| NAICS Code | Description | Total Obligated | Readable | Actions |
|---|---|---|---|---|
| 541330 | ENGINEERING SERVICES | 83,417.44 | 83.42 thousand | 3 |
| 236220 | COMMERCIAL AND INSTITUTIONAL BUILDING CONSTRUCTION | 75,000.00 | 75.00 thousand | 1 |
| 517919 | ALL OTHER TELECOMMUNICATIONS | 3,434.33 | 3.43 thousand | 1 |
| 541710 | RESEARCH AND DEVELOPMENT IN THE PHYSICAL, ENGINEERING, AND LIFE SCIENCES | 0.00 | 0.00 | 1 |
| 333314 | OPTICAL INSTRUMENT AND LENS MANUFACTURING | 0.00 | 0.00 | 1 |
| 532112 | PASSENGER CAR LEASING | -204.00 | -204.00 | 1 |
| 541512 | COMPUTER SYSTEMS DESIGN SERVICES | -2,026.87 | -2.03 thousand | 1 |
| 336411 | AIRCRAFT MANUFACTURING | -57,000.00 | -57.00 thousand | 2 |
| 333318 | OTHER COMMERCIAL AND SERVICE INDUSTRY MACHINERY MANUFACTURING | -100,665.92 | -100.67 thousand | 1 |
| 336120 | HEAVY DUTY TRUCK MANUFACTURING | -121,457.00 | -121.46 thousand | 1 |
Insight
For agency 9700 award PIID 0020 over the last year, obligations are concentrated in a small set of NAICS codes, led by Engineering Services (541330) at $83.42K across 3 awards and Commercial and Institutional Building Construction (236220) at $75.00K on 1 award. Smaller positive obligations appear in All Other Telecommunications (517919), while several other NAICS codes record zero or negative obligations, indicating offsets, deobligations, or contract adjustments in the period. The largest negative amounts are in Heavy Duty Truck Manufacturing (336120) at -$121.46K and Other Commercial and Service Industry Machinery Manufacturing (333318) at -$100.67K, which materially reduce net obligated value within the mixed NAICS profile.
Top PSC Codes
SELECT
content__award__productOrServiceInformation__productOrServiceCode AS psc_code,
content__award__productOrServiceInformation__productOrServiceCode__description AS psc_name,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count,
formatReadableQuantity(sum(content__award__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
content__award__awardID__awardContractID__agencyID = '9700' AND content__award__awardID__awardContractID__PIID = '0020'
AND content__award__productOrServiceInformation__productOrServiceCode IS NOT NULL
AND content__award__productOrServiceInformation__productOrServiceCode != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
psc_code,
psc_name
ORDER BY total_obligated DESC
LIMIT 10| PSC Code | Description | Total Obligated | Readable | Actions |
|---|---|---|---|---|
| C219 | ARCHITECT AND ENGINEERING- GENERAL: OTHER | 85,823.00 | 85.82 thousand | 2 |
| Y1GC | CONSTRUCTION OF FUEL STORAGE BUILDINGS | 75,000.00 | 75.00 thousand | 1 |
| D316 | IT AND TELECOM- TELECOMMUNICATIONS NETWORK MANAGEMENT | 3,434.33 | 3.43 thousand | 1 |
| AD26 | R&D- DEFENSE OTHER: SERVICES (MANAGEMENT/SUPPORT) | 0.00 | 0.00 | 1 |
| R412 | SUPPORT- PROFESSIONAL: SIMULATION | 0.00 | 0.00 | 1 |
| B599 | SPECIAL STUDIES/ANALYSIS- OTHER | 0.00 | 0.00 | 1 |
| 1510 | AIRCRAFT, FIXED WING | 0.00 | 0.00 | 1 |
| J020 | MAINT/REPAIR/REBUILD OF EQUIPMENT- SHIP AND MARINE EQUIPMENT | 0.00 | 0.00 | 1 |
| W023 | LEASE OR RENTAL OF EQUIPMENT- GROUND EFFECT VEHICLES, MOTOR VEHICLES, TRAILERS, AND CYCLES | -204.00 | -204.00 | 1 |
| R497 | SUPPORT- PROFESSIONAL: PERSONAL SERVICES CONTRACTS | -2,026.87 | -2.03 thousand | 1 |
Insight
Obligations for award 0020 over the past year are concentrated in two PSCs: C219 (Architect and Engineering - General: Other) at $85.82 thousand across 2 awards and Y1GC (Construction of Fuel Storage Buildings) at $75.00 thousand across 1 award. A much smaller amount is associated with D316 (IT and Telecom - Telecommunications Network Management) at $3.43 thousand, while the remaining PSCs are either zero-obligation actions or deobligations. Net activity is therefore dominated by construction and A&E-related work, with limited spread across other service categories.
Annual Trend
SELECT
toYear(parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate)) AS year,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
formatReadableQuantity(sum(content__award__dollarValues__obligatedAmount)) AS total_obligated_readable,
count() AS award_count
FROM fpds.data
WHERE
content__award__awardID__awardContractID__agencyID = '9700' AND content__award__awardID__awardContractID__PIID = '0020'
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC| Year | Total Obligated | Readable | Actions |
|---|---|---|---|
| 2025 | -1,128,436.47 | -1.13 million | 26 |
Insight
In FY 2025, this award obligated -$1.13 million across 26 actions, indicating net deobligation activity over the 1-year window. The negative obligation is concentrated within a single year in the provided data, with no multi-year distribution available to indicate broader trend variation. This level of activity suggests the award experienced significant downward adjustment in obligated value during the period.
Use FPDS Query for deeper award and vehicle analysis
Explore federal procurement data with custom SQL, fast filtering, and deeper contract action analysis across agencies, vendors, NAICS, PSC, and annual trends.
Continue from this last full year view into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.