ZenotiHelp

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.