This page summarizes award-level procurement activity for PIID HQ027615C0003 across the last full year. The record shows 28 award actions and total obligated value of -9.38 million, with an average action value of -335,137.79.
Award Number
Award Number 9700 / HQ027615C0003 Federal Contract Action Summary (Last Year)
FPDS award page for award number HQ027615C0003 under agency ID 9700, covering the last full year of reported activity.
Figures are reported as provided, including an exact total obligated amount of -9383858.2.
Agency ID
9700
PIID
HQ027615C0003
Type
Award
Total Obligated
-9.38 million
-9,383,858.20
Actions
28
Average Action Value
-335,137.79
Overview
The award record for HQ027615C0003 shows 28 actions during the last full year. Total obligated value is reported as -9.38 million, with an exact value of -9383858.2 and an average action value of -335,137.79. This page is centered on the award identifier and the reported obligation totals for agency ID 9700.
How to use this page
Use this page to review the reported action count and obligation totals for award HQ027615C0003 over the last full year. The figures are suitable for identifying the scale and direction of reported funding changes within this award record.
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 = 'HQ027615C0003'
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 |
|---|---|---|---|---|
| 9763 | DEFENSE CONTRACT MANAGEMENT AGENCY (DCMA) | 0.00 | 0.00 | 15 |
| 97JC | MISSILE DEFENSE AGENCY (MDA) | -9,383,858.20 | -9.38 million | 13 |
Insight
Within the past year for PIID HQ027615C0003, award activity is concentrated in two agencies, with DCMA accounting for 15 awards and no recorded obligation, and MDA accounting for 13 awards with -$9.38 million obligated. The distribution indicates a high volume of activity across both agencies, but the funding impact is driven entirely by MDA. The negative obligated total at MDA suggests deobligations or downward funding adjustments during the period.
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 = 'HQ027615C0003'
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 |
|---|---|---|---|---|
| RAYTHEON COMPANY | 15090 | -9,383,858.20 | -9.38 million | 28 |
Insight
RAYTHEON COMPANY is the only vendor listed for this award in the 1-year window, indicating full vendor concentration in the observed data. The award is associated with 28 actions totaling -$9.38 million obligated, suggesting repeated deobligation or downward funding adjustments rather than positive net obligation. No other vendors appear in the provided rows, so there is no evidence of distribution across multiple suppliers in this 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 = 'HQ027615C0003'
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 |
|---|---|---|---|---|
| 541712 | RESEARCH AND DEVELOPMENT IN THE PHYSICAL, ENGINEERING, AND LIFE SCIENCES (EXCEPT BIOTECHNOLOGY) | -9,383,858.20 | -9.38 million | 28 |
Insight
Obligations for PIID HQ027615C0003 over the past year are concentrated entirely in NAICS 541712, Research and Development in the Physical, Engineering, and Life Sciences (except Biotechnology). This category accounts for all reported activity in the period, with 28 awards and a net obligated value of -$9.38 million. The negative total indicates net deobligation or downward adjustment within this NAICS rather than positive funding growth.
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 = 'HQ027615C0003'
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 |
|---|---|---|---|---|
| 1410 | GUIDED MISSILES | -9,383,858.20 | -9.38 million | 28 |
Insight
Obligations for this award are concentrated entirely in PSC 1410, Guided Missiles, over the 1-year window. The category accounts for -$9.38 million across 28 awards, indicating repeated activity within a single product service code rather than a diversified obligation profile. Negative obligated value suggests deobligations or downward adjustments in the period.
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 = 'HQ027615C0003'
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 | -9,383,858.20 | -9.38 million | 28 |
Insight
For FY2025, this award recorded $9.38 million in net deobligations across 28 actions, indicating negative obligation activity over the 1-year window. The activity is concentrated in a single fiscal year in the provided data, so no multi-year trend can be assessed from these rows alone.
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.