FPDS Query Library
About Us
Contact Us

Cost or Pricing Data

Boolean or coded flag indicating whether cost or pricing data was used for the award. It captures the contract-data condition recorded in FPDS and is typically represented as a yes/no value such as Y or N.

Family: Award
Category: Contract Data
Data Type: boolean_or_code_flag
Semantic Type: flag
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__award__contractData__costOrPricingData
Title
Cost or Pricing Data
FPDS Path
award/contractData/costOrPricingData
Description
Boolean or coded flag indicating whether cost or pricing data was used for the award. It captures the contract-data condition recorded in FPDS and is typically represented as a yes/no value such as Y or N.
Business Meaning
This field matters because it helps identify awards subject to cost or pricing data requirements, which are relevant for compliance review, pricing strategy analysis, and monitoring acquisition methods that trigger certified pricing data. Analysts also use it to segment awards by pricing regime and assess patterns in negotiated procurements.
Example Value
N
Observed Non-Null Count
57,358,878

FPDS Compare

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

Use Cases

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

Common Usage

  • Filter awards where cost or pricing data was used
  • Segment procurements for pricing compliance analysis
  • Compare pricing requirements across contract types or award methods

Common Mistakes

  • Assuming N always means no pricing review occurred rather than no cost or pricing data was used
  • Treating missing, blank, or null values the same as a valid N without checking data quality rules

Query Guidance

Use this field as a filter or grouping variable in SQL, typically with exact matching on the stored flag values. For example, restrict to records where the field equals Y when analyzing awards that used cost or pricing data, and handle nulls explicitly if you need to distinguish unknown from false.

SQL Examples

Preview values

SELECT
    content__award__contractData__costOrPricingData AS cost_or_pricing_data
FROM fpds.data
WHERE content__award__contractData__costOrPricingData IS NOT NULL
LIMIT 25

Flag distribution

SELECT
    content__award__contractData__costOrPricingData AS flag_value,
    count() AS record_count
FROM fpds.data
WHERE content__award__contractData__costOrPricingData IS NOT NULL
GROUP BY flag_value
ORDER BY record_count DESC

Each dictionary item includes SQL-ready examples generated alongside the variable metadata, allowing immediate use in FPDS Query for filtering, aggregation, and analysis.