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.