Employee Break Category Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Dimension table defining employee break categories including break duration, utilization tracking, and bookability settings within an organization.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| employeebreakcategorywid | BIGINT IDENTITY | No | Surrogate warehouse key for the employee break category record |
| employeebreakcategorypk | NUMERIC(19,0) | Yes | Source system primary key for the break category |
| employeebreakduration | INTEGER | Yes | Default duration of the break in minutes |
| active | BOOLEAN | Yes | Indicates whether the break category is currently active |
| void | BOOLEAN | Yes | Indicates whether the record has been voided/soft-deleted |
| countinutilization | BOOLEAN | Yes | Indicates whether time spent on this break counts toward utilization metrics |
| employeebreakcategorycode | VARCHAR(512) | Yes | Code assigned to the break category |
| employeebreakcategoryname | VARCHAR(1024) | Yes | Display name of the break category |
| accountname | VARCHAR(1024) | Yes | Name of the account associated with the break category |
| organizationname | VARCHAR(1024) | Yes | Name of the organization the break category belongs to |
| bookable | BOOLEAN | Yes | Indicates whether this break category can be booked/scheduled (added via ALTER) |
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
employeebreakcategorywid
Foreign Keys
| Column | References |
|---|---|
| organizationid | an organization entity in the source system |
Enumerator Values
| Column | Values |
|---|---|
| void | FALSE = Active, TRUE = Voided |
| active | FALSE = Inactive, TRUE = Active |
| countinutilization | FALSE = Excluded from Utilization, TRUE = Counts in Utilization |
| bookable | FALSE = Not Bookable, TRUE = Bookable |
Was this article helpful?
Your feedback helps us improve our documentation.