Gift card user dimension table
Table Name | Column Name | Column Type | Primary Key | Mapped Dimension Table | Mapped Dimension Table Column |
|---|---|---|---|---|---|
Bi_DimGiftCardUser_s3 | GiftCardUserId | VARCHAR(36) | PK | ||
Bi_DimGiftCardUser_s3 | GiftCardId | VARCHAR(36) | |||
Bi_DimGiftCardUser_s3 | UserId | VARCHAR(36) | |||
Bi_DimGiftCardUser_s3 | SaleById | VARCHAR(36) | |||
Bi_DimGiftCardUser_s3 | PurchaseDate | TIMESTAMP | |||
Bi_DimGiftCardUser_s3 | ExpirationDate | DATE | |||
Bi_DimGiftCardUser_s3 | CenterId | VARCHAR(36) | |||
Bi_DimGiftCardUser_s3 | void | BOOLEAN | |||
Bi_DimGiftCardUser_s3 | closed | BOOLEAN | |||
Bi_DimGiftCardUser_s3 | closedOn | TIMESTAMP | |||
Bi_DimGiftCardUser_s3 | closedby | VARCHAR(36) | |||
Bi_DimGiftCardUser_s3 | OrganizationId | VARCHAR(36) | |||
Bi_DimGiftCardUser_s3 | GiftCardCode | NVARCHAR(256) | |||
Bi_DimGiftCardUser_s3 | GiftCardValue | DECIMAL(19,4) | |||
Bi_DimGiftCardUser_s3 | GiftCardPurchasePrice | DECIMAL(19,4) | |||
Bi_DimGiftCardUser_s3 | IsGiftCard | BOOLEAN | |||
Bi_DimGiftCardUser_s3 | FirstName | NVARCHAR(160) | |||
Bi_DimGiftCardUser_s3 | LastName | NVARCHAR(256) | |||
Bi_DimGiftCardUser_s3 | EtlLastUpdatedOn | TIMESTAMP | |||
Bi_DimGiftCardUser_s3 | EtlLastUpdatedBy | NVARCHAR(50) | |||
Bi_DimGiftCardUser_s3 | PodName | VARCHAR(20) | |||
Bi_DimGiftCardUser_s3 | groupid | BIGINT |