ZenotiHelp

Center Working Hours Exceptions Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing exception dates for center working hours, including modified open/close times, online booking windows, and peak hour overrides.

Columns

Column Name Data Type Nullable Description
centerworkinghourexceptionwid BIGINT IDENTITY No Surrogate warehouse key for the center working hour exception record
exceptiondatepk BIGINT Yes Source system primary key for the exception date
centerid VARCHAR(36) Yes Unique identifier (GUID) of the center
exceptiondate DATE Yes The specific date for which working hours are modified
opentime DOUBLE PRECISION Yes Modified opening time for the exception date (stored as fractional hours)
closetime DOUBLE PRECISION Yes Modified closing time for the exception date (stored as fractional hours)
onlinebookingstart DOUBLE PRECISION Yes Start time for online bookings on the exception date (stored as fractional hours)
onlinebookingend DOUBLE PRECISION Yes End time for online bookings on the exception date (stored as fractional hours)
peakstart DOUBLE PRECISION Yes Start time of peak hours on the exception date (stored as fractional hours)
peakend DOUBLE PRECISION Yes End time of peak hours on the exception date (stored as fractional hours)
void BOOLEAN Yes Indicates whether the record has been voided/soft-deleted
createddate DATE Yes Date when the exception record was created

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

centerworkinghourexceptionwid

Foreign Keys

Column References
centerid a center entity in the source system
organizationid an organization entity in the source system

Enumerator Values

Column Values
void FALSE = Active, TRUE = Voided
Was this article helpful?
Your feedback helps us improve our documentation.