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.