FPDS Query Library
About Us
Contact Us

PIID

Identifier of the referenced IDV contract’s Procurement Instrument Identifier (PIID). It is the code that names the parent ordering vehicle or base indefinite delivery vehicle record to which this contract record points.

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__referencedIDVID__PIID
Title
PIID
FPDS Path
IDV/contractID/referencedIDVID/PIID
Description
Identifier of the referenced IDV contract’s Procurement Instrument Identifier (PIID). It is the code that names the parent ordering vehicle or base indefinite delivery vehicle record to which this contract record points.
Business Meaning
This field is essential for linking actions back to the underlying IDV and for analyzing how orders, modifications, and related awards flow from a specific vehicle. Analysts use it to measure obligation activity, vendor usage, and award relationships across the IDV hierarchy.
Example Value
GS00F084CA
Observed Non-Null Count
133,244

FPDS Compare

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

Use Cases

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

Common Usage

  • Join referenced actions to the parent IDV contract
  • Group obligations by contract vehicle
  • Filter records linked to a specific IDV

Common Mistakes

  • Assuming the value is human-readable rather than a code
  • Joining on this field alone when the full contract key is required

Query Guidance

Use exact equality joins and filters on the identifier value, typically against the parent IDV PIID or full contract identifier key. If the dataset contains case or formatting variation, normalize before joining; do not use text searches unless you are deliberately doing pattern-based review.

SQL Examples

Preview values

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

Top values

SELECT
    content__IDV__contractID__referencedIDVID__PIID AS value,
    count() AS record_count
FROM fpds.data
WHERE content__IDV__contractID__referencedIDVID__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.