FPDS Query Library
About Us
Contact Us

Evaluated Preference

Human-readable value recorded for the evaluated preference associated with an IDV competition record. It captures how the preference was identified in FPDS, such as a label like NONE rather than a numeric measure.

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

Variable Overview

FPDS Query Variable
content__IDV__competition__evaluatedPreference
Title
Evaluated Preference
FPDS Path
IDV/competition/evaluatedPreference
Description
Human-readable value recorded for the evaluated preference associated with an IDV competition record. It captures how the preference was identified in FPDS, such as a label like NONE rather than a numeric measure.
Business Meaning
This field helps analysts understand whether a procurement action reflected a preference-based evaluation approach or no preference at all, which is relevant for competition quality, acquisition policy compliance, and segmentation of award patterns. It can also support analysis of market access conditions and how source selection decisions were documented in the IDV record.
Example Value
NONE
Observed Non-Null Count
3,726,567

FPDS Compare

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

Use Cases

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

Common Usage

  • Identify awards recorded with no evaluated preference
  • Segment competitions by preference treatment
  • Cross-tabulate preference status against set-aside or competition outcomes

Common Mistakes

  • Assuming NONE means the action had no policy context rather than no evaluated preference recorded
  • Using the text value as a universal code without checking for alternate spellings or unexpected values

Query Guidance

Use this field as a categorical string filter in WHERE clauses or GROUP BYs, for example to isolate records where content__IDV__competition__evaluatedPreference = 'NONE'. Normalize case and trim whitespace where needed, and validate against the full set of observed values before building analytics.

SQL Examples

Preview values

SELECT
    content__IDV__competition__evaluatedPreference AS evaluated_preference
FROM fpds.data
WHERE content__IDV__competition__evaluatedPreference IS NOT NULL
LIMIT 25

Top values

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