ZenotiHelp

Work Tasks Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing work task definitions used for employee time tracking, including task codes, descriptions, and production-hours classification. Populated from the organization's work task configuration.

Columns

Column Name Data Type Nullable Description
worktaskswid BIGINT IDENTITY No Surrogate warehouse key for the work tasks dimension
worktaskpk NUMERIC(19,0) Yes Source system primary key for the work task
worktaskid VARCHAR(36) Yes Natural unique identifier of the work task
worktaskcode VARCHAR(512) Yes Short code identifying the work task
worktaskname VARCHAR(1024) Yes Display name of the work task
description VARCHAR(4096) Yes Detailed description of the work task
createddate TIMESTAMP Yes Timestamp when the work task was created
lastupdated TIMESTAMP Yes Timestamp of the last update in the source system
createdby VARCHAR(36) Yes Identifier of the user who created the work task
lastupdatedby VARCHAR(36) Yes Identifier of the user who last updated the work task
active BOOLEAN Yes Flag indicating whether the work task is currently active
void BOOLEAN Yes Soft-delete flag; TRUE means the record is logically deleted
IsProductionHours BOOLEAN Yes Flag indicating whether time logged to this task counts as production hours

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

Primary Key

worktaskswid

Foreign Keys

Column References
createdby Bi_DimEmployee / Bi_DimUser
lastupdatedby Bi_DimEmployee / Bi_DimUser
Was this article helpful?
Your feedback helps us improve our documentation.