Reasons Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Dimension table storing configurable reason codes used across cancellations, refunds, and other business actions. Each row represents a reason associated with a specific object type and action type within an organization.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| reasonwid | BIGINT IDENTITY | No | Surrogate warehouse key for the reasons dimension |
| reasonid | VARCHAR(36) | Yes | Natural unique identifier of the reason |
| reasoncode | VARCHAR(1024) | Yes | Short code identifying the reason |
| reason | VARCHAR(65535) | Yes | Full text of the reason |
| description | VARCHAR(65535) | Yes | Detailed description of the reason |
| objecttype | INTEGER | Yes | Enumerated type of the business object the reason applies to (e.g., Membership, Invoice) |
| actiontype | INTEGER | Yes | Enumerated type of the action the reason applies to (e.g., Cancellation, Refund) |
| active | BOOLEAN | Yes | Flag indicating whether the reason is currently active |
| createddate | TIMESTAMP | Yes | Timestamp when the reason was created |
| reasonpk | BIGINT | Yes | Source system primary key for the reason |
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
reasonwid
Foreign Keys
This table has no foreign key relationships to other analytics tables.
Enumerator Values
| Column | Values |
|---|---|
| objecttype | 1 = Membership 2 = Appointment 3 = Invoice 4 = Package |
| actiontype | 1 = Cancellation 2 = Refund 3 = NoShow 4 = Freeze 5 = Suspension |
Was this article helpful?
Your feedback helps us improve our documentation.