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.