Org Dispositions Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Dimension table storing organization-level disposition definitions used for categorizing outcomes or follow-up actions.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| orgdispositionwid | BIGINT IDENTITY | No | Surrogate warehouse key for the organization disposition (Primary Key) |
| orgdispositionid | VARCHAR(36) | Yes | Natural unique identifier (GUID) for the disposition |
| followupdays | INTEGER | Yes | Number of days for follow-up associated with this disposition |
| void | BOOLEAN | Yes | Soft-delete flag indicating if the record is voided |
| description | VARCHAR(65535) | Yes | Detailed description of the disposition |
| dispositionname | VARCHAR(65535) | Yes | Display name of the disposition |
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
orgdispositionwid
Foreign Keys
This table has no foreign key relationships to other analytics tables.
Was this article helpful?
Your feedback helps us improve our documentation.