Appearance
dbo.ethSyncSchedule
Info Generated by
scripts/Generate-DataDictionary.ps1- do not edit by hand. Edit descriptions inschemas/tables/dbo.ethSyncSchedule.jsonand regenerate.
Columns
| # | Column | Type | Nullable | Flags | Description |
|---|---|---|---|---|---|
| 1 | Table | nvarchar(100) | no | Name of the table/entity this sync scheduling configuration applies to. | |
| 2 | SyncDurationDays | int | no | Size in days of the date window pulled from Prime Ecosystem on each sync run for this table. | |
| 3 | LookbackDays | int | no | Number of extra days before the sync cursor to re-check on each run, to catch late-arriving or updated records. | |
| 4 | LocalMaxColumn | nvarchar(100) | no | Name 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

