ZenotiHelp

Tips Payout Center Settings Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readHow-to

Dimension table storing center-level tips payout configuration including sync, activation, accumulation settings, and their effective date ranges.

Columns

Column Name Data Type Nullable Description
tipspayoutcentersettingswid BIGINT IDENTITY No Surrogate warehouse identifier (auto-generated)
dimtipspayoutcentersettingspk BIGINT No Source system primary key for the center tips payout settings
integrationsettingpk BIGINT Yes Foreign key to the integration setting
centerid VARCHAR(36) Yes Unique identifier of the center
syncdelay INTEGER Yes Delay in minutes before tips are synced
syncstartdate TIMESTAMP Yes Date/time when sync started
active BOOLEAN Yes Indicates if the settings are currently active
activestartdate TIMESTAMP Yes Start date of the active period
activeenddate TIMESTAMP Yes End date of the active period
void BOOLEAN Yes Soft-delete flag
voidstartdate TIMESTAMP Yes Start date of the void period
voidendddate TIMESTAMP Yes End date of the void period
accumulationstatus BOOLEAN Yes Indicates if tip accumulation is enabled
accumulationstatusstartdate TIMESTAMP Yes Start date of the accumulation status
accumulationstatusenddate TIMESTAMP Yes End date of the accumulation status
lastupdatedby VARCHAR(36) Yes User ID who last updated the settings
currentrecord BOOLEAN Yes Indicates if this is the current/active version of the record
lastupdateddate TIMESTAMP Yes Date/time of the last update in the source system
ctetllastupdatedon TIMESTAMP No Center-specific ETL last updated timestamp (defaults to 1900-01-01)
SyncEarningStartDate TIMESTAMP Yes Start date for syncing earnings
AccumulationEarningStartDate TIMESTAMP Yes Start date for accumulating earnings

Note: All dimension tables also include standard ETL metadata columns (podname, organizationid, groupid, etlLastUpdatedOn, etlLastUpdatedBy) which are omitted from this reference for brevity.

Primary Key

tipspayoutcentersettingswid

Foreign Keys

Column References
centerid the center dimension
integrationsettingpk the integration setting dimension
Was this article helpful?
Your feedback helps us improve our documentation.