ZenotiHelp

Issue Source Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing issue source definitions, identifying the channel or origin from which issues are reported.

Columns

Column Name Data Type Nullable Description
issuesourcewid BIGINT IDENTITY No Surrogate warehouse key for the issue source (Primary Key)
issuesourceid VARCHAR(36) Yes Natural unique identifier (GUID) for the issue source
sourcename VARCHAR(256) Yes Display name of the issue source
sourcecode VARCHAR(256) Yes Short code representing the issue source
sourcedescription VARCHAR(4096) Yes Detailed description of the issue source
active BOOLEAN Yes Flag indicating if the source is currently active
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

issuesourcewid

Foreign Keys

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

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