Loyalty point programs dimension table
bi_dimloyaltypointprograms
Field | Description | Field Type | Primary Key |
|---|---|---|---|
autoapply | integer | ||
code | varchar ( 65535 ) | ||
customerid | varchar ( 65535 ) | ||
dimloyaltypointprogramwid | 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 | |
freeservicecommissioneligible | integer | ||
organizationid | varchar ( 65535 ) | ||
podname | varchar ( 20 ) | ||
programdesc | varchar ( 65535 ) | ||
programid | varchar ( 65535 ) | ||
programname | Name of the program using which loyalty points are accrued or redeemed. | varchar ( 65535 ) | |
purchasedateend | timestamp without time zone | ||
purchasedatestart | timestamp without time zone | ||
rebookserviceptstype | integer | ||
redemptionenddate | timestamp without time zone | ||
redemptionenddays | integer | ||
redemptionstartdate | timestamp without time zone | ||
redemptionstartdays | integer | ||
restricttomembers | integer | ||
void | integer | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |