Vehicle Number

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

Federal procurement summary for vehicle number DEEM0002043 at agency 8900, showing one award action in the last full year.

This page summarizes award activity for vehicle number DEEM0002043 within agency 8900 during the last full year. The record shows one action with total obligations of -1.84 million dollars.

Last full year Last 5 years Last 10 years

Generated at 03/21/2026

Analysis period: Last full year

All values reflect the provided FPDS analysis window and reported obligated amounts for this vehicle record.

Agency ID

8900

PIID

DEEM0002043

Type

Vehicle

Total Obligated

-1.84 million

-1,838,943.12

Actions

Average Action Value

-1,838,943.12

Overview

In the last full year, vehicle number DEEM0002043 under agency 8900 had a single award action. The total obligated amount was -1,838,943.12 dollars, which also equals the average action value because only one action is present.

How to use this page

Use this page to review the basic award profile tied to PIID DEEM0002043 and the agency 8900 record. The data supports a quick check of action count and obligated value for the selected analysis window.

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 1 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	1

Insight

Within the 1-year window for vehicle DEEM0002043, obligations are fully concentrated in a single agency: the Department of Energy. DOE recorded one award with net obligations of -$1.84 million, indicating a negative funding movement rather than positive spending in this period. No other agencies appear in the provided data, so there is no interagency distribution to assess.

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 1 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 1 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	1

Insight

Over the past 1 year, obligations under PIID DEEM0002043 were fully concentrated in NAICS 621111, Offices of Physicians (except Mental Health Specialists), with a single award accounting for -$1.84 million in obligations. This indicates no observable distribution across additional NAICS categories within the reported window. The negative obligated amount suggests deobligation activity or net downward adjustment for this 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 1 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	1

Insight

Obligations under PIID DEEM0002043 are fully concentrated in PSC Q526, Medical-Medical/Psychiatric Consultation, with a single award accounting for -$1.84 million over the 1-year window. This indicates no PSC diversification within the observed period. The negative obligated amount should be interpreted as a deobligation or downward adjustment rather than new spend.

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 1 YEAR
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC

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

Insight

For Agency 8900, PIID DEEM0002043 shows obligations concentrated entirely in FY 2025 within the 1-year window, with one award totaling -$1.84 million. The single-obligation pattern indicates no observed year-over-year distribution in this period. The negative total obligated value is the key trend feature and may warrant review in the context of contract adjustments or deobligations.

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.

Start 7-Day Trial Learn More