ZenotiHelp

Issue Type Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing issue type definitions used to classify issues by their type.

Columns

Column Name Data Type Nullable Description
issuetypewid BIGINT IDENTITY No Surrogate warehouse key for the issue type (Primary Key)
issuetypeid VARCHAR(36) Yes Natural unique identifier (GUID) for the issue type
issuetypename VARCHAR(1020) Yes Display name of the issue type
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

issuetypewid

Foreign Keys

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

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