FPDS Query Library
About Us
Contact Us

Price Evaluation Percent Difference

Percentage difference used in the award’s price evaluation record. It captures how the evaluated price varied relative to the comparison basis in the competition data, and is stored as a string value such as "0.00".

Family: Award
Category: Competition
Data Type: string
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__award__competition__priceEvaluationPercentDifference
Title
Price Evaluation Percent Difference
FPDS Path
award/competition/priceEvaluationPercentDifference
Description
Percentage difference used in the award’s price evaluation record. It captures how the evaluated price varied relative to the comparison basis in the competition data, and is stored as a string value such as "0.00".
Business Meaning
This field helps analysts assess price competitiveness and the degree of price separation among offers or sourcing outcomes. It can be useful when reviewing whether an award reflected full and open competition, limited competition, or a noncompetitive decision with a recorded price evaluation outcome.
Example Value
0.00
Observed Non-Null Count
23,092,041

FPDS Compare

FPDS Query Variable
content__award__competition__priceEvaluationPercentDifference
FPDS XML Path
award/competition/priceEvaluationPercentDifference
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'award/competition/priceEvaluationPercentDifference' into the SQL-ready variable 'content__award__competition__priceEvaluationPercentDifference'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • Competition and sole-source analysis

Common Usage

  • Compare price spread across competed awards
  • Identify awards with minimal or no price separation
  • Support anomaly review for unusually high evaluated price differences

Common Mistakes

  • Treating the string as a number without conversion
  • Interpreting the percentage without checking the related competition context

Query Guidance

Use CAST/SAFE_CAST to convert the string to a numeric type before analysis, and filter or join with competition status fields when interpreting results. Example pattern: CAST(content__award__competition__priceEvaluationPercentDifference AS DECIMAL(10,2)).

SQL Examples

Preview values

SELECT
    content__award__competition__priceEvaluationPercentDifference AS price_evaluation_percent_difference
FROM fpds.data
WHERE content__award__competition__priceEvaluationPercentDifference IS NOT NULL
LIMIT 25

Top values

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