FPDS Query Library
About Us
Contact Us

Last Modified Date

Timestamp showing when the FPDS transaction record was most recently changed. It is a system-maintained audit attribute, not the procurement action date itself.

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

Variable Overview

FPDS Query Variable
content__IDV__transactionInformation__lastModifiedDate
Title
Last Modified Date
FPDS Path
IDV/transactionInformation/lastModifiedDate
Description
Timestamp showing when the FPDS transaction record was most recently changed. It is a system-maintained audit attribute, not the procurement action date itself.
Business Meaning
This field helps analysts identify when records were updated, support data refresh tracking, and distinguish newly ingested or revised records from older submissions. It is useful for incremental extracts, change detection, and understanding whether a record reflects the latest available reporting status.
Example Value
2022-11-19 13:00:01
Observed Non-Null Count
4,672,382

FPDS Compare

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

Use Cases

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

Common Usage

  • incremental refresh and delta loads
  • identifying recently updated FPDS records
  • auditing data recency and change windows

Common Mistakes

  • using last modified date as the procurement action date
  • comparing raw strings without timestamp conversion

Query Guidance

Cast the field to a timestamp and filter or sort on that value when checking recency or change history. Example pattern: WHERE CAST(content__IDV__transactionInformation__lastModifiedDate AS TIMESTAMP) >= :cutoff. Use it for ETL watermarking and record version analysis, not for obligation or award timing.

SQL Examples

Preview values

SELECT
    content__IDV__transactionInformation__lastModifiedDate AS last_modified_date
FROM fpds.data
WHERE content__IDV__transactionInformation__lastModifiedDate IS NOT NULL
LIMIT 25

Top values

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