This page summarizes award 0007 under agency ID 9700 for the last full year. The award shows 93 actions and total obligated funding of -$13.68 million.
Award Number
Award Number 9700 / 0007 Federal Contract Action Summary (Last Year)
Federal procurement award number 0007 for agency 9700, summarized for the last full year with obligation and action-level activity.
Totals reflect the provided FPDS analysis window and may include deobligations, which can result in negative obligated values.
Overview
In the last full year, award 0007 under agency ID 9700 posted 93 recorded actions and a total obligated amount of -$13,683,894.08. The average action value was -$147,138.65, indicating the award’s activity included negative obligation adjustments over the period.
How to use this page
Use this page to review award-level obligation trends, action volume, and the scale of activity recorded for the analysis window. The figures support quick comparison against other awards, especially where negative totals indicate deobligations or net reductions.
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 = '0007'
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 |
|---|---|---|---|---|
| 97ZS | U.S. SPECIAL OPERATIONS COMMAND (USSOCOM) | 0.00 | 0.00 | 1 |
| 1700 | DEPT OF THE NAVY | -4,480.25 | -4.48 thousand | 7 |
| 97AS | DEFENSE LOGISTICS AGENCY | -22,298.12 | -22.30 thousand | 4 |
| 5700 | DEPT OF THE AIR FORCE | -395,882.74 | -395.88 thousand | 15 |
| 97AK | DEFENSE INFORMATION SYSTEMS AGENCY (DISA) | -2,303,200.26 | -2.30 million | 3 |
| 9763 | DEFENSE CONTRACT MANAGEMENT AGENCY (DCMA) | -3,525,189.65 | -3.53 million | 8 |
| 2100 | DEPT OF THE ARMY | -7,432,843.06 | -7.43 million | 55 |
Insight
Obligations for PIID 0007 over the past year are concentrated in DEPT OF THE ARMY, which accounts for 55 awards and -7.43 million, the largest share by both volume and value. DEPT OF THE ARMY, DCMA (-3.53 million), and DISA (-2.30 million) drive nearly all negative obligated value across the listed agencies, indicating activity is heavily weighted toward a small set of defense components. Other agencies contribute relatively minor amounts, including DEPT OF THE AIR FORCE (-395.88 thousand), DLA (-22.30 thousand), DEPT OF THE NAVY (-4.48 thousand), and USSOCOM at zero obligated value.
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 = '0007'
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 |
|---|---|---|---|---|
| SIEMENS GOVERNMENT SERVICES, INC. | 0DZG1 | 4,019,748.80 | 4.02 million | 4 |
| JOHNSON CONTROLS GOVERNMENT SYSTEMS LIMITED LIABILITY COMPANY | 1MN13 | 323,045.00 | 323.05 thousand | 2 |
| CAE USA INC. | 50237 | 161,563.36 | 161.56 thousand | 1 |
| FIBERTEK, INC. | 8Y519 | 41,313.38 | 41.31 thousand | 2 |
| LOCKHEED MARTIN CORPORATION | 64059 | 4,447.00 | 4.45 thousand | 2 |
| ULTISAT, INC. | 3H9E0 | 3,434.33 | 3.43 thousand | 1 |
| REDSTONE DEFENSE SYSTEMS | 6AD76 | 0.00 | 0.00 | 1 |
| LACLEDE CHAIN MANUFACTURING COMPANY, LLC | 16457 | 0.00 | 0.00 | 1 |
| GENERAL DYNAMICS INFORMATION TECHNOLOGY, INC. | 07MU1 | 0.00 | 0.00 | 1 |
| PARSONS GOVERNMENT SERVICES INC. | 1BVK6 | 0.00 | 0.00 | 1 |
Insight
Obligations for PIID 0007 over the past year are concentrated among a small number of vendors, with SIEMENS GOVERNMENT SERVICES, INC. accounting for the largest share at $4.02 million across 4 awards. JOHNSON CONTROLS GOVERNMENT SYSTEMS LIMITED LIABILITY COMPANY is the next largest recipient at $323.05 thousand, while the remaining vendors each received $161.56 thousand or less. Several vendors received awards with no obligated amount, indicating award activity without recorded obligation in this window.
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 = '0007'
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 | 3,722,368.66 | 3.72 million | 15 |
| 221122 | ELECTRIC POWER DISTRIBUTION | 323,045.00 | 323.05 thousand | 2 |
| 333319 | OTHER COMMERCIAL AND SERVICE INDUSTRY MACHINERY MANUFACTURING | 161,563.36 | 161.56 thousand | 1 |
| 336414 | GUIDED MISSILE AND SPACE VEHICLE MANUFACTURING | 4,447.00 | 4.45 thousand | 2 |
| 517919 | ALL OTHER TELECOMMUNICATIONS | 3,434.33 | 3.43 thousand | 1 |
| 541620 | ENVIRONMENTAL CONSULTING SERVICES | 0.00 | 0.00 | 1 |
| 541990 | ALL OTHER PROFESSIONAL, SCIENTIFIC, AND TECHNICAL SERVICES | 0.00 | 0.00 | 1 |
| 332618 | OTHER FABRICATED WIRE PRODUCT MANUFACTURING | 0.00 | 0.00 | 1 |
| 315220 | MEN'S AND BOYS' CUT AND SEW APPAREL MANUFACTURING | -337.12 | -337.12 | 1 |
| 541690 | OTHER SCIENTIFIC AND TECHNICAL CONSULTING SERVICES | -3,532.97 | -3.53 thousand | 1 |
Insight
Obligations for PIID 0007 are concentrated in NAICS 541330, Engineering Services, which accounts for $3.72 million across 15 awards and dominates the 1-year period. The next largest category, 221122 Electric Power Distribution, is much smaller at $323.05 thousand across 2 awards, with all remaining NAICS codes each contributing $161.56 thousand or less. Several NAICS codes have zero obligations, and two codes post small negative obligations, indicating limited downward adjustments relative to the overall award portfolio.
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 = '0007'
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 |
|---|---|---|---|---|
| R499 | SUPPORT- PROFESSIONAL: OTHER | 4,015,956.46 | 4.02 million | 5 |
| B543 | SPECIAL STUDIES/ANALYSIS- ENERGY | 323,045.00 | 323.05 thousand | 2 |
| 1410 | GUIDED MISSILES | 4,447.00 | 4.45 thousand | 2 |
| B526 | SPECIAL STUDIES/ANALYSIS- OCEANOLOGICAL | 0.00 | 0.00 | 1 |
| 1650 | AIRCRAFT HYDRAULIC, VACUUM, AND DE-ICING SYSTEM COMPONENTS | 0.00 | 0.00 | 2 |
| AD97 | R&D- DEFENSE OTHER: OTHER (COMMERCIALIZED) | 0.00 | 0.00 | 1 |
| 4010 | CHAIN AND WIRE ROPE | 0.00 | 0.00 | 1 |
| J069 | MAINT/REPAIR/REBUILD OF EQUIPMENT- TRAINING AIDS AND DEVICES | 0.00 | 0.00 | 1 |
| R498 | SUPPORT- PROFESSIONAL: PATENT AND TRADEMARK | 0.00 | 0.00 | 1 |
| 8405 | OUTERWEAR, MEN'S | -337.12 | -337.12 | 1 |
Insight
Obligations for PIID 0007 over the past year are concentrated in PSC R499, which accounts for 4.02 million across 5 awards and represents the clear majority of obligated value. The next largest category, B543, totals 323.05 thousand across 2 awards, while all other PSCs are either nominal in value or zero-obligation transactions. This pattern indicates a highly concentrated spend profile with limited value spread across a broader set of PSCs.
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 = '0007'
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 | -13,683,894.08 | -13.68 million | 93 |
Insight
In FY 2025, the award reflects -$13.68 million in total obligated value across 93 awards, indicating a large volume of activity concentrated within the one-year window. The negative obligated amount suggests net deobligation or downward funding adjustments for the period, rather than net new funding growth. With only one year reported, the data supports a point-in-time assessment of obligations for PIID 0007 under Agency 9700, but not a year-over-year trend comparison.
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.