Work tasks dimension table
bi_dimworktasks
Field | Description | Field Type | Primary Key |
|---|---|---|---|
active | boolean | ||
createdby | varchar ( 36 ) | ||
createddate | timestamp without time zone | ||
description | varchar ( 4096 ) | ||
etllastupdatedby | ETL system admin user who inserted or updated the corresponding record in this table. | varchar ( 50 ) | |
etllastupdatedon | Latest timestamp at which the corresponding record was either inserted or updated in this table. | timestamp without time zone | |
isproductionhours | boolean | ||
lastupdated | timestamp without time zone | ||
lastupdatedby | varchar ( 36 ) | ||
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
void | boolean | ||
worktaskcode | The code associated with the 'worktaskname'. | varchar ( 512 ) | |
worktaskid | varchar ( 36 ) | ||
worktaskname | The name of the work task. These are tasks that employees can undertake beyond their principal job. It is advised that employees check-in and checkout separately for each such task so that an accurate log of their work is maintained in Zenoti. | varchar ( 1024 ) | |
worktaskpk | numeric | ||
worktaskswid | bigint | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |