Employee Salary Fact Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Stores employee salary and payroll details per pay period, including center commission, tenure bonuses, redo penalties, deductions, and salary amounts.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| factemployeesalarywid | BIGINT IDENTITY | No | Surrogate primary key (auto-generated) |
| factemployeesalaryid | NUMERIC(19,0) | Yes | Source system identifier for the salary fact |
| employeecommissionpk | NUMERIC(19,0) | Yes | Source primary key linking to employee commission |
| employeewid | BIGINT | Yes | Foreign key to the employee (user) dimension |
| centerwid | BIGINT | Yes | Foreign key to the center dimension |
| podid | INTEGER | Yes | Pod identifier for multi-tenant partitioning |
| centercommission | NUMERIC(19,4) | Yes | Commission earned at the center |
| tenurebonus | NUMERIC(19,4) | Yes | Bonus based on employee tenure |
| redopenalty | NUMERIC(19,4) | Yes | Penalty amount for redo services |
| emptotaldeductions | NUMERIC(19,4) | Yes | Total deductions for the employee |
| salary | NUMERIC(19,4) | Yes | Salary amount for the pay period |
| payrollstartdate | DATE | Yes | Start date of the payroll period |
| payrollenddate | DATE | Yes | End date of the payroll period |
| payperiodname | VARCHAR(512) | Yes | Name of the payroll period |
| void | BOOLEAN | Yes | Indicates if the record is voided |
| effectivedatestart | TIMESTAMP | Yes | Effective start date of the salary record |
| effectivedateend | TIMESTAMP | Yes | Effective end date of the salary record |
Note: All fact tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlCreatedDate) which are omitted from this reference for brevity.
Primary Key
factemployeesalarywid
Foreign Keys
| Column | References |
|---|---|
| employeewid | Bi_DimUser.userwid |
| centerwid | Bi_DimCenter.centerwid |
| payrollstartdate | Bi_DimDate.datewid |
| payrollenddate | Bi_DimDate.datewid |
Enumerator Values
| Column | Values |
|---|---|
| void | true = Voided, false = Active |
Was this article helpful?
Your feedback helps us improve our documentation.