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.