Guest loyalty tier dimension table
bi_dimguestloyaltytier
Field | Description | Field Type | Primary Key |
|---|---|---|---|
centerid | varchar ( 36 ) | ||
enddate | timestamp without time zone | ||
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 | |
firstname | varchar ( 320 ) | ||
guesttierpk | bigint | ||
lastname | varchar ( 512 ) | ||
loyaltytierwid | bigint | ||
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
startdate | timestamp without time zone | ||
tierid | varchar ( 36 ) | ||
tiername | Loyalty tier to which the guest belongs as of the 'etllastupdatedon' timestamp. | varchar ( 2014 ) | |
userid | varchar ( 36 ) | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |