Skip to content

dbo.ethSyncSchedule ​

Info Generated by scripts/Generate-DataDictionary.ps1 - do not edit by hand. Edit descriptions in schemas/tables/dbo.ethSyncSchedule.json and regenerate.

Columns ​

#ColumnTypeNullableFlagsDescription
1Tablenvarchar(100)noName of the table/entity this sync scheduling configuration applies to.
2SyncDurationDaysintnoSize in days of the date window pulled from Prime Ecosystem on each sync run for this table.
3LookbackDaysintnoNumber of extra days before the sync cursor to re-check on each run, to catch late-arriving or updated records.
4LocalMaxColumnnvarchar(100)noName of the local table column (defaults to UpdatedAt) used to check the actual latest synced value as a guardrail against an ahead-of-reality sync cursor.

Referenced by ​

Procedures: dbo.spEthSyncGetNextDates, dbo.spEthSyncGetNextDates_primeHistory