Recurrence Details Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Dimension table storing recurrence schedule definitions for standing appointments, including interval, time period, start/end dates, and day-of-week configuration. Populated from the appointment recurrence configuration.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| recurrencedetailswid | BIGINT IDENTITY | No | Surrogate warehouse key for the recurrence details dimension |
| recurrenceid | VARCHAR(36) | Yes | Natural unique identifier of the recurrence schedule |
| centerid | VARCHAR(36) | Yes | Identifier of the center where the recurrence applies |
| createdby | VARCHAR(36) | Yes | Identifier of the user who created the recurrence |
| createon | TIMESTAMP | Yes | Timestamp when the recurrence was created |
| enddate | TIMESTAMP | Yes | End date/time of the recurrence schedule |
| interval | INTEGER | Yes | Numeric interval between occurrences (reserved keyword, quoted in DDL) |
| isperpetual | SMALLINT | Yes | Flag indicating whether the recurrence repeats indefinitely (1 = perpetual) |
| lastupdated | TIMESTAMP | Yes | Timestamp of the last update in the source system |
| occurences | INTEGER | Yes | Total number of occurrences in the recurrence schedule |
| standingappts | SMALLINT | Yes | Flag indicating whether standing appointments are enabled |
| startdate | TIMESTAMP | Yes | Start date/time of the recurrence schedule |
| timeperiod | VARCHAR(100) | Yes | Unit of time for the interval (e.g., Day, Week, Month) |
| unchecked | SMALLINT | Yes | Flag indicating whether the recurrence has been unchecked/disabled |
| weekdays | INTEGER | Yes | Bitmask representing the days of the week the recurrence is active |
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
recurrencedetailswid
Foreign Keys
| Column | References |
|---|---|
| centerid | Bi_DimCenter.centerid |
| createdby | Bi_DimEmployee / Bi_DimUser |
Enumerator Values
| Column | Values |
|---|---|
| timeperiod | Day Week Month Year |
| weekdays | Bitmask: 1 = Sunday 2 = Monday 4 = Tuesday 8 = Wednesday 16 = Thursday 32 = Friday 64 = Saturday |
Was this article helpful?
Your feedback helps us improve our documentation.