ZenotiHelp

Issue Sub Categories Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing issue sub-category definitions, providing a second level of classification beneath issue categories.

Columns

Column Name Data Type Nullable Description
issuesubcategorywid BIGINT IDENTITY No Surrogate warehouse key for the issue sub-category (Primary Key)
issuesubcategoryid VARCHAR(36) Yes Natural unique identifier (GUID) for the issue sub-category
issuecategoryid VARCHAR(36) Yes Foreign key identifier (GUID) referencing the parent issue category
subcategorycode VARCHAR(256) Yes Short code representing the issue sub-category
active BOOLEAN Yes Flag indicating if the sub-category is currently active
void BOOLEAN Yes Soft-delete flag indicating if the record is voided
subcategorydescription VARCHAR(65535) Yes Detailed description of the issue sub-category
subcategoryname VARCHAR(512) Yes Display name of the issue sub-category

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

issuesubcategorywid

Foreign Keys

Column References
issuecategoryid Bi_DimIssueCategories
Was this article helpful?
Your feedback helps us improve our documentation.