Award Number

Award Number 9700 / HT940223C0002 Federal Contract Action Summary (Last 10 Years)

Federal procurement summary for award number HT940223C0002 under agency ID 9700, covering the last 10 years of obligation and action history.

This page summarizes award number HT940223C0002 for agency ID 9700 over the last 10 years. The record shows 161 award actions with total obligated amounts of 5.20 billion, or 5,199,618,099 in exact dollars.

Last full year Last 5 years Last 10 years

Generated at 03/20/2026

Analysis period: Last 10 years

Total obligated and average action value reflect the stated analysis window and may not equal current award balance.

Agency ID

9700

PIID

HT940223C0002

Type

Award

Total Obligated

5.20 billion

5,199,618,099.00

Actions

161

Average Action Value

32,295,764.59

Overview

Award number HT940223C0002 is associated with agency ID 9700 and shows activity across the last 10 years. The record includes 161 award actions and total obligated funding of 5,199,618,099 dollars. The average action value over the period is 32,295,764.59 dollars.

How to use this page

Use this page to review the award-level obligation history and action volume for HT940223C0002. It is suitable for tracking long-term procurement activity, comparing total obligations, and reviewing the average value per action within the stated analysis window.

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 = 'HT940223C0002'
    AND content__award__purchaserInformation__contractingOfficeAgencyID IS NOT NULL
    AND content__award__purchaserInformation__contractingOfficeAgencyID != ''
    AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 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
97DH	DEFENSE HEALTH AGENCY (DHA)	5,199,618,099.00	5.20 billion	161

Insight

All obligations in this 10-year window are concentrated in Defense Health Agency (DHA), which accounts for $5.20 billion across 161 awards. This indicates the award’s funding and activity are fully centered within a single top agency rather than distributed across multiple agencies. The concentration suggests DHA is the sole material obligating agency for this PIID over the period reviewed.

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 = 'HT940223C0002'
        AND content__award__vendor__vendorHeader__vendorName IS NOT NULL
        AND content__award__vendor__vendorHeader__vendorName != ''
        AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 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
TRIWEST HEALTHCARE ALLIANCE CORP.	07TQ3	5,199,618,099.00	5.20 billion	161

Insight

Across the 10-year window, obligations for PIID HT940223C0002 are fully concentrated with a single vendor, TRIWEST HEALTHCARE ALLIANCE CORP. (CAGE 07TQ3). This vendor received 161 awards totaling $5.20 billion, indicating a highly concentrated obligation pattern with no other vendors represented in the provided rows.

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 = 'HT940223C0002'
    AND content__award__productOrServiceInformation__principalNAICSCode IS NOT NULL
    AND content__award__productOrServiceInformation__principalNAICSCode != ''
    AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 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
524114	DIRECT HEALTH AND MEDICAL INSURANCE CARRIERS	5,199,618,099.00	5.20 billion	161

Insight

Over the 10-year window, obligations for award HT940223C0002 are fully concentrated in NAICS 524114, Direct Health and Medical Insurance Carriers. The award records 161 actions tied to this single NAICS, with total obligated value of $5.20 billion, indicating a highly concentrated spending profile with no diversification across other NAICS codes in the provided data.

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 = 'HT940223C0002'
    AND content__award__productOrServiceInformation__productOrServiceCode IS NOT NULL
    AND content__award__productOrServiceInformation__productOrServiceCode != ''
    AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 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
Q201	MEDICAL- MANAGED HEALTHCARE	5,179,702,674.00	5.18 billion	155
Q201	MEDICAL- GENERAL HEALTH CARE	19,915,425.00	19.92 million	6

Insight

Obligations are highly concentrated in PSC Q201 for medical managed healthcare, which accounts for $5.18 billion across 155 awards. A much smaller portion is associated with PSC Q201 for medical general health care, at $19.92 million across 6 awards. This distribution indicates the award activity under PIID HT940223C0002 over the 10-year window is overwhelmingly weighted toward managed healthcare services.

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 = 'HT940223C0002'
    AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 YEAR
    AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC

Year	Total Obligated	Readable	Actions
2022	6,630,000.00	6.63 million	1
2023	0.00	0.00	1
2024	412,862,147.00	412.86 million	76
2025	4,780,125,952.00	4.78 billion	83

Insight

Obligations under PIID HT940223C0002 are highly concentrated in 2024 and 2025, which account for nearly all reported activity in the 10-year window. FY2024 rose sharply to $412.86 million across 76 awards after a single $6.63 million obligation in 2022 and no obligated amount in 2023, indicating a pronounced step-up in spending. FY2025 increased further to $4.78 billion across 83 awards, making it the dominant year by both dollars and award count.

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 10 years view into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.

Start 7-Day Trial Learn More