ZenotiHelp

Org LP Tier Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table defining loyalty point tier levels within an organization, including spend thresholds, downgrade rules, point expiry, and exchange rates.

Columns

Column Name Data Type Nullable Description
dimorglptierwid BIGINT IDENTITY No Surrogate warehouse key for the organization loyalty point tier record
lptierpk INTEGER Yes Source system primary key for the loyalty point tier
tierid VARCHAR(65535) Yes Unique identifier for the loyalty point tier
tiername VARCHAR(65535) Yes Display name of the tier level
minspent DOUBLE PRECISION Yes Minimum amount spent to qualify for this tier
daystostaybeforedowngrade INTEGER Yes Number of days a guest remains in this tier before being downgraded
expiryindaysforpointsearned INTEGER Yes Number of days before earned points expire for this tier
void INTEGER Yes Indicates whether the record has been voided/soft-deleted
tierdesc VARCHAR(65535) Yes Description of the tier level
lpitemtypesmask INTEGER Yes Bitmask indicating which item types contribute to loyalty points
minspenttostay DOUBLE PRECISION Yes Minimum amount that must be spent to remain in this tier
allowredemtpionbythistierguests INTEGER Yes Flag indicating whether guests in this tier are allowed to redeem points
allowdowngradetothistier INTEGER Yes Flag indicating whether downgrades to this tier are allowed
lptiericon INTEGER Yes Icon identifier used to represent this tier in the UI
exchangerate DOUBLE PRECISION Yes Exchange rate for converting points to monetary value in this tier

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

dimorglptierwid

Foreign Keys

Column References
organizationid an organization entity in the source system

Enumerator Values

Column Values
void 0 = Active, 1 = Voided
lpitemtypesmask Bitmask: 1 = Service
2 = Product
4 = Membership
8 = Package
16 = Gift Card
32 = Class
allowredemtpionbythistierguests 0 = Not Allowed
1 = Redemption Allowed
allowdowngradetothistier 0 = Not Allowed
1 = Downgrade Allowed
lptiericon 1 = Bronze
2 = Silver
3 = Gold
4 = Platinum
Was this article helpful?
Your feedback helps us improve our documentation.