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.