Guest tier changes fact table
TableName | Field | Field Type | Description | PrimaryKey | MappedDimensionTable | DimensionTableField |
Bi_FactGuestTierChanges_s3 | GuestTierChangesId | DECIMAL(19,0) | Unique identifier for the row. Primary Key | Yes | ||
Bi_FactGuestTierChanges_s3 | GuestId | VARCHAR(36) | Unique identifier for the guest | Bi_Dimuser_s3 | userid | |
Bi_FactGuestTierChanges_s3 | BaseCenterID | VARCHAR(36) | Center ID of the center to which the guest belongs to | Bi_DimCenter_s3 | CenterId | |
Bi_FactGuestTierChanges_s3 | StartDate | DATE | Start date from which guest belongs to a tier | |||
Bi_FactGuestTierChanges_s3 | EndDate | DATE | Date till which a guest belongs to a tier | |||
Bi_FactGuestTierChanges_s3 | CurrentTierID | VARCHAR(36) | Loyalty point tier ID to which a guest belongs to | |||
Bi_FactGuestTierChanges_s3 | PreviousTierID | VARCHAR(36) | Previous tier from which guest moved to "CurrentTierID" tier | |||
Bi_FactGuestTierChanges_s3 | Void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
Bi_FactGuestTierChanges_s3 | PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
Bi_FactGuestTierChanges_s3 | OrganizationID | VARCHAR(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter_s3 | OrganizationId | |
Bi_FactGuestTierChanges_s3 | groupid | BIGINT | Internal to Zenoti. Used for data processing. | |||