Appointment Categories Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Dimension table storing appointment category definitions including display colors, ordering, and activation status. Populated from the organization's appointment category configuration.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| appointmentcategorywid | BIGINT IDENTITY | No | Surrogate warehouse key for the appointment categories dimension |
| appointmentcategoryid | VARCHAR(36) | Yes | Natural unique identifier of the appointment category |
| appointmentcategorycode | VARCHAR(1024) | Yes | Short code identifying the appointment category |
| appointmentcategoryname | VARCHAR(1024) | Yes | Display name of the appointment category |
| appointmentcategoryorder | INTEGER | Yes | Sort order for displaying categories in the UI |
| indicatorcolor | VARCHAR(256) | Yes | Hex or named color used as the category indicator in the calendar |
| textcolor | VARCHAR(256) | Yes | Hex or named color used for the category text label |
| overrideappointmentcolor | BOOLEAN | Yes | Flag indicating whether this category color overrides the default appointment color |
| active | BOOLEAN | Yes | Flag indicating whether the appointment category is currently active |
| void | BOOLEAN | Yes | Soft-delete flag; TRUE means the record is logically deleted |
Note: All dimension tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlLastUpdatedOn,etlLastUpdatedBy) which are omitted from this reference for brevity.
Primary Key
appointmentcategorywid
Foreign Keys
This table has no foreign key relationships to other analytics tables.
Was this article helpful?
Your feedback helps us improve our documentation.