Organization loyalty points tier dimension table
bi_dimorglptier
Field | Description | Field Type | Primary Key |
|---|---|---|---|
allowdowngradetothistier | integer | ||
allowredemtpionbythistierguests | integer | ||
daystostaybeforedowngrade | integer | ||
dimorglptierwid | bigint | ||
etllastupdatedby | ETL system admin user who inserted or updated the corresponding record in this table. | varchar ( 50 ) | |
etllastupdatedon | Latest timestamp at which the corresponding record was either inserted or updated in this table. | timestamp without time zone | |
exchangerate | double precision | ||
expiryindaysforpointsearned | integer | ||
lpitemtypesmask | integer | ||
lptiericon | integer | ||
lptierpk | integer | ||
minspent | double precision | ||
minspenttostay | double precision | ||
organizationid | varchar ( 65535 ) | ||
podname | varchar ( 20 ) | ||
tierdesc | varchar ( 65535 ) | ||
tierid | varchar ( 65535 ) | ||
tiername | Name of the corresponding loyalty tier. | varchar ( 65535 ) | |
void | integer | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |