ZenotiHelp

Loyalty Point Actions Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table defining the types of actions that can earn or redeem loyalty points within an organization.

Columns

Column Name Data Type Nullable Description
actionwid BIGINT IDENTITY No Surrogate warehouse key for the loyalty point action record
actionid VARCHAR(65535) Yes Unique identifier for the loyalty point action
actionname VARCHAR(65535) Yes Display name of the loyalty point action
displayorder VARCHAR(65535) Yes Display order/sort position for the action in UI listings
void BOOLEAN Yes Indicates whether the record has been voided/soft-deleted

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

actionwid

Foreign Keys

Column References
organizationid an organization entity in the source system

Enumerator Values

Column Values
void FALSE = Active, TRUE = Voided
Was this article helpful?
Your feedback helps us improve our documentation.