Tips Payout Employee Settings Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readHow-to
Dimension table storing employee-level tips payout settings including opt-in status and KYC (Know Your Customer) verification status with their effective date ranges.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| tipspayoutemployeesettingswid | BIGINT IDENTITY | No | Surrogate warehouse identifier (auto-generated) |
| dimtipspayoutempsettingspk | BIGINT | Yes | Source system primary key for the employee tips payout settings |
| employeepk | BIGINT | Yes | Source system primary key for the employee |
| employeeid | VARCHAR(36) | Yes | Unique identifier of the employee |
| centerid | VARCHAR(36) | Yes | Unique identifier of the center |
| optinstatus | INTEGER | Yes | Enumerator indicating the employee opt-in status for tips payout |
| optinstatusstartdate | TIMESTAMP | Yes | Start date of the current opt-in status |
| optinstatusenddate | TIMESTAMP | Yes | End date of the current opt-in status |
| kycstatus | INTEGER | Yes | Enumerator indicating the KYC verification status |
| kycstatusstartdate | TIMESTAMP | Yes | Start date of the current KYC status |
| kycstatusenddate | TIMESTAMP | Yes | End date of the current KYC status |
| void | BOOLEAN | Yes | Soft-delete flag |
| currentrecord | BOOLEAN | Yes | Indicates if this is the current/active version of the record |
| ctetllastupdatedon | TIMESTAMP | No | Center-specific ETL last updated timestamp (defaults to 1900-01-01) |
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
tipspayoutemployeesettingswid
Foreign Keys
| Column | References |
|---|---|
| employeepk | |
| centerid | the center dimension |
Enumerator Values
| Column | Values |
|---|---|
| optinstatus | 0 = Not Opted In 1 = Opted In 2 = Opted Out |
| kycstatus | 0 = Pending 1 = Verified 2 = Failed |
Was this article helpful?
Your feedback helps us improve our documentation.