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.