This page summarizes FPDS activity for award HT940223C0002 within agency ID 9700 during the last 5 years. The award shows 161 actions with total obligated amounts of 5.20 billion and an average action value of 32,295,764.59.
Award Number
Award Number 9700 / HT940223C0002 Federal Contract Action Summary (Last 5 Years)
Federal procurement summary for award number HT940223C0002 at agency ID 9700 over the last 5 years.
Totals are based on the provided analysis window and may differ from values shown in other reporting periods or extracts.
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 HT940223C0002 under agency ID 9700 totals 5,199,618,099 in obligated value across 161 actions in the last 5 years. The average action value is 32,295,764.59, which indicates a high-value award history across the measured period. These figures describe activity for the award number only and do not add contract details not provided here.
How to use this page
Use this page to review the scale and frequency of obligations tied to award HT940223C0002. The action count, total obligated amount, and average action value provide a compact starting point for procurement analysis and comparison within agency ID 9700.
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 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 |
|---|---|---|---|---|
| 97DH | DEFENSE HEALTH AGENCY (DHA) | 5,199,618,099.00 | 5.20 billion | 161 |
Insight
Obligations for this award are fully concentrated in Defense Health Agency (DHA), which accounts for the entire reported 5-year total of $5.20 billion across 161 awards. This indicates a highly centralized funding pattern within a single top agency, with no other agencies appearing in the provided results. The volume of awards suggests sustained recurring activity rather than a one-time obligation.
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 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 |
|---|---|---|---|---|
| TRIWEST HEALTHCARE ALLIANCE CORP. | 07TQ3 | 5,199,618,099.00 | 5.20 billion | 161 |
Insight
Over the 5-year window for award HT940223C0002 under agency 9700, obligations are fully concentrated with a single vendor: TRIWEST HEALTHCARE ALLIANCE CORP. (CAGE 07TQ3). This vendor received $5.20 billion across 161 awards, indicating sustained and highly concentrated award activity rather than a distributed vendor base. The volume and dollar value together suggest this entity is the dominant recipient in this award record.
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 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 |
|---|---|---|---|---|
| 524114 | DIRECT HEALTH AND MEDICAL INSURANCE CARRIERS | 5,199,618,099.00 | 5.20 billion | 161 |
Insight
Over the 5-year window, obligations for PIID HT940223C0002 are fully concentrated in NAICS 524114, Direct Health and Medical Insurance Carriers. This NAICS accounts for $5.20 billion across 161 awards, indicating sustained activity in a single industry category rather than a diversified procurement profile. The concentration suggests the award stream is tightly aligned to health insurance services.
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 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 |
|---|---|---|---|---|
| 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 for this award are highly concentrated in PSC Q201, with MEDICAL- MANAGED HEALTHCARE accounting for $5.18 billion across 155 awards in the 5-year window. By contrast, MEDICAL- GENERAL HEALTH CARE accounts for only $19.92 million across 6 awards, indicating a much smaller secondary spend category. This distribution suggests the award’s obligations are overwhelmingly associated with managed healthcare services, with limited activity in general health care.
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 5 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 the most recent years, with a sharp increase from $6.63 million in 2022 to $412.86 million in 2024 and $4.78 billion in 2025. Award activity also expanded materially, rising from 1 award in 2022–2023 to 76 awards in 2024 and 83 awards in 2025. The 2023 entry reflects 1 award with no recorded obligations, indicating timing or funding distribution that does not materially affect the overall upward trend.
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.