ZenotiHelp

Issue Treatment Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing issue treatment definitions, representing the remedial actions or treatments that can be applied to resolve issues.

Columns

Column Name Data Type Nullable Description
issuetreatmentwid BIGINT IDENTITY No Surrogate warehouse key for the issue treatment (Primary Key)
issuetreatmentid VARCHAR(36) Yes Natural unique identifier (GUID) for the issue treatment
treatmentcode VARCHAR(256) Yes Short code representing the issue treatment
treatmentname VARCHAR(256) Yes Display name of the issue treatment
treatmentdescription VARCHAR(4096) Yes Detailed description of the issue treatment
active BOOLEAN Yes Flag indicating if the treatment 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

issuetreatmentwid

Foreign Keys

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

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