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.