FPDS Query Library
About Us
Contact Us

Version

Identifier for the reported version of the IDV record in FPDS. It captures the revision or iteration level of the IDV entry, such as an initial load or a later update.

Family: IDV
Category: General
Data Type: string
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__IDV__version
Title
Version
FPDS Path
IDV/version
Description
Identifier for the reported version of the IDV record in FPDS. It captures the revision or iteration level of the IDV entry, such as an initial load or a later update.
Business Meaning
This field helps analysts distinguish among multiple versions of the same IDV record and understand record evolution over time. It is useful for tracking updates, validating which record state is current, and supporting version-based comparisons in procurement analysis.
Example Value
1.2
Observed Non-Null Count
5,862,557

FPDS Compare

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

Use Cases

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

Common Usage

  • identify the latest version of an IDV record
  • compare changes across record revisions
  • deduplicate or rank multiple versions of the same IDV

Common Mistakes

  • treating version as a contract type or procurement attribute
  • assuming the highest version is always the most current without checking update dates

Query Guidance

Use in grouping or window functions with the IDV identifier to rank revisions, for example partition by the IDV key and order by version or associated modification date. If version values are stored as strings, cast or normalize them before numeric comparison to avoid lexical sorting errors.

SQL Examples

Preview values

SELECT
    content__IDV__version AS version
FROM fpds.data
WHERE content__IDV__version IS NOT NULL
LIMIT 25

Top values

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