Vehicle Number

Vehicle Number 7527 / HHSI236201500003C Federal Contract Action Summary (Last 5 Years)

Vehicle number record for PIID HHSI236201500003C under Agency ID 7527, showing one award action in the last 5 years.

This page summarizes the vehicle number associated with PIID HHSI236201500003C for Agency ID 7527 over the last 5 years. The record shows one award action with total obligated amount of -7.84 thousand.

Last full year Last 5 years Last 10 years

Generated at 03/21/2026

Analysis period: Last 5 years

Dollar values are based on the provided obligated total of -7,844.36 and the displayed readable equivalent of -7.84 thousand.

Agency ID

7527

PIID

HHSI236201500003C

Type

Vehicle

Total Obligated

-7.84 thousand

-7,844.36

Actions

Average Action Value

-7,844.36

Overview

The record for vehicle number under PIID HHSI236201500003C shows a single award action in the last 5 years. Total obligated amount is -7,844.36, with an average action value matching the same figure because only one action is present.

How to use this page

Use this page to review the basic procurement profile tied to the vehicle number, including award count and obligated amount. The negative obligated total should be interpreted exactly as provided in the source data.

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 = '7527' AND content__IDV__contractID__IDVID__PIID = 'HHSI236201500003C'
    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
7527	INDIAN HEALTH SERVICE	-7,844.36	-7.84 thousand	1

Insight

For PIID HHSI236201500003C over the 5-year window, obligations are concentrated entirely within Indian Health Service (agency ID 7527), with one reported award. The single agency record carries a net obligated amount of -$7,844.36, indicating a small deobligation rather than positive spend. This distribution reflects no inter-agency spread in the available data and suggests the vehicle’s recorded activity for this period is limited and narrowly concentrated.

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 = '7527' AND content__IDV__contractID__IDVID__PIID = 'HHSI236201500003C'
        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 = '7527' AND content__IDV__contractID__IDVID__PIID = 'HHSI236201500003C'
    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
524291	CLAIMS ADJUSTING	-7,844.36	-7.84 thousand	1

Insight

Obligations for this vehicle are fully concentrated in NAICS 524291, Claims Adjusting, with one award accounting for the entire observed activity over the 5-year window. The total obligated amount is negative at -$7.84 thousand, indicating a net deobligation rather than positive funding. This single-NAICS, single-award pattern suggests very limited distribution of obligations within the vehicle.

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 = '7527' AND content__IDV__contractID__IDVID__PIID = 'HHSI236201500003C'
    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
R710	SUPPORT- MANAGEMENT: FINANCIAL	-7,844.36	-7.84 thousand	1

Insight

Over the 5-year window for vehicle HHSI236201500003C, obligated funding is concentrated entirely in PSC R710 (Support- Management: Financial), with a single award totaling -$7,844.36. This indicates a very narrow PSC distribution for the vehicle, with no evidence of diversification across additional product or service codes in the provided data. The negative obligation value suggests an adjustment or deobligation rather than positive funding 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 = '7527' AND content__IDV__contractID__IDVID__PIID = 'HHSI236201500003C'
    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
2025	-7,844.36	-7.84 thousand	1

Insight

For PIID HHSI236201500003C over the 5-year window, obligations are concentrated entirely in 2025, with one reported award. The single transaction resulted in a net deobligation of $7.84 thousand, indicating no multi-year spread or recurring obligation pattern in the provided data. This suggests activity is isolated to the current year rather than distributed across the period.

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