Loyalty point programs dimension table
Bi_DimLoyaltyPointPrograms_s3 | ProgramId | VARCHAR(36) | PK | ||
|---|---|---|---|---|---|
Bi_DimLoyaltyPointPrograms_s3 | ProgramName | NVARCHAR(120) | |||
Bi_DimLoyaltyPointPrograms_s3 | ProgramDesc | NVARCHAR(2048) | |||
Bi_DimLoyaltyPointPrograms_s3 | PurchaseDateStart | TIMESTAMP | |||
Bi_DimLoyaltyPointPrograms_s3 | PurchaseDateEnd | TIMESTAMP | |||
Bi_DimLoyaltyPointPrograms_s3 | RedemptionStartDate | TIMESTAMP | |||
Bi_DimLoyaltyPointPrograms_s3 | RedemptionStartDays | INT | |||
Bi_DimLoyaltyPointPrograms_s3 | RedemptionEndDate | TIMESTAMP | |||
Bi_DimLoyaltyPointPrograms_s3 | RedemptionEndDays | INT | |||
Bi_DimLoyaltyPointPrograms_s3 | OrganizationId | VARCHAR(36) | |||
Bi_DimLoyaltyPointPrograms_s3 | void | BOOLEAN | |||
Bi_DimLoyaltyPointPrograms_s3 | AutoApply | BOOLEAN | |||
Bi_DimLoyaltyPointPrograms_s3 | Code | NVARCHAR(128) | |||
Bi_DimLoyaltyPointPrograms_s3 | FreeServiceCommissionEligible | BOOLEAN | |||
Bi_DimLoyaltyPointPrograms_s3 | EtlLastUpdatedOn | TIMESTAMP | |||
Bi_DimLoyaltyPointPrograms_s3 | EtlLastUpdatedBy | NVARCHAR(50) | |||
Bi_DimLoyaltyPointPrograms_s3 | PodName | VARCHAR(20) | |||
Bi_DimLoyaltyPointPrograms_s3 | groupid | BIGINT |