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.