FPDS Query Library
About Us
Contact Us

Physical Completion Date

The date on which the IDV is considered physically complete, meaning the work or deliverables under the contract have been finished. In FPDS, this is a NASA-specific date attribute stored as a string in date-time format.

Family: IDV
Category: NASA Specific Fields
Data Type: string
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__IDV__agencySpecificIDVElements__NASASpecificIDVElements__physicalCompletionDate
Title
Physical Completion Date
FPDS Path
IDV/agencySpecificIDVElements/NASASpecificIDVElements/physicalCompletionDate
Description
The date on which the IDV is considered physically complete, meaning the work or deliverables under the contract have been finished. In FPDS, this is a NASA-specific date attribute stored as a string in date-time format.
Business Meaning
This field helps analysts measure contract completion timing, assess lifecycle performance, and distinguish physical completion from administrative closeout. It is useful for workload tracking, schedule analysis, and evaluating whether delivery milestones were met across NASA procurement actions.
Example Value
2025-08-29 00:00:00
Observed Non-Null Count
2,475

FPDS Compare

FPDS Query Variable
content__IDV__agencySpecificIDVElements__NASASpecificIDVElements__physicalCompletionDate
FPDS XML Path
IDV/agencySpecificIDVElements/NASASpecificIDVElements/physicalCompletionDate
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'IDV/agencySpecificIDVElements/NASASpecificIDVElements/physicalCompletionDate' into the SQL-ready variable 'content__IDV__agencySpecificIDVElements__NASASpecificIDVElements__physicalCompletionDate'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • NASA-specific IDV record interpretation

Common Usage

  • Identify contracts that have reached physical completion
  • Calculate elapsed time from award or period start to completion
  • Group awards by completion year or month

Common Mistakes

  • Using it as the same thing as final closeout or administrative completion
  • Comparing the raw string without converting it to a date type

Query Guidance

Convert the field to a date/timestamp in SQL, then use it in WHERE clauses for completion status, in GROUP BY for completion periods, and in date-difference calculations against award or performance dates. If the field is null or blank, treat the action as not physically complete unless another source provides a later completion indicator.

SQL Examples

Preview values

SELECT
    content__IDV__agencySpecificIDVElements__NASASpecificIDVElements__physicalCompletionDate AS physical_completion_date
FROM fpds.data
WHERE content__IDV__agencySpecificIDVElements__NASASpecificIDVElements__physicalCompletionDate IS NOT NULL
LIMIT 25

Top values

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