ZenotiHelp

Center Holidays Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing holiday definitions for centers, including the holiday date, description, and whether it recurs annually.

Columns

Column Name Data Type Nullable Description
centerholidaywid BIGINT IDENTITY No Surrogate warehouse key for the center holiday record
centerholidayid VARCHAR(36) Yes Unique identifier (GUID) for the center holiday
centerid VARCHAR(36) Yes Unique identifier (GUID) of the center
holiday TIMESTAMP Yes Date/time of the holiday
holiday_desc VARCHAR(800) Yes Description or name of the holiday
recurring BOOLEAN Yes Indicates whether the holiday recurs annually
void BOOLEAN Yes Indicates whether the record has been voided/soft-deleted

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

centerholidaywid

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
recurring FALSE = One-time, TRUE = Recurring Annually
Was this article helpful?
Your feedback helps us improve our documentation.