ZenotiHelp

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.