This page summarizes award-level obligation activity for PIID DEAC0608RL14788 within agency ID 8900 over the last 5 years. The record shows 22 award actions and total obligated amount of -$15.94 million.
Award Number
Award Number 8900 / DEAC0608RL14788 Federal Contract Action Summary (Last 5 Years)
Federal procurement profile for award number DEAC0608RL14788 under agency ID 8900, summarizing obligation activity over the last 5 years.
Amounts are shown using the provided readable and exact totals; the exact total obligated is -15943550.63 and the average action value is -724706.85.
Agency ID
8900
PIID
DEAC0608RL14788
Type
Award
Total Obligated
-15.94 million
-15,943,550.63
Actions
22
Average Action Value
-724,706.85
Overview
The award record for PIID DEAC0608RL14788 shows 22 actions across the last 5 years. Total obligated funding is -$15.94 million, with an average action value of -$724,706.85. The negative obligated total indicates net deobligation or downward funding activity over the analysis window.
How to use this page
Use this page to review award-level activity for DEAC0608RL14788 and to compare its obligation trend with other records in agency ID 8900. The figures support basic monitoring of action volume, funding direction, and average action size over the selected period.
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 = '8900' AND content__award__awardID__awardContractID__PIID = 'DEAC0608RL14788'
AND content__award__purchaserInformation__contractingOfficeAgencyID IS NOT NULL
AND content__award__purchaserInformation__contractingOfficeAgencyID != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 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 |
|---|---|---|---|---|
| 8900 | ENERGY, DEPARTMENT OF | -15,943,550.63 | -15.94 million | 22 |
Insight
Within the 5-year window, award activity for PIID DEAC0608RL14788 is entirely concentrated in the Department of Energy (agency 8900), with 22 awards recorded. The total obligated amount is negative at $15.94 million, indicating net deobligation or downward adjustment over the period. This single-agency concentration means the award’s financial history is not distributed across multiple agencies.
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 = '8900' AND content__award__awardID__awardContractID__PIID = 'DEAC0608RL14788'
AND content__award__vendor__vendorHeader__vendorName IS NOT NULL
AND content__award__vendor__vendorHeader__vendorName != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 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 |
|---|---|---|---|---|
| CH2M HILL PLATEAU REMEDIATION COMPANY | 4UD64 | -15,943,550.63 | -15.94 million | 22 |
Insight
Over the 5-year window, obligations for PIID DEAC0608RL14788 are concentrated entirely with CH2M HILL PLATEAU REMEDIATION COMPANY (CAGE 4UD64). This vendor accounts for all reported activity in the section, with 22 awards and total obligated amounts of -$15.94 million. The negative obligation value indicates net deobligation or downward adjustment activity over 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 = '8900' AND content__award__awardID__awardContractID__PIID = 'DEAC0608RL14788'
AND content__award__productOrServiceInformation__principalNAICSCode IS NOT NULL
AND content__award__productOrServiceInformation__principalNAICSCode != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 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 |
|---|---|---|---|---|
| 562910 | REMEDIATION SERVICES | -15,943,550.63 | -15.94 million | 22 |
Insight
Over the past 5 years, obligations under PIID DEAC0608RL14788 are fully concentrated in NAICS 562910, Remediation Services, with 22 awards totaling -$15.94 million. This indicates a single-industry profile with no diversification across NAICS codes in the provided data. The negative obligated total suggests net downward adjustments or deobligations over the period, 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 = '8900' AND content__award__awardID__awardContractID__PIID = 'DEAC0608RL14788'
AND content__award__productOrServiceInformation__productOrServiceCode IS NOT NULL
AND content__award__productOrServiceInformation__productOrServiceCode != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 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 |
|---|---|---|---|---|
| Z294 | MAINT-REP-ALT/WASTE TRMT-STORE FAC | -15,943,550.63 | -15.94 million | 22 |
Insight
Over the 5-year window, obligations for PIID DEAC0608RL14788 are concentrated in PSC Z294 (MAINT-REP-ALT/WASTE TRMT-STORE FAC), which accounts for the full reported activity in this section. The award shows 22 actions associated with a net obligation of -$15.94 million, indicating substantial deobligation activity or downward funding adjustments rather than net新增 funding. This pattern suggests the award’s top PSC mix is highly concentrated and financially negative over 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 = '8900' AND content__award__awardID__awardContractID__PIID = 'DEAC0608RL14788'
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC| Year | Total Obligated | Readable | Actions |
|---|---|---|---|
| 2021 | -9,433,263.72 | -9.43 million | 14 |
| 2022 | 320,262.44 | 320.26 thousand | 5 |
| 2024 | -200,000.00 | -200.00 thousand | 2 |
| 2025 | -6,630,549.35 | -6.63 million | 1 |
Insight
Obligations for PIID DEAC0608RL14788 are highly concentrated in 2021 and 2025, with negative net obligated amounts of -$9.43 million across 14 awards and -$6.63 million across 1 award, respectively. Activity was much lower in 2022, with $320.26 thousand across 5 awards, and remained limited in 2024 at -$200.00 thousand across 2 awards. The pattern indicates an uneven 5-year obligation profile, with most value occurring in two years and minimal activity in the intervening periods.
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 5 years view into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.