ZenotiHelp

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.