Recurrence details dimension table
bi_dimrecurrencedetails
Field | Description | Field Type | Primary Key |
|---|---|---|---|
centerid | varchar ( 36 ) | ||
createdby | varchar ( 36 ) | ||
createon | timestamp without time zone | ||
enddate | timestamp without time zone | ||
etllastupdatedby | ETL system admin user who inserted or updated the corresponding record in this table. | varchar ( 50 ) | |
etllastupdatedon | Latest timestamp at which the corresponding record was either inserted or updated in this table. | timestamp without time zone | |
interval | integer | ||
isperpetual | smallint | ||
lastupdated | timestamp without time zone | ||
occurences | The maximum number of times the appointment is set to recur. This is the value that was set when the recurring appointment was created and it is not updated if the future appointments are cancelled. Note: This number gets duplicated for all the appointments in a recurring group. | integer | |
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
recurrencedetailswid | bigint | ||
recurrenceid | varchar ( 36 ) | ||
standingappts | smallint | ||
startdate | The start date and time of the first appointment in the appointment group which was set to recur. This field can be used to identify the first appointment from where the recurring appointments started. | timestamp without time zone | |
timeperiod | The frequency of the recurring appointment. Possible values: - Daily - Weekly - Monthly - Yearly | varchar ( 100 ) | |
unchecked | smallint | ||
weekdays | integer | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |