Vehicle Number

Vehicle Number 8900 / DEEM0002043 Federal Contract Action Summary (Last 5 Years)

Procurement analysis page for vehicle number under Agency ID 8900 and PIID DEEM0002043 covering the last 5 years.

This page summarizes award activity for vehicle number associated with Agency ID 8900 and PIID DEEM0002043 over the last 5 years. The record shows 2 award actions with total obligated amounts of -$1.84 million.

Last full year Last 5 years Last 10 years

Generated at 03/21/2026

Analysis period: Last 5 years

Total obligated value is shown as -$1,838,943.12, and the readable total rounds to -$1.84 million.

Agency ID

8900

PIID

DEEM0002043

Type

Vehicle

Total Obligated

-1.84 million

-1,838,943.12

Actions

Average Action Value

-919,471.56

Overview

The procurement record for vehicle number under Agency ID 8900 and PIID DEEM0002043 contains 2 award actions in the last 5 years. Total obligated value is negative $1,838,943.12, with an average action value of -$919,471.56. This page presents the award history at the vehicle level only, based on the inputs provided.

How to use this page

Use this page to review the obligation total, action count, and average action value associated with this vehicle record. It is suitable for quick reference, basic trend review within the 5-year window, and cross-checking against the underlying FPDS record.

Top Agencies

SELECT
    content__IDV__purchaserInformation__contractingOfficeAgencyID AS agency_id,
    content__IDV__purchaserInformation__contractingOfficeAgencyID__name AS agency_name,
    sum(content__IDV__dollarValues__obligatedAmount) AS total_obligated,
    count() AS award_count,
    formatReadableQuantity(sum(content__IDV__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
    content__IDV__contractID__IDVID__agencyID = '8900' AND content__IDV__contractID__IDVID__PIID = 'DEEM0002043'
    AND content__IDV__purchaserInformation__contractingOfficeAgencyID IS NOT NULL
    AND content__IDV__purchaserInformation__contractingOfficeAgencyID != ''
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
    AND parseDateTimeBestEffortOrNull(content__IDV__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	-1,838,943.12	-1.84 million	2

Insight

For PIID DEEM0002043 over the 5-year window, all reported obligations are concentrated within the Department of Energy (Agency ID 8900). The vehicle records 2 awards totaling -$1.84 million, indicating a fully centralized obligation pattern for this entity within the provided data. The negative total obligated should be interpreted in context of the underlying FPDS records, but no additional agency distribution is shown here.

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__IDV__dollarValues__obligatedAmount) AS total_obligated,
        count() AS award_count
    FROM fpds.data
    WHERE
        content__IDV__contractID__IDVID__agencyID = '8900' AND content__IDV__contractID__IDVID__PIID = 'DEEM0002043'
        AND content__award__vendor__vendorHeader__vendorName IS NOT NULL
        AND content__award__vendor__vendorHeader__vendorName != ''
        AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
        AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
    GROUP BY
        vendor_name,
        cage_code
)
ORDER BY total_obligated DESC
LIMIT 10

Vendor	CAGE Code	Total Obligated	Readable	Actions

Insight

No vendor concentration was available for this analysis window.

Top NAICS

SELECT
    content__IDV__productOrServiceInformation__principalNAICSCode AS naics_code,
    content__IDV__productOrServiceInformation__principalNAICSCode__description AS naics_name,
    sum(content__IDV__dollarValues__obligatedAmount) AS total_obligated,
    count() AS award_count,
    formatReadableQuantity(sum(content__IDV__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
    content__IDV__contractID__IDVID__agencyID = '8900' AND content__IDV__contractID__IDVID__PIID = 'DEEM0002043'
    AND content__IDV__productOrServiceInformation__principalNAICSCode IS NOT NULL
    AND content__IDV__productOrServiceInformation__principalNAICSCode != ''
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
    naics_code,
    naics_name
ORDER BY total_obligated DESC
LIMIT 10

NAICS Code	Description	Total Obligated	Readable	Actions
621111	OFFICES OF PHYSICIANS (EXCEPT MENTAL HEALTH SPECIALISTS)	-1,838,943.12	-1.84 million	2

Insight

Obligations under PIID DEEM0002043 are fully concentrated in NAICS 621111, Offices of Physicians (except Mental Health Specialists), over the 5-year window. This code accounts for two awards totaling -$1.84 million, indicating a narrow and singular industry focus within the observed record. The negative obligated total suggests net deobligation activity rather than new funding in this NAICS category.

Top PSC Codes

SELECT
    content__IDV__productOrServiceInformation__productOrServiceCode AS psc_code,
    content__IDV__productOrServiceInformation__productOrServiceCode__description AS psc_name,
    sum(content__IDV__dollarValues__obligatedAmount) AS total_obligated,
    count() AS award_count,
    formatReadableQuantity(sum(content__IDV__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
    content__IDV__contractID__IDVID__agencyID = '8900' AND content__IDV__contractID__IDVID__PIID = 'DEEM0002043'
    AND content__IDV__productOrServiceInformation__productOrServiceCode IS NOT NULL
    AND content__IDV__productOrServiceInformation__productOrServiceCode != ''
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
    psc_code,
    psc_name
ORDER BY total_obligated DESC
LIMIT 10

PSC Code	Description	Total Obligated	Readable	Actions
Q526	MEDICAL- MEDICAL/PSYCHIATRIC CONSULTATION	-1,838,943.12	-1.84 million	2

Insight

Over the 5-year window for vehicle DEEM0002043, obligations are fully concentrated in PSC Q526, Medical-Medical/Psychiatric Consultation. This PSC accounts for two awards and a total of -$1.84 million in obligated value, indicating a narrow product/service mix within the vehicle. The negative obligated amount suggests deobligations or downward funding adjustments rather than new positive obligation activity.

Annual Trend

SELECT
    toYear(parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate)) AS year,
    sum(content__IDV__dollarValues__obligatedAmount) AS total_obligated,
    formatReadableQuantity(sum(content__IDV__dollarValues__obligatedAmount)) AS total_obligated_readable,
    count() AS award_count
FROM fpds.data
WHERE
    content__IDV__contractID__IDVID__agencyID = '8900' AND content__IDV__contractID__IDVID__PIID = 'DEEM0002043'
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC

Year	Total Obligated	Readable	Actions
2022	0.00	0.00	1
2025	-1,838,943.12	-1.84 million	1

Insight

Obligations under vehicle DEEM0002043 are highly concentrated, with only one recorded award in 2022 and one in 2025 over the 5-year window. The 2022 award had no obligated dollars, while the 2025 award carried a negative obligation of $1.84 million, indicating a downward and uneven funding pattern across the period. This distribution suggests limited award activity and a material deobligation or adjustment in 2025.

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.

Start 7-Day Trial Learn More