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.