ZenotiHelp

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.