ZenotiHelp

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.