FPDS Query Library
About Us
Contact Us

Last Date to Order

The latest date on which orders may be placed against the IDV. It marks the end of the ordering period tied to the indefinite delivery vehicle and is stored as a date-time string.

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__lastDateToOrder
Title
Last Date to Order
FPDS Path
IDV/relevantContractDates/lastDateToOrder
Description
The latest date on which orders may be placed against the IDV. It marks the end of the ordering period tied to the indefinite delivery vehicle and is stored as a date-time string.
Business Meaning
This date determines the effective cutoff for ordering under the vehicle, which is essential for measuring contract lifecycle timing, assessing remaining ordering authority, and segmenting obligations against active versus expired IDVs. It also supports analysis of vehicle usage patterns and compliance with ordering periods.
Example Value
2005-10-27 00:00:00
Observed Non-Null Count
4,567,151

FPDS Compare

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

Use Cases

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

Common Usage

  • Filter IDVs that were open for ordering on a given date
  • Calculate time remaining until ordering authority expires
  • Group IDVs by ordering end month or fiscal period

Common Mistakes

  • Confusing the last date to order with the IDV award date or completion date
  • Comparing the raw string without converting it to a date type

Query Guidance

Cast or parse the field to a date/timestamp and use it in range predicates such as WHERE lastDateToOrder >= CURRENT_DATE. For lifecycle analysis, compare it to obligation or action dates to identify whether orders occurred before the ordering window closed.

SQL Examples

Preview values

SELECT
    content__IDV__relevantContractDates__lastDateToOrder AS last_date_to_order
FROM fpds.data
WHERE content__IDV__relevantContractDates__lastDateToOrder IS NOT NULL
LIMIT 25

Top values

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