Center Timing Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Dimension table storing center operating hours and online booking time windows per day of the week. Each row represents one day-of-week timing configuration for a center. Populated from the center schedule configuration.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| centertimingwid | BIGINT IDENTITY | No | Surrogate warehouse key for the center timing dimension |
| centertimingpk | NUMERIC(19,0) | Yes | Source system primary key for the center timing record |
| centerid | VARCHAR(36) | Yes | Identifier of the center |
| centerstarttime | DOUBLE PRECISION | Yes | Center opening time expressed as a decimal (e.g., 9.5 = 9:30 AM) |
| centerendtime | DOUBLE PRECISION | Yes | Center closing time expressed as a decimal (e.g., 18.0 = 6:00 PM) |
| onlinebookingstarttime | DOUBLE PRECISION | Yes | Online booking window start time expressed as a decimal |
| onlinebookingendtime | DOUBLE PRECISION | Yes | Online booking window end time expressed as a decimal |
| centername | VARCHAR(512) | Yes | Display name of the center |
| cntrtimngpk | VARCHAR(400) | Yes | Composite or alternate key for the center timing record |
| dayofweek | VARCHAR(320) | Yes | Day of the week the timing applies to (e.g., Monday, Tuesday) |
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
centertimingwid
Foreign Keys
| Column | References |
|---|---|
| centerid | Bi_DimCenter.centerid |
Enumerator Values
| Column | Values |
|---|---|
| dayofweek | 0 = Sunday 1 = Monday 2 = Tuesday 3 = Wednesday 4 = Thursday 5 = Friday 6 = Saturday |
Was this article helpful?
Your feedback helps us improve our documentation.