Emp Salary Fact Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Stores employee salary and payroll details including commission, tenure bonus, redo penalties, and deductions per pay period.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| empsalwid | BIGINT IDENTITY | NOT NULL | Surrogate key and primary key for the employee salary record. |
| factemployeesalaryid | BIGINT | YES | Source system identifier for the employee salary fact. |
| employeewid | BIGINT | YES | Foreign key to the employee dimension (Bi_DimUser.userwid). |
| payrollcenterwid | BIGINT | YES | Foreign key to the center where payroll is processed (Bi_DimCenter.centerwid). |
| payperiodname | VARCHAR(1000) | YES | Name of the pay period. |
| payrollstartdate | TIMESTAMP | YES | Start date of the payroll period. |
| payrollenddate | TIMESTAMP | YES | End date of the payroll period. |
| salary | DOUBLE PRECISION | YES | Base salary amount for the pay period. |
| effectivedatestart | TIMESTAMP | YES | Effective start date of the salary record. |
| effectivedateend | TIMESTAMP | YES | Effective end date of the salary record. |
| centercommission | DOUBLE PRECISION | YES | Commission amount earned at the center level. |
| tenurebonus | DOUBLE PRECISION | YES | Bonus amount based on employee tenure. |
| redopenalty | DOUBLE PRECISION | YES | Penalty amount deducted for service redos. |
| emptotaldeductions | DOUBLE PRECISION | YES | Total deductions applied to the employee salary. |
| podid | INTEGER | YES | Identifier for the pod (database partition). |
| void | BOOLEAN | YES | Soft-delete flag indicating the record is logically deleted. |
Note: All fact tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlCreatedDate) which are omitted from this reference for brevity.
Primary Key
empsalwid
Foreign Keys
| Column | References |
|---|---|
| employeewid | Bi_DimUser.userwid |
| payrollcenterwid | Bi_DimCenter.centerwid |
Enumerator Values
| Column | Values |
|---|---|
| void | TRUE if the record is soft-deleted; FALSE otherwise. |
Was this article helpful?
Your feedback helps us improve our documentation.