FPDS Query Library
About Us
Contact Us

Created Date

Timestamp showing when the FPDS transaction record was created in the source system. It is a system-generated datetime attribute for the Other Transaction IDV transaction detail, not the procurement action date itself.

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

Variable Overview

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__transactionInformation__createdDate
Title
Created Date
FPDS Path
OtherTransactionIDV/contractDetail/transactionInformation/createdDate
Description
Timestamp showing when the FPDS transaction record was created in the source system. It is a system-generated datetime attribute for the Other Transaction IDV transaction detail, not the procurement action date itself.
Business Meaning
This field helps analysts understand record timing, load order, and when the government first captured the transaction in FPDS. It is useful for audit trails, refresh validation, and distinguishing data creation timing from obligation, award, or modification timing.
Example Value
2019-07-25 11:06:44
Observed Non-Null Count
13,416

FPDS Compare

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

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building

Common Usage

  • audit trail and record provenance checks
  • incremental data refresh and ETL watermarking
  • sorting transactions by capture time

Common Mistakes

  • using it as the award or obligation date
  • comparing it as a plain string without datetime casting

Query Guidance

Cast or parse the value to a timestamp/datetime type before filtering or ordering. Use it in WHERE clauses for ingestion windows, in ORDER BY for record chronology, and in window functions to identify the first-created or latest-created version of a transaction.

SQL Examples

Preview values

SELECT
    content__OtherTransactionIDV__contractDetail__transactionInformation__createdDate AS created_date
FROM fpds.data
WHERE content__OtherTransactionIDV__contractDetail__transactionInformation__createdDate IS NOT NULL
LIMIT 25

Top values

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