Issue Priority Type Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Dimension table storing issue priority type definitions, representing the urgency or importance levels that can be assigned to issues.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| prioritytypewid | BIGINT IDENTITY | No | Surrogate warehouse key for the issue priority type (Primary Key) |
| pk | NUMERIC(19,0) | Yes | Source system primary key for the priority type record |
| prioritytypeid | VARCHAR(36) | Yes | Natural unique identifier (GUID) for the priority type |
| priority | INTEGER | Yes | Numeric priority level or sort order |
| priorityname | VARCHAR(256) | Yes | Display name of the priority type (e.g., High, Medium, Low) |
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
prioritytypewid
Foreign Keys
This table has no foreign key relationships to other analytics tables.
Was this article helpful?
Your feedback helps us improve our documentation.