Package benefits dimension table
Table Name | Column Name | Column Type | Primary Key | Mapped Dimension Table |
|---|---|---|---|---|
Bi_DimPackageBenefits_s3 | PackageId | VARCHAR(36) | ||
Bi_DimPackageBenefits_s3 | PackageVersionId | VARCHAR(36) | ||
Bi_DimPackageBenefits_s3 | OrganizationID | VARCHAR(36) | ||
Bi_DimPackageBenefits_s3 | BenefitType | VARCHAR(50) | ||
Bi_DimPackageBenefits_s3 | PK | DECIMAL(19 | PK | |
Bi_DimPackageBenefits_s3 | itemid | VARCHAR(36) | ||
Bi_DimPackageBenefits_s3 | itemtype | INT | ||
Bi_DimPackageBenefits_s3 | Quantity | INT | ||
Bi_DimPackageBenefits_s3 | ItemTags | VARCHAR(MAX) | ||
Bi_DimPackageBenefits_s3 | void | BOOLEAN | ||
Bi_DimPackageBenefits_s3 | EtlLastUpdatedOn | TIMESTAMP | ||
Bi_DimPackageBenefits_s3 | EtlLastUpdatedBy | NVARCHAR(50) | ||
Bi_DimPackageBenefits_s3 | PodName | VARCHAR(20) | ||
Bi_DimPackageBenefits_s3 | groupid | BIGINT |