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.