FPDS Query Library
About Us
Contact Us

PIID

Procurement Instrument Identifier for the IDV record. It is the alphanumeric code that uniquely identifies the indefinite delivery vehicle instrument or related contract record in FPDS.

Family: IDV
Category: Contract Identification
Data Type: identifier_or_code
Semantic Type: identifier
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__IDV__contractID__IDVID__PIID
Title
PIID
FPDS Path
IDV/contractID/IDVID/PIID
Description
Procurement Instrument Identifier for the IDV record. It is the alphanumeric code that uniquely identifies the indefinite delivery vehicle instrument or related contract record in FPDS.
Business Meaning
This identifier is essential for tracking a specific procurement instrument across actions, amendments, modifications, and reporting snapshots. Analysts use it to distinguish one vehicle from another, measure award activity, and link related transactions within the same contract family.
Example Value
GS29F8656A
Observed Non-Null Count
5,862,557

FPDS Compare

FPDS Query Variable
content__IDV__contractID__IDVID__PIID
FPDS XML Path
IDV/contractID/IDVID/PIID
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'IDV/contractID/IDVID/PIID' into the SQL-ready variable 'content__IDV__contractID__IDVID__PIID'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building

Common Usage

  • Join related FPDS records for the same vehicle or award
  • Deduplicate or group actions by instrument
  • Filter awards and modifications by specific contract identifier

Common Mistakes

  • Assuming the value is a description instead of an identifier
  • Normalizing or truncating the code in a way that breaks joins

Query Guidance

Use exact string matching for joins and filters, preserving punctuation and case if present in the source. When grouping, pair this field with agency or parent instrument fields if you need to avoid collisions across reporting units or naming conventions.

SQL Examples

Preview values

SELECT
    content__IDV__contractID__IDVID__PIID AS p_i_i_d
FROM fpds.data
WHERE content__IDV__contractID__IDVID__PIID IS NOT NULL
LIMIT 25

Top values

SELECT
    content__IDV__contractID__IDVID__PIID AS value,
    count() AS record_count
FROM fpds.data
WHERE content__IDV__contractID__IDVID__PIID IS NOT NULL
GROUP BY value
ORDER BY record_count DESC
LIMIT 25

Each dictionary item includes SQL-ready examples generated alongside the variable metadata, allowing immediate use in FPDS Query for filtering, aggregation, and analysis.