Status dimension table
bi_dimstatus
Field | Description | Field Type | Primary Key |
|---|---|---|---|
dimstatusid | integer | ||
dimstatuswid | bigint | ||
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 | |
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
statuscode | varchar ( 100 ) | ||
statusdisplayvalue | The current status of the appointment. Possible values: - Cancel - Checkin - Closed - Confirmed - Noshow - Open | varchar ( 100 ) | |
statustypecode | varchar ( 100 ) | ||
statusvalue | integer | ||
void | boolean | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |