FPDS Query Library
About Us
Contact Us

Ultimate Completion Date

The date on which contract performance is expected to end under the award's final completion schedule. It represents the ultimate contractual completion point, not an interim milestone or option period date.

Family: Award
Category: Dates
Data Type: string
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__award__relevantContractDates__ultimateCompletionDate
Title
Ultimate Completion Date
FPDS Path
award/relevantContractDates/ultimateCompletionDate
Description
The date on which contract performance is expected to end under the award's final completion schedule. It represents the ultimate contractual completion point, not an interim milestone or option period date.
Business Meaning
This field helps analysts measure expected contract duration, compare planned versus actual completion timing, and identify long-running awards or schedule extensions. It is useful for cohorting awards by end date, monitoring expiring obligations, and supporting performance and lifecycle analysis.
Example Value
2005-09-30 00:00:00
Observed Non-Null Count
97,848,422

FPDS Compare

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

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • Timeline, cohort, and period analysis

Common Usage

  • Filtering awards that end in a given fiscal year or quarter
  • Calculating planned contract duration or time to completion
  • Identifying awards approaching or past their ultimate end date

Common Mistakes

  • Treating it as a delivery milestone rather than the final contract end date
  • Comparing the raw string without casting to a date type

Query Guidance

Cast the value to a date/timestamp before use, then filter or group on the converted field. Use it for end-date-based cohorting, aging calculations, and expiration logic; avoid using it as a substitute for award date or base period start date.

SQL Examples

Preview values

SELECT
    content__award__relevantContractDates__ultimateCompletionDate AS ultimate_completion_date
FROM fpds.data
WHERE content__award__relevantContractDates__ultimateCompletionDate IS NOT NULL
LIMIT 25

Top values

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