ZenotiHelp

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.