ZenotiHelp

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.