FPDS Query Library
About Us
Contact Us

Signed Date

The date on which the IDV was signed by the government and contractor, recorded as a timestamp/string value. It marks the formal execution date of the umbrella award that establishes the reusable contracting vehicle.

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

Variable Overview

FPDS Query Variable
content__IDV__relevantContractDates__signedDate
Title
Signed Date
FPDS Path
IDV/relevantContractDates/signedDate
Description
The date on which the IDV was signed by the government and contractor, recorded as a timestamp/string value. It marks the formal execution date of the umbrella award that establishes the reusable contracting vehicle.
Business Meaning
This date anchors when the IDV became effective for procurement analysis, supporting lifecycle reporting, award timing, and period-based grouping. Analysts use it to measure acquisition activity by fiscal year, compare award timing across vehicles, and align later orders or modifications to the originating award.
Example Value
1991-12-01 00:00:00
Observed Non-Null Count
5,862,557

FPDS Compare

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

Use Cases

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

Common Usage

  • grouping IDVs by fiscal year or quarter
  • filtering awards signed within a reporting period
  • anchoring analysis of downstream task or delivery orders

Common Mistakes

  • confusing signed date with obligation date or performance start date
  • treating the timestamp text as a true date without parsing

Query Guidance

Cast or convert the field to a DATE/DATETIME type before comparison, grouping, or date arithmetic. Use it in WHERE clauses for award-period filtering and in date truncation functions for time-series reporting; if the column can be null or malformed, apply validation and exclude non-date values.

SQL Examples

Preview values

SELECT
    content__IDV__relevantContractDates__signedDate AS signed_date
FROM fpds.data
WHERE content__IDV__relevantContractDates__signedDate IS NOT NULL
LIMIT 25

Top values

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