Vehicle Number

Vehicle Number 2400 / OPM1517C0006 Federal Contract Action Summary (Last 10 Years)

Federal procurement analysis for vehicle number under agency ID 2400 and PIID OPM1517C0006, covering the last 10 years of award activity.

This page summarizes award activity for vehicle number in connection with PIID OPM1517C0006 over the last 10 years. The record shows 19 award actions with total obligated value of 50.52 million and an average action value of 2,658,697.18.

Generated at 03/21/2026

Analysis period: Last 10 years

Obligated totals are shown as both readable and exact values; the exact total is 50,515,246.38.

Agency ID
2400
PIID
OPM1517C0006
Type
Vehicle
Total Obligated
50.52 million
50,515,246.38
Actions
19
Average Action Value
2,658,697.18

Overview

The analysis window covers the last 10 years and records 19 award actions tied to vehicle number for agency ID 2400 under PIID OPM1517C0006. Total obligated amount is 50.52 million, with an exact value of 50,515,246.38 and an average action value of 2,658,697.18. This page presents the procurement record as a concise reference for award volume and obligated dollars.

How to use this page

Use this page to review the award count, obligated total, and average action value associated with this vehicle record. The information is useful for quick procurement lookup and for comparing this PIID against other federal award records within the same 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 = '2400' AND content__IDV__contractID__IDVID__PIID = 'OPM1517C0006'
    AND content__IDV__purchaserInformation__contractingOfficeAgencyID IS NOT NULL
    AND content__IDV__purchaserInformation__contractingOfficeAgencyID != ''
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 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
2400 OFFICE OF PERSONNEL MANAGEMENT 50,515,246.38 50.52 million 19

Insight

For PIID OPM1517C0006 over the 10-year window, all reported obligations are concentrated in the Office of Personnel Management. OPM accounts for $50.52 million across 19 awards, indicating the vehicle activity is entirely or overwhelmingly centered within a single agency. This pattern suggests limited interagency distribution for this PIID in the queried 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__IDV__dollarValues__obligatedAmount) AS total_obligated,
        count() AS award_count
    FROM fpds.data
    WHERE
        content__IDV__contractID__IDVID__agencyID = '2400' AND content__IDV__contractID__IDVID__PIID = 'OPM1517C0006'
        AND content__award__vendor__vendorHeader__vendorName IS NOT NULL
        AND content__award__vendor__vendorHeader__vendorName != ''
        AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 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 = '2400' AND content__IDV__contractID__IDVID__PIID = 'OPM1517C0006'
    AND content__IDV__productOrServiceInformation__principalNAICSCode IS NOT NULL
    AND content__IDV__productOrServiceInformation__principalNAICSCode != ''
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 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
561611 INVESTIGATION SERVICES 50,515,246.38 50.52 million 19

Insight

Obligations for this vehicle are fully concentrated in NAICS 561611, Investigation Services, with $50.52 million obligated across 19 awards over the 10-year window. This indicates a narrow activity profile and consistent use of the vehicle for a single service category rather than a diversified mix of NAICS codes. The award count suggests repeated procurement activity within the same classification, but no distribution across additional NAICS codes is present in the provided data.

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 = '2400' AND content__IDV__contractID__IDVID__PIID = 'OPM1517C0006'
    AND content__IDV__productOrServiceInformation__productOrServiceCode IS NOT NULL
    AND content__IDV__productOrServiceInformation__productOrServiceCode != ''
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 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
R499 SUPPORT- PROFESSIONAL: OTHER 50,515,246.38 50.52 million 19

Insight

Obligations under PIID OPM1517C0006 are fully concentrated in PSC R499, Support- Professional: Other, with $50.52 million across 19 awards over the 10-year window. This indicates no PSC diversification within the reported vehicle and suggests sustained use of a single professional support category. The award count also indicates repeated contracting activity in the same PSC, rather than a one-time obligation pattern.

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 = '2400' AND content__IDV__contractID__IDVID__PIID = 'OPM1517C0006'
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 YEAR
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC
Year Total Obligated Readable Actions
2017 27,200,000.00 27.20 million 13
2018 22,000,000.00 22.00 million 3
2019 1,315,246.38 1.32 million 3

Insight

Obligations on this vehicle were highly concentrated in 2017, at $27.20 million across 13 awards, then declined to $22.00 million in 2018 across 3 awards and to $1.32 million in 2019 across 3 awards. The pattern indicates a steep post-2017 drop in annual funding and a shift away from the initial high-obligation period. Award volume also contracted sharply after 2017, with activity remaining limited in 2018 and 2019.

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.