ZenotiHelp

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.