ZenotiHelp

Employee Worktasks Payroll Fact Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Records employee work task payroll details including hours worked, pay rates, task assignments, and payroll period information for attendance-based compensation.

Columns

Column Name Data Type Nullable Description
factemployeeworktaskspayrollwid BIGINT IDENTITY NOT NULL Surrogate key for the employee work tasks payroll fact record
factempworktaskid NUMERIC(19,0) NULL Business/natural key for the employee work task
employeewid BIGINT NULL Foreign key to the employee user dimension
worktaskwid BIGINT NULL Foreign key to the work task dimension
isprimary BOOLEAN NULL Indicates if this is the employee's primary work task
totalworktaskhours FLOAT NULL Total hours worked on the task
worktaskrate NUMERIC(19,4) NULL Rate of pay for the work task
worktaskpay NUMERIC(19,4) NULL Total pay amount for the work task
payrollcenterwid BIGINT NULL Foreign key to the center processing payroll
payrollstartdate DATE NULL Start date of the payroll period
PayrollendDate DATE NULL End date of the payroll period
attendancecenterwid BIGINT NULL Foreign key to the center where attendance was recorded
void BOOLEAN NULL Indicates whether the record has been voided
payrollbatchid VARCHAR(36) NULL Unique identifier (GUID) of the payroll batch
attendancedate DATE NULL Date of the employee attendance record
isproductionhours BOOLEAN NULL Indicates if the hours are classified as production hours
payrate NUMERIC(19,4) NULL Employee's pay rate

Note: All fact tables also include standard ETL metadata columns (podname, organizationid, groupid, etlCreatedDate) which are omitted from this reference for brevity.

Primary Key

factemployeeworktaskspayrollwid

Foreign Keys

Column References
employeewid Bi_DimUser.userwid
payrollcenterwid Bi_DimCenter.centerwid
attendancecenterwid Bi_DimCenter.centerwid
payrollstartdate Bi_DimDate.datewid
PayrollendDate Bi_DimDate.datewid
attendancedate Bi_DimDate.datewid

Enumerator Values

Column Values
void FALSE = Active, TRUE = Voided
isprimary TRUE if this is the primary work task, FALSE otherwise
isproductionhours TRUE if classified as production hours, FALSE otherwise
Was this article helpful?
Your feedback helps us improve our documentation.