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.