ZenotiHelp

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.