Package dimension table

Table Name	Column Name	Description	Column Type	Primary Key
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	The type of the package. This is usually a day package, series package, or promo package. Hardcoded values: 1: Day package 2: Series package 3: Promo package	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

In this section:

Package dimension table

Search results