FPDS Query Library
About Us
Contact Us

Base and Exercised Options Value

Numeric dollar amount representing the value of the base contract plus any exercised options reported for an Other Transaction IDV record. It is a financial measure captured in the FPDS contract detail dollar values section.

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

Variable Overview

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__dollarValues__baseAndExercisedOptionsValue
Title
Base and Exercised Options Value
FPDS Path
OtherTransactionIDV/contractDetail/dollarValues/baseAndExercisedOptionsValue
Description
Numeric dollar amount representing the value of the base contract plus any exercised options reported for an Other Transaction IDV record. It is a financial measure captured in the FPDS contract detail dollar values section.
Business Meaning
This field is used to assess the realized size of an Other Transaction IDV award after options that have already been exercised are included. It supports spending analysis, obligation comparisons, trend analysis, and market sizing for procurement portfolios.
Example Value
0
Observed Non-Null Count
13,417

FPDS Compare

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__dollarValues__baseAndExercisedOptionsValue
FPDS XML Path
OtherTransactionIDV/contractDetail/dollarValues/baseAndExercisedOptionsValue
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionIDV/contractDetail/dollarValues/baseAndExercisedOptionsValue' into the SQL-ready variable 'content__OtherTransactionIDV__contractDetail__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

  • Calculate realized award value for Other Transaction IDVs
  • Compare contract size across agencies, vendors, or fiscal years
  • Build spend and market-sizing summaries

Common Mistakes

  • Treating the field as a description or code instead of a numeric dollar amount
  • Adding exercised option value again when total award value already includes it

Query Guidance

Cast and aggregate as a numeric dollar field, typically SUM(baseAndExercisedOptionsValue) for portfolio analysis. Filter or coalesce NULLs explicitly, and join with related dollar-value fields only when you need to distinguish base value from option-inclusive value.

SQL Examples

Preview values

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

Aggregate total

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

Distribution overview

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