FPDS Query Library
About Us
Contact Us

Ultimate Completion Date

This field stores the ultimate completion date for the Other Transaction Award contract detail. It represents the planned or recorded final date by which the agreement is expected to be fully completed.

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

Variable Overview

FPDS Query Variable
content__OtherTransactionAward__contractDetail__relevantContractDates__ultimateCompletionDate
Title
Ultimate Completion Date
FPDS Path
OtherTransactionAward/contractDetail/relevantContractDates/ultimateCompletionDate
Description
This field stores the ultimate completion date for the Other Transaction Award contract detail. It represents the planned or recorded final date by which the agreement is expected to be fully completed.
Business Meaning
Analysts use this date to understand the expected end of performance for an award, measure award duration, and compare contractual timelines across transactions. It supports trend analysis, lifecycle segmentation, and checks for awards that should have ended but remain active in reporting.
Example Value
2019-08-31 00:00:00
Observed Non-Null Count
38,894

FPDS Compare

FPDS Query Variable
content__OtherTransactionAward__contractDetail__relevantContractDates__ultimateCompletionDate
FPDS XML Path
OtherTransactionAward/contractDetail/relevantContractDates/ultimateCompletionDate
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionAward/contractDetail/relevantContractDates/ultimateCompletionDate' into the SQL-ready variable 'content__OtherTransactionAward__contractDetail__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

  • calculate award duration from start date to completion date
  • group awards by expected end month or fiscal year
  • identify overdue or still-open awards past completion

Common Mistakes

  • assuming it is always the actual completion date rather than the reported ultimate end date
  • comparing the raw string without casting to a date data type

Query Guidance

Cast the field to a date or timestamp in SQL, then use it for filters, joins, and date-based aggregations. Prefer date comparisons over string comparisons, and pair it with award start or obligation dates when calculating lifecycle metrics.

SQL Examples

Preview values

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

Top values

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