Package dimension table
Table Name | Column Name | Column Type | Primary Key | Mapped Dimension Table |
|---|---|---|---|---|
Bi_DimPackage_s3 | PackageversionID | VARCHAR(36) | PK | |
Bi_DimPackage_s3 | PackageId | VARCHAR(36) |
| |
Bi_DimPackage_s3 | PackageName | NVARCHAR(512) | ||
Bi_DimPackage_s3 | PackageDesc | NVARCHAR(4096) | ||
Bi_DimPackage_s3 | PackageCode | NVARCHAR(512) | ||
Bi_DimPackage_s3 | organizationId | VARCHAR(36) | ||
Bi_DimPackage_s3 | BookingStartDate | TIMESTAMP | ||
Bi_DimPackage_s3 | BookingEndDate | TIMESTAMP | ||
Bi_DimPackage_s3 | AllowGiftCertificates | BOOLEAN | ||
Bi_DimPackage_s3 | PackagePrice | DECIMAL(19,4) | ||
Bi_DimPackage_s3 | ComissionPercentage | FLOAT | ||
Bi_DimPackage_s3 | PackageType | INT | ||
Bi_DimPackage_s3 | ExpirationDays | INT | ||
Bi_DimPackage_s3 | ExpirationDate | TIMESTAMP | ||
Bi_DimPackage_s3 | enddate | TIMESTAMP | ||
Bi_DimPackage_s3 | ComissionEligible | BOOLEAN | ||
Bi_DimPackage_s3 | CommissionFactor | FLOAT | ||
Bi_DimPackage_s3 | PackageLength | INT | ||
Bi_DimPackage_s3 | PackageDisplayName | NVARCHAR(512) | ||
Bi_DimPackage_s3 | PackageCatalogPrice | NVARCHAR(128) | ||
Bi_DimPackage_s3 | Custom | BOOLEAN | ||
Bi_DimPackage_s3 | AllowMembershipRedemption | BOOLEAN | ||
Bi_DimPackage_s3 | ShowPrice | BOOLEAN | ||
Bi_DimPackage_s3 | PackageCategoryId | VARCHAR(36) | ||
Bi_DimPackage_s3 | PackageCategoryName | NVARCHAR(800) | ||
Bi_DimPackage_s3 | PackageCategoryDescription | NVARCHAR(8000) | ||
Bi_DimPackage_s3 | BusinessUnitId | VARCHAR(36) | ||
Bi_DimPackage_s3 | BusinessUnitName | NVARCHAR(800) | ||
Bi_DimPackage_s3 | BusinessUnitDescription | NVARCHAR(8000) | ||
Bi_DimPackage_s3 | IsCustomtemplate | BOOLEAN | ||
Bi_DimPackage_s3 | TemplatePackageVersionId | VARCHAR(36) | ||
Bi_DimPackage_s3 | RedemptionFrequencydays | INT | ||
Bi_DimPackage_s3 | GracePeriod | NVARCHAR(40) | ||
Bi_DimPackage_s3 | Visits | INT | ||
Bi_DimPackage_s3 | TargetName | NVARCHAR(2048) | ||
Bi_DimPackage_s3 | TargetValue | FLOAT | ||
Bi_DimPackage_s3 | CloseOnTargetCompletion | BOOLEAN | ||
Bi_DimPackage_s3 | PackageOwner | NVARCHAR(2048) | ||
Bi_DimPackage_s3 | InitiallyRecognized | FLOAT | ||
Bi_DimPackage_s3 | sortorder | INT | ||
Bi_DimPackage_s3 | PackageValidityModelID | VARCHAR(36) | ||
Bi_DimPackage_s3 | Active | BOOLEAN | ||
Bi_DimPackage_s3 | TargetType | INT | ||
Bi_DimPackage_s3 | PackageFreezeCount | INT | ||
Bi_DimPackage_s3 | CommissionType | INT | ||
Bi_DimPackage_s3 | FlatCommissionValue | FLOAT | ||
Bi_DimPackage_s3 | PackageInternalCost | DECIMAL(19,4) | ||
Bi_DimPackage_s3 | MinPartialAmount | DECIMAL(19,4) | ||
Bi_DimPackage_s3 | MetaDescription | NVARCHAR(1024) | ||
Bi_DimPackage_s3 | MetaKeywords | NVARCHAR(1024) | ||
Bi_DimPackage_s3 | IsOfferPackage | BOOLEAN | ||
Bi_DimPackage_s3 | PrereqQty | INT | ||
Bi_DimPackage_s3 | FreeQty | INT | ||
Bi_DimPackage_s3 | void | BOOLEAN | ||
Bi_DimPackage_s3 | TAGS | VARCHAR(MAX) | ||
Bi_DimPackage_s3 | showincatalog | INT | ||
Bi_DimPackage_s3 | EtlLastUpdatedOn | TIMESTAMP | ||
Bi_DimPackage_s3 | EtlLastUpdatedBy | NVARCHAR(50) | ||
Bi_DimPackage_s3 | PodName | VARCHAR(20) | ||
Bi_DimPackage_s3 | groupid | BIGINT | ||
Bi_DimPackage_s3 | IsServiceBundleDayPackage | BOOLEAN |