Appointment categories dimension table
Bi_DimAppointmentCategories
Field | Description | Field Type | Primary Key |
|---|---|---|---|
active | A flag indicating if the appointment category is active. | boolean | |
appointmentcategorycode | Appointment categories can be created when we navigate to Categories > Appointments. | varchar ( 1024 ) | |
appointmentcategoryid | unique identifier for the appointment category | varchar ( 36 ) | |
appointmentcategoryname | The name of the appointment category. | varchar ( 1024 ) | |
appointmentcategoryorder | integer | ||
appointmentcategorywid | unique identifier for the appointment category | 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 | |
indicatorcolor | colour used to indicate the appointment category in the product | varchar ( 256 ) | |
organizationid | Unique identifier for the organization | varchar ( 36 ) | |
overrideappointmentcolor | indicates if color set for appointment can be overridden | boolean | |
podname | varchar ( 20 ) | ||
textcolor | colour of text indicating the appointment category | varchar ( 256 ) | |
void | indicates if appointment category is void or not | boolean | |
groupid | Internal to Zenoti. Used for data processing. | BIGINT |