FPDS Query Library
About Us
Contact Us

Base and Exercised Options Value

Numeric dollar amount representing the reported value of the contract base plus any exercised options in the FPDS award record. It captures the obligated value associated with the awarded base and options that have already been exercised, excluding unexercised option amounts.

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

Variable Overview

FPDS Query Variable
content__award__dollarValues__baseAndExercisedOptionsValue
Title
Base and Exercised Options Value
FPDS Path
award/dollarValues/baseAndExercisedOptionsValue
Description
Numeric dollar amount representing the reported value of the contract base plus any exercised options in the FPDS award record. It captures the obligated value associated with the awarded base and options that have already been exercised, excluding unexercised option amounts.
Business Meaning
This field supports spending, obligation, and contract value analysis by reflecting the portion of award value that is available for realized performance. Analysts use it to compare awards on a like-for-like basis, estimate market size, and track how exercised options change the value of federal contracts over time.
Example Value
0
Observed Non-Null Count
111,508,706

FPDS Compare

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

Use Cases

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

Common Usage

  • Award value comparisons across contracts and vendors
  • Spending trend analysis using realized contract value
  • Market sizing based on base plus exercised options

Common Mistakes

  • Confusing exercised options with unexercised option ceiling
  • Using it interchangeably with obligated amount or total potential value

Query Guidance

Use this numeric field in SUM, AVG, MIN/MAX, and percentile calculations after filtering to the award grain you need. In SQL, coalesce nulls only if your analysis requires treating missing values as zero, and always pair it with award identifiers and fiscal timing fields to avoid double counting across modifications or multiple rows per award.

SQL Examples

Preview values

SELECT
    content__award__dollarValues__baseAndExercisedOptionsValue AS base_and_exercised_options_value
FROM fpds.data
WHERE content__award__dollarValues__baseAndExercisedOptionsValue IS NOT NULL
LIMIT 25

Aggregate total

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

Distribution overview

SELECT
    min(content__award__dollarValues__baseAndExercisedOptionsValue) AS min_value,
    avg(content__award__dollarValues__baseAndExercisedOptionsValue) AS avg_value,
    max(content__award__dollarValues__baseAndExercisedOptionsValue) AS max_value,
    count() AS record_count
FROM fpds.data
WHERE content__award__dollarValues__baseAndExercisedOptionsValue 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.