ZenotiHelp

Issue Status Type Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing issue status type definitions, representing the various workflow statuses an issue can have within a given issue type.

Columns

Column Name Data Type Nullable Description
issuestatustypewid BIGINT IDENTITY No Surrogate warehouse key for the issue status type (Primary Key)
pk NUMERIC(19,0) Yes Source system primary key for the issue status type record
issuestatustypeid VARCHAR(36) Yes Natural unique identifier (GUID) for the issue status type
issuetypeid VARCHAR(36) Yes Foreign key identifier (GUID) referencing the parent issue type
priority INTEGER Yes Sort priority or display order for the status
active BOOLEAN Yes Flag indicating if the status is currently active
void BOOLEAN Yes Soft-delete flag indicating if the record is voided
description VARCHAR(65535) Yes Detailed description of the issue status type
statusname VARCHAR(256) Yes Display name of the issue status
code VARCHAR(256) Yes Short code representing the issue status type

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

issuestatustypewid

Foreign Keys

Column References
issuetypeid Bi_DimIssueType
Was this article helpful?
Your feedback helps us improve our documentation.