Reasons dimension table
bi_dimreasons
Field | Description | Field Type | Primary Key |
|---|---|---|---|
actiontype | integer | ||
active | boolean | ||
createddate | timestamp without time zone | ||
description | varchar ( 65535 ) | ||
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 | |
objecttype | integer | ||
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
reason | The reason for cancellation. | varchar ( 65535 ) | |
reasoncode | The unique code for each cancellation reason. This is a mandatory field that must be filled for every appointment that is cancelled. | varchar ( 1024 ) | |
reasonid | varchar ( 36 ) | ||
reasonpk | bigint | ||
reasonwid | bigint | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |