FPDS Query Library
About Us
Contact Us

Fee Range Lower Value

Lower bound of the fee range recorded for the contract marketing record on an IDV. It represents the minimum fee value in the stated range and is stored as a string, so it may require casting before numeric comparison.

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

Variable Overview

FPDS Query Variable
content__IDV__contractMarketingData__feeRangeLowerValue
Title
Fee Range Lower Value
FPDS Path
IDV/contractMarketingData/feeRangeLowerValue
Description
Lower bound of the fee range recorded for the contract marketing record on an IDV. It represents the minimum fee value in the stated range and is stored as a string, so it may require casting before numeric comparison.
Business Meaning
This field helps analysts understand the pricing or fee structure associated with marketed IDVs and supports segmentation of contracts by fee band. It can be useful when comparing solicitation terms, reviewing market strategy, or grouping awards with similar fee characteristics.
Example Value
26.00
Observed Non-Null Count
46,814

FPDS Compare

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

Use Cases

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

Common Usage

  • filter IDVs by minimum fee threshold
  • group awards into fee bands
  • compare fee structures across contract marketing records

Common Mistakes

  • treating the lower value as the actual fee rather than a range boundary
  • using string comparison instead of numeric casting

Query Guidance

Use this field with explicit numeric conversion when filtering or ordering, for example CAST(NULLIF(content__IDV__contractMarketingData__feeRangeLowerValue,'') AS DECIMAL(...)). Join or pair it with the upper-bound fee field to evaluate the full range, and handle blanks or non-numeric text defensively.

SQL Examples

Preview values

SELECT
    content__IDV__contractMarketingData__feeRangeLowerValue AS fee_range_lower_value
FROM fpds.data
WHERE content__IDV__contractMarketingData__feeRangeLowerValue IS NOT NULL
LIMIT 25

Top values

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