FPDS Query Library
About Us
Contact Us

Current Completion Date

Stores the current planned completion date for the underlying Other Transaction IDV contract. It represents the date through which the agreement is currently expected to remain in effect, based on the latest available record.

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

Variable Overview

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__relevantContractDates__currentCompletionDate
Title
Current Completion Date
FPDS Path
OtherTransactionIDV/contractDetail/relevantContractDates/currentCompletionDate
Description
Stores the current planned completion date for the underlying Other Transaction IDV contract. It represents the date through which the agreement is currently expected to remain in effect, based on the latest available record.
Business Meaning
This date is important for measuring vehicle duration, assessing remaining period of performance, and identifying expiring or extended procurement instruments. Analysts use it to study award lifecycle timing, renewal patterns, and future obligations tied to Other Transaction IDVs.
Example Value
2027-04-19 00:00:00
Observed Non-Null Count
13,417

FPDS Compare

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__relevantContractDates__currentCompletionDate
FPDS XML Path
OtherTransactionIDV/contractDetail/relevantContractDates/currentCompletionDate
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionIDV/contractDetail/relevantContractDates/currentCompletionDate' into the SQL-ready variable 'content__OtherTransactionIDV__contractDetail__relevantContractDates__currentCompletionDate'.

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 time remaining until contract expiration
  • Group awards by fiscal year or quarter of expected completion
  • Flag instruments nearing end of performance

Common Mistakes

  • Confusing the current completion date with the original completion date
  • Using the raw string without converting it to a proper date type

Query Guidance

Parse this field as a timestamp/date and use it for filtering, sorting, and date-difference calculations. In SQL, compare it against report dates with explicit casting, and if multiple record versions exist, select the latest available current completion date for each award or transaction.

SQL Examples

Preview values

SELECT
    content__OtherTransactionIDV__contractDetail__relevantContractDates__currentCompletionDate AS current_completion_date
FROM fpds.data
WHERE content__OtherTransactionIDV__contractDetail__relevantContractDates__currentCompletionDate IS NOT NULL
LIMIT 25

Top values

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