FPDS Query Library
About Us
Contact Us

Signed Date

The date on which the Other Transaction Award contract was signed. It records the execution date of the agreement in the award record, stored as a string timestamp value.

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__signedDate
Title
Signed Date
FPDS Path
OtherTransactionAward/contractDetail/relevantContractDates/signedDate
Description
The date on which the Other Transaction Award contract was signed. It records the execution date of the agreement in the award record, stored as a string timestamp value.
Business Meaning
This field anchors the timing of an Other Transaction Award and is useful for measuring award activity, sequencing procurement events, and aligning awards to fiscal periods, reporting cycles, or policy changes. It supports analysis of when obligations or agreements were formally executed, which is important for trend analysis and audit review.
Example Value
2023-04-13 00:00:00
Observed Non-Null Count
38,894

FPDS Compare

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

  • trend analysis of award timing by month, quarter, or fiscal year
  • filtering awards signed within a reporting window
  • sequencing signed date against other contract milestones

Common Mistakes

  • confusing signed date with obligated date or posted date
  • treating the string value as already typed date data without conversion

Query Guidance

Parse the string into a date or timestamp field before filtering, grouping, or joining on time logic. In SQL, use date conversion functions and compare on the normalized date value, for example to build fiscal-period summaries or to filter records where signed date falls between two endpoints.

SQL Examples

Preview values

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

Top values

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