Employee Declare Tips Fact Consolidated
ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide
Consolidated fact table storing employee-declared tip amounts by date and center.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| organization name | VARCHAR(512) | YES | Name of the organization. Sourced from DimOrganization.organization_name. |
| organization account name | VARCHAR(256) | YES | Account name of the organization. Sourced from DimOrganization.organization_account_name. |
| zone name | VARCHAR(800) | YES | Name of the zone. Sourced from DimZone.zone_name. |
| center name | VARCHAR(128) | YES | Name of the center. Sourced from DimCenter.center_name. |
| center city | VARCHAR(128) | YES | City where the center is located. Sourced from DimCenter.center_city. |
| center zip | VARCHAR(32) | YES | ZIP/postal code of the center. Sourced from DimCenter.center_zip. |
| center state name | VARCHAR(4096) | YES | State where the center is located. Sourced from DimCenter.center_state_name. |
| country name | VARCHAR(4096) | YES | Country where the center is located. Sourced from DimCenter.country_name. |
| operating center | BOOLEAN | YES | Indicates whether the center is an operating center. Sourced from DimCenter.operating_center. |
| employee first name | VARCHAR(256) | YES | First name of the employee. Sourced from DimEmployee.employee_first_name. |
| employee last name | VARCHAR(256) | YES | Last name of the employee. Sourced from DimEmployee.employee_last_name. |
| employee middle name | VARCHAR(256) | YES | Middle name of the employee. Sourced from DimEmployee.employee_middle_name. |
| employee mobile phone | VARCHAR(64) | YES | Mobile phone number of the employee. Sourced from DimEmployee.employee_mobile_phone. |
| employee code | VARCHAR(128) | YES | Code assigned to the employee. Sourced from DimEmployee.employee_code. |
| employee - code | VARCHAR(512) | YES | Alternate employee code format. Sourced from DimEmployee.employee_code. |
| employee gender | VARCHAR(14) | YES | Gender of the employee. Sourced from DimEmployee.employee_gender. |
| employee job name | VARCHAR(1020) | YES | Job title of the employee. Sourced from DimEmployee.employee_job_name. |
| is employee inactive | BOOLEAN | YES | Indicates whether the employee is inactive. Sourced from DimEmployee.is_employee_inactive. |
| declared tip | NUMERIC(19,4) | YES | Amount of tip declared by the employee. |
| declared date | DATE | YES | Date on which the tip was declared. |
| fact employee declare tips wid | BIGINT | YES | Warehouse ID for the declared tips fact record. |
| Center Code | VARCHAR(40) | YES | Code assigned to the center. Sourced from DimCenter.center_code. |
Primary Key
fact employee declare tips wid (BIGINT)
Foreign Keys
- Employee columns reference DimEmployee
- Center columns reference DimCenter
Enumerator Values
| Column Name | Known Values |
|---|---|
| employee gender | Male, Female, Other |
Standard ETL metadata columns (EtlLastUpdatedOn, EtlLastUpdatedBy, podname, groupid) are present in the underlying table but omitted from this reference for brevity.
Was this article helpful?
Your feedback helps us improve our documentation.