Guest tier changes fact table
Bi_FactGuestTierChanges
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
|---|---|---|---|---|---|
BaseCenterID | bigint | Center ID of the center to which the guest belongs to | Bi_DimCenter Centerwid | ||
CurrentTierwid | bigint | Loyalty point tier ID to which a guest belongs to | |||
EndDate | DATE | Date till which a guest belongs to a tier | |||
etlCreatedDate | TIMESTAMP | Latest timestamp at which the corresponding record was either inserted or updated in this table. | |||
Guestwid | bigint | Unique identifier for the guest | Bi_Dimuser userwid | ||
GuestTierChangesId | numeric(19) | Unique identifier for the row. Primary Key | |||
GuestTierChangeswid | bigint | Unique identifier for the row. Primary Key | Yes | ||
OrganizationID | VARCHAR(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter OrganizationId | ||
PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
PreviousTierwid | bigint | Previous tier from which guest moved to "CurrentTierID" tier | |||
StartDate | DATE | Start date from which guest belongs to a tier | |||
Void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||