Center holidays dimension table
bi_dimcenterholidays
Field | Description | Field Type | Primary Key |
|---|---|---|---|
centerholidayid | unique identifier for the row in the table | varchar ( 36 ) | |
centerholidaywid | unique identifier for the row in the table within the organization | bigint | |
centerid | unique identifier for the center . | varchar ( 36 ) | |
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 | |
holiday | The date of a particular holiday. It is populated only if the 'scheduledate' falls on a holiday. | timestamp without time zone | |
holiday_desc | The description of the holiday. | varchar ( 800 ) | |
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
recurring | indicates if the holiday is recurring iwith a particular frequency | boolean | |
void | A flag indicating whether an earlier declared holiday is valid or not. For example, a holiday may be retracted - in this case, this field shows whether the holiday is still valid. | boolean | |
groupid | Internal to Zenoti. Used for data processing. | BIGINT |