FPDS Query Library
About Us
Contact Us

PIID

Identifier of the referenced IDV associated with an Other Transaction Award. It is the Procurement Instrument Identifier for the base instrument being pointed to in the award record, used as a coded reference rather than a descriptive label.

Family: Other Transaction Award
Category: Referenced IDV
Data Type: identifier_or_code
Semantic Type: identifier
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__OtherTransactionAward__OtherTransactionAwardID__referencedIDVID__PIID
Title
PIID
FPDS Path
OtherTransactionAward/OtherTransactionAwardID/referencedIDVID/PIID
Description
Identifier of the referenced IDV associated with an Other Transaction Award. It is the Procurement Instrument Identifier for the base instrument being pointed to in the award record, used as a coded reference rather than a descriptive label.
Business Meaning
This field links an Other Transaction Award to its parent or referenced IDV, allowing analysts to trace procurement lineage, measure obligated activity against a broader vehicle, and identify relationships across awards for spend, competition, and portfolio analysis.
Example Value
M678541899000
Observed Non-Null Count
7,585

FPDS Compare

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

Use Cases

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

Common Usage

  • Join OT awards to referenced IDVs
  • Group obligations or counts by base vehicle
  • Validate award lineage and contract hierarchy

Common Mistakes

  • Using it as a human-readable description
  • Assuming uniqueness across all FPDS records without checking award context

Query Guidance

Use exact-match joins and filters on this field when linking OT awards to the referenced IDV. In SQL, normalize casing and whitespace where needed, and avoid casting to numeric types because PII/PID-style identifiers may contain leading zeros or alphanumeric characters.

SQL Examples

Preview values

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

Top values

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