This award record for PIID HT940223C0002 under agency ID 9700 covers the last full year of activity. It reflects 83 award actions and total obligated dollars of 4,780,125,952.
Award Number
Award Number 9700 / HT940223C0002 Federal Contract Action Summary (Last Year)
FPDS award number HT940223C0002 for agency 9700 shows 83 award actions in the last full year, with total obligations of 4.78 billion.
Totals are based on the provided analysis window and may reflect obligation activity across multiple actions within the award record.
Agency ID
9700
PIID
HT940223C0002
Type
Award
Total Obligated
4.78 billion
4,780,125,952.00
Actions
83
Average Action Value
57,591,878.94
Overview
For the last full year, award number HT940223C0002 under agency ID 9700 recorded 83 award actions. Total obligated dollars were 4,780,125,952, with an average action value of 57,591,878.94. These figures describe the award-level obligation activity captured in the provided window.
How to use this page
Use this page to review award-level activity for HT940223C0002 and to compare its action count, obligations, and average action value with other FPDS records. The figures are useful for identifying the scale and frequency of obligation changes within the last full year.
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 1 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) | 4,780,125,952.00 | 4.78 billion | 83 |
Insight
Obligations for PIID HT940223C0002 in the 1-year window are fully concentrated in a single top agency, the Defense Health Agency (DHA). DHA accounts for $4.78 billion across 83 awards, indicating that activity under this identifier is heavily centered within one agency rather than distributed across multiple agencies. This concentration suggests the award’s obligation profile is highly agency-specific within the reviewed period.
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 1 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 | 4,780,125,952.00 | 4.78 billion | 83 |
Insight
TRIWEST HEALTHCARE ALLIANCE CORP. accounts for the entire reported vendor obligation total for this award within the 1-year window, with $4.78 billion across 83 awards. This indicates complete concentration of obligations to a single vendor in the reported period. The distribution suggests this award relationship is highly centralized rather than spread across multiple suppliers.
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 1 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 | 4,780,125,952.00 | 4.78 billion | 83 |
Insight
Within the 1-year window, obligations for award HT940223C0002 are entirely concentrated in NAICS 524114, Direct Health and Medical Insurance Carriers. The single reported NAICS accounts for $4.78 billion across 83 awards, indicating a highly concentrated obligation profile rather than a diversified industry mix.
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 1 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 | 4,780,125,952.00 | 4.78 billion | 83 |
Insight
Obligations under PIID HT940223C0002 are fully concentrated in PSC Q201, Medical- Managed Healthcare. Over the 1-year window, 83 awards account for $4.78 billion in total obligated value, indicating a highly concentrated spend profile within a single PSC category. This distribution suggests the award activity is dominated by managed healthcare services with no diversification across other PSCs in the provided data.
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 1 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC| Year | Total Obligated | Readable | Actions |
|---|---|---|---|
| 2025 | 4,780,125,952.00 | 4.78 billion | 83 |
Insight
Over the 1-year window, obligations for award HT940223C0002 are concentrated entirely in FY 2025, with $4.78 billion obligated across 83 awards. This indicates a highly concentrated recent funding profile, with no activity reflected in the provided rows for other years. The volume suggests significant current-year execution under this award, but the limited year coverage prevents assessment of longer-term trend direction.
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.