ZenotiHelp

Issue Categories Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing issue category definitions used to classify and group issues at the category level.

Columns

Column Name Data Type Nullable Description
issuecategorywid BIGINT IDENTITY No Surrogate warehouse key for the issue category (Primary Key)
issuecategoryid VARCHAR(36) Yes Natural unique identifier (GUID) for the issue category
categorycode VARCHAR(256) Yes Short code representing the issue category
categoryname VARCHAR(256) Yes Display name of the issue category
categorydescription VARCHAR(4096) Yes Detailed description of the issue category
active BOOLEAN Yes Flag indicating if the category is currently active
void BOOLEAN Yes Soft-delete flag indicating if the record is voided

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

issuecategorywid

Foreign Keys

This table has no foreign key relationships to other analytics tables.

Was this article helpful?
Your feedback helps us improve our documentation.