Org LP Tier dimension table
Table Name | Column Name | Column Type | Primary Key | Mapped Dimension Table | Mapped Dimension Table Column |
|---|---|---|---|---|---|
Bi_DimOrgLPTier_s3 | LPTierPK | INT | PK | ||
Bi_DimOrgLPTier_s3 | TierId | VARCHAR(36) | |||
Bi_DimOrgLPTier_s3 | OrganizationId | VARCHAR(36) | |||
Bi_DimOrgLPTier_s3 | TierName | NVARCHAR(512) | |||
Bi_DimOrgLPTier_s3 | MinSpent | DECIMAL(19,4) | |||
Bi_DimOrgLPTier_s3 | DaysToStayBeforeDowngrade | INT | |||
Bi_DimOrgLPTier_s3 | ExpiryInDaysForPointsEarned | INT | |||
Bi_DimOrgLPTier_s3 | Void | BOOLEAN | |||
Bi_DimOrgLPTier_s3 | TierDesc | NVARCHAR(65535) | |||
Bi_DimOrgLPTier_s3 | LPItemTypesMask | INT | |||
Bi_DimOrgLPTier_s3 | MinSpentToStay | FLOAT | |||
Bi_DimOrgLPTier_s3 | AllowRedemtpionByThisTierGuests | BOOLEAN | |||
Bi_DimOrgLPTier_s3 | AllowDowngradeToThisTier | BOOLEAN | |||
Bi_DimOrgLPTier_s3 | LpTierIcon | INT | |||
Bi_DimOrgLPTier_s3 | ExchangeRate | FLOAT | |||
Bi_DimOrgLPTier_s3 | EtlLastUpdatedOn | TIMESTAMP | |||
Bi_DimOrgLPTier_s3 | EtlLastUpdatedBy | NVARCHAR(50) | |||
Bi_DimOrgLPTier_s3 | PodName | VARCHAR(20) | |||
Bi_DimOrgLPTier_s3 | groupid | BIGINT |