ZenotiHelp

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.