ZenotiHelp

Employee Salary Fact Consolidated

ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide

Consolidated employee salary fact table combining salary and payroll details with employee and center dimensions for compensation analytics.

Columns

Column Name Data Type Nullable Description
organization name VARCHAR(512) Yes Name of the organization. Sourced from Dim_Organization.organization_name.
organization account name VARCHAR(256) Yes Account name of the organization. Sourced from Dim_Organization.organization_account_name.
zone name VARCHAR(800) Yes Name of the zone the center belongs to. Sourced from Dim_Center.zone_name.
center name VARCHAR(128) Yes Name of the center. Sourced from Dim_Center.center_name.
center city VARCHAR(128) Yes City where the center is located. Sourced from Dim_Center.center_city.
center zip VARCHAR(32) Yes Zip/postal code of the center. Sourced from Dim_Center.center_zip.
center state name VARCHAR(4096) Yes State name of the center. Sourced from Dim_Center.center_state_name.
country name VARCHAR(4096) Yes Country name of the center. Sourced from Dim_Center.country_name.
operating center BOOLEAN Yes Whether the center is an operating center. Sourced from Dim_Center.operating_center.
employee first name VARCHAR(256) Yes First name of the employee. Sourced from Dim_Employee.first_name.
employee last name VARCHAR(256) Yes Last name of the employee. Sourced from Dim_Employee.last_name.
employee middle name VARCHAR(256) Yes Middle name of the employee. Sourced from Dim_Employee.middle_name.
employee mobile phone VARCHAR(64) Yes Mobile phone of the employee. Sourced from Dim_Employee.mobile_phone.
employee code VARCHAR(128) Yes Code of the employee. Sourced from Dim_Employee.employee_code.
employee - code VARCHAR(512) Yes Alternate code of the employee. Sourced from Dim_Employee.employee_code_alt.
employee gender VARCHAR(14) Yes Gender of the employee. Sourced from Dim_Employee.gender.
employee job name VARCHAR(1020) Yes Job title of the employee. Sourced from Dim_Employee.job_name.
is employee inactive BOOLEAN Yes Whether the employee is inactive. Sourced from Dim_Employee.is_inactive.
center commission NUMERIC(19,4) Yes Center-level commission amount. Sourced from Fact_EmployeeSalary.center_commission.
tenue bonus NUMERIC(19,4) Yes Tenure bonus amount. Sourced from Fact_EmployeeSalary.tenue_bonus.
redo penalty NUMERIC(19,4) Yes Redo penalty amount. Sourced from Fact_EmployeeSalary.redo_penalty.
employee total deduction NUMERIC(19,4) Yes Total deduction from employee salary. Sourced from Fact_EmployeeSalary.employee_total_deduction.
salary NUMERIC(19,4) Yes Employee salary amount. Sourced from Fact_EmployeeSalary.salary.
payroll start date DATE Yes Start date of the payroll period. Sourced from Fact_EmployeeSalary.payroll_start_date.
payroll end date DATE Yes End date of the payroll period. Sourced from Fact_EmployeeSalary.payroll_end_date.
pay period name VARCHAR(512) Yes Name of the pay period. Sourced from Fact_EmployeeSalary.pay_period_name.
minutes to add INTEGER Yes Minutes offset to add for timezone conversion. Sourced from Dim_Center.minutes_to_add.
fact employee salary wid BIGINT Yes Warehouse identifier for the employee salary fact. Sourced from Fact_EmployeeSalary.wid.
Center Code VARCHAR(40) Yes Code of the center. Sourced from Dim_Center.center_code.

Primary Key

No explicit primary key defined. The fact employee salary wid serves as the logical warehouse identifier.

Foreign Keys

  • fact employee salary wid - Warehouse identifier for the salary fact (also used as DISTKEY)

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.