FPDS Query Library
About Us
Contact Us

Total Base and All Options Value

Numeric amount representing the total value of the IDV at award, including the base amount plus all potential option amounts. It is a contract-level ceiling-style value reported in FPDS for indefinite delivery vehicles.

Family: IDV
Category: Total Dollar Values
Data Type: numeric
Semantic Type: financial
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__IDV__totalDollarValues__totalBaseAndAllOptionsValue
Title
Total Base and All Options Value
FPDS Path
IDV/totalDollarValues/totalBaseAndAllOptionsValue
Description
Numeric amount representing the total value of the IDV at award, including the base amount plus all potential option amounts. It is a contract-level ceiling-style value reported in FPDS for indefinite delivery vehicles.
Business Meaning
This field supports spend forecasting, obligation and ceiling analysis, market sizing, and comparison of award magnitude across IDVs. Analysts use it to understand the maximum reported contractual value, not just the initial funded amount.
Example Value
0
Observed Non-Null Count
5,862,557

FPDS Compare

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

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • Spending aggregation and trend analysis

Common Usage

  • Sizing the maximum reported value of IDV awards
  • Ranking contracts by potential dollar exposure
  • Trend analysis of award values over time

Common Mistakes

  • Using it as a proxy for obligated spend
  • Comparing it directly to base-only or task-order obligation fields without noting scope differences

Query Guidance

Use the field as a numeric measure in aggregations, filters, and percentile calculations, and exclude nulls or zeros only when analytically justified. When comparing awards, pair it with award date, agency, and IDV identifiers; do not sum across related versions of the same award without deduplication or record-level filtering.

SQL Examples

Preview values

SELECT
    content__IDV__totalDollarValues__totalBaseAndAllOptionsValue AS total_base_and_all_options_value
FROM fpds.data
WHERE content__IDV__totalDollarValues__totalBaseAndAllOptionsValue IS NOT NULL
LIMIT 25

Aggregate total

SELECT
    sum(content__IDV__totalDollarValues__totalBaseAndAllOptionsValue) AS total_value
FROM fpds.data
WHERE content__IDV__totalDollarValues__totalBaseAndAllOptionsValue IS NOT NULL

Distribution overview

SELECT
    min(content__IDV__totalDollarValues__totalBaseAndAllOptionsValue) AS min_value,
    avg(content__IDV__totalDollarValues__totalBaseAndAllOptionsValue) AS avg_value,
    max(content__IDV__totalDollarValues__totalBaseAndAllOptionsValue) AS max_value,
    count() AS record_count
FROM fpds.data
WHERE content__IDV__totalDollarValues__totalBaseAndAllOptionsValue IS NOT NULL

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