ZenotiHelp

Employee Declare Tips Fact Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Records employee-declared tip amounts by date and center for payroll and tax reporting purposes.

Columns

Column Name Data Type Nullable Description
factemployeedeclaretipswid BIGINT IDENTITY NOT NULL Surrogate key for the employee declared tips fact record
factdeclaretipid NUMERIC(19,0) NULL Business/natural key for the declared tips record
employeewid BIGINT NULL Foreign key to the employee user dimension
declaredtip NUMERIC(19,4) NULL Declared tip amount by the employee
declareddate DATE NULL Date for which tips were declared
centerwid BIGINT NULL Foreign key to the center dimension
void BOOLEAN NULL Indicates whether the record has been voided

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

Primary Key

factemployeedeclaretipswid

Foreign Keys

Column References
employeewid Bi_DimUser.userwid
centerwid Bi_DimCenter.centerwid
declareddate Bi_DimDate.datewid

Enumerator Values

Column Values
void FALSE = Active, TRUE = Voided
Was this article helpful?
Your feedback helps us improve our documentation.