PDI Transaction Data Feeds — Reference Table Timestamp Enhancements (April 2026)

These changes will come into effect at our next data refresh (May 2)

Schema Change

PDI is enhancing the reference tables in transaction data feeds to provide more accurate tracking information. The CREATED_AT and UPDATED_AT fields on Stores, Stores Status, Master GTIN, and TDLinx tables will now accurately reflect when a record was first added to the system and when it was last modified. Previously, these timestamp fields were not reliable for tracking record history.

What's Changing

The following reference tables will receive corrected timestamps:

Stores
Stores Status
Master GTIN
TDLinx

The CREATED_AT field will represent when the record was first added, and the UPDATED_AT field will represent when the record was last modified. This enhancement enables use cases such as identifying newly onboarded stores, tracking when stores first entered the PDI network, understanding when products were first mapped, and monitoring when store or product metadata was last changed.

Workflow Impact

New Record Detection: If you are using CREATED_AT = CURRENT_DATE to detect new records, consider comparing against your last download timestamp instead to ensure accurate identification of genuinely new records.
Incremental Processing: If you are using UPDATED_AT for incremental processing, your existing logic will continue to work as expected with the enhanced timestamp accuracy.

Important Notes

Historical records will be corrected as part of the upcoming restatement
Transaction-level tables (Transaction Items, Transaction Sets, Payments, etc.) are not affected by this update