Data share through S3 dimension tables

Table Name	Column Name	Column Type	Primary Key	Mapped Dimension Table	Mapped Dimension Table Column
Bi_DimAccountName_s3	AccountId	INT	PK
Bi_DimAccountName_s3	AccountName	NVARCHAR(400)
Bi_DimAccountName_s3	void	BOOLEAN
Bi_DimAccountName_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimAccountName_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimAccountName_s3	PodName	VARCHAR(20)
Bi_DimAccountName_s3	organizationid	VARCHAR(36)
Bi_DimAddOnUserMembership_s3	DimAddOnUserMembershipId	DECIMAL(19)	PK
Bi_DimAddOnUserMembership_s3	UserId	NVARCHAR(MAX)
Bi_DimAddOnUserMembership_s3	CenterId	NVARCHAR(MAX)
Bi_DimAddOnUserMembership_s3	AddOnUserMembershipId	VARCHAR(36)
Bi_DimAddOnUserMembership_s3	VoidDate	TIMESTAMP
Bi_DimAddOnUserMembership_s3	AddDate	TIMESTAMP
Bi_DimAddOnUserMembership_s3	MembershipCode	NVARCHAR(640)
Bi_DimAddOnUserMembership_s3	AddedBy	NVARCHAR(MAX)
Bi_DimAddOnUserMembership_s3	RemovedBy	NVARCHAR(MAX)
Bi_DimAddOnUserMembership_s3	IsRecordVoided	INT
Bi_DimAddOnUserMembership_s3	PrimaryMember	INT
Bi_DimAddOnUserMembership_s3	ETLCreatedDate	TIMESTAMP
Bi_DimAddOnUserMembership_s3	MembershipEndDate	TIMESTAMP
Bi_DimAddOnUserMembership_s3	Void	BOOLEAN
Bi_DimAddOnUserMembership_s3	PodName	VARCHAR(20)
Bi_DimAddOnUserMembership_s3	OrganizationId	VARCHAR(36)
BI_DimAgent_s3	AgentId	VARCHAR(36)	PK
BI_DimAgent_s3	Name	NVARCHAR(400)
BI_DimAgent_s3	void	BOOLEAN
BI_DimAgent_s3	CreatedBy	VARCHAR(36)
BI_DimAgent_s3	CreatedOn	TIMESTAMP
BI_DimAgent_s3	Email	NVARCHAR(256)
BI_DimAgent_s3	Address1	NVARCHAR(256)
BI_DimAgent_s3	Address2	NVARCHAR(256)
BI_DimAgent_s3	City	NVARCHAR(128)
BI_DimAgent_s3	ZipCode	NVARCHAR(32)
BI_DimAgent_s3	StateOther	NVARCHAR(128)
BI_DimAgent_s3	Phone	NVARCHAR(64)
BI_DimAgent_s3	CommissionFactor	FLOAT
BI_DimAgent_s3	AccrueLoyaltyPointsOnPayment	BOOLEAN
BI_DimAgent_s3	CollectAdditionalData	BOOLEAN
BI_DimAgent_s3	ConsiderInFinancials	BOOLEAN
BI_DimAgent_s3	ConsiderInRoyalty	BOOLEAN
BI_DimAgent_s3	ShowInPos	BOOLEAN
BI_DimAgent_s3	OrganizationId	VARCHAR(36)
BI_DimAgent_s3	EtlLastUpdatedOn	TIMESTAMP
BI_DimAgent_s3	EtlLastUpdatedBy	NVARCHAR(50)
BI_DimAgent_s3	PodName	VARCHAR(20)
Bi_DimAppointmentCategories_s3	AppointmentCategoryId	VARCHAR(36)	PK
Bi_DimAppointmentCategories_s3	AppointmentCategoryCode	NVARCHAR(512)
Bi_DimAppointmentCategories_s3	AppointmentCategoryName	NVARCHAR(1024)
Bi_DimAppointmentCategories_s3	AppointmentCategoryOrder	INT
Bi_DimAppointmentCategories_s3	IndicatorColor	NVARCHAR(128)
Bi_DimAppointmentCategories_s3	OverrideAppointmentColor	BOOLEAN
Bi_DimAppointmentCategories_s3	Active	BOOLEAN
Bi_DimAppointmentCategories_s3	OrganizationId	VARCHAR(36)
Bi_DimAppointmentCategories_s3	Void	BOOLEAN
Bi_DimAppointmentCategories_s3	TextColor	NVARCHAR(128)
Bi_DimAppointmentCategories_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimAppointmentCategories_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimAppointmentCategories_s3	PodName	VARCHAR(20)
Bi_DimCampaign_s3	campaignid	VARCHAR(36)	PK
Bi_DimCampaign_s3	CampaignName	NVARCHAR(512)
Bi_DimCampaign_s3	CampaignDesc	NVARCHAR(4096)
Bi_DimCampaign_s3	CampaignType	INT
Bi_DimCampaign_s3	CampaignFilePath	NVARCHAR(512)
Bi_DimCampaign_s3	StartDate	TIMESTAMP
Bi_DimCampaign_s3	EndDate	TIMESTAMP
Bi_DimCampaign_s3	LaunchDate	TIMESTAMP
Bi_DimCampaign_s3	RuleId	VARCHAR(36)
Bi_DimCampaign_s3	CampaignMessage	NVARCHAR(16000)
Bi_DimCampaign_s3	Active	BOOLEAN
Bi_DimCampaign_s3	AutoApply	BOOLEAN
Bi_DimCampaign_s3	CombineOffers	BOOLEAN
Bi_DimCampaign_s3	AllowGiftCertificates	BOOLEAN
Bi_DimCampaign_s3	ScheduleDateTime	TIMESTAMP
Bi_DimCampaign_s3	OrganizationId	VARCHAR(36)
Bi_DimCampaign_s3	BookingStartDate	TIMESTAMP
Bi_DimCampaign_s3	BookingEndDate	TIMESTAMP
Bi_DimCampaign_s3	CampaignCode	NVARCHAR(4096)
Bi_DimCampaign_s3	DiscountId	VARCHAR(36)
Bi_DimCampaign_s3	Cashback	NVARCHAR(32)
Bi_DimCampaign_s3	SMSCampaign	INT
Bi_DimCampaign_s3	allowothers	BOOLEAN
Bi_DimCampaign_s3	CashbackRedeemedByAll	BOOLEAN
Bi_DimCampaign_s3	MinimumAmount	DECIMAL(19	4)
Bi_DimCampaign_s3	ValidityDays	INT
Bi_DimCampaign_s3	ExpiryDate	TIMESTAMP
Bi_DimCampaign_s3	ShowInCatalog	INT
Bi_DimCampaign_s3	ProgramId	VARCHAR(36)
Bi_DimCampaign_s3	AppliesTo	INT
Bi_DimCampaign_s3	NeedOtpAuthorization	BOOLEAN
Bi_DimCampaign_s3	FreeServiceCommissionEligible	BOOLEAN
Bi_DimCampaign_s3	AlwaysOn	BOOLEAN
Bi_DimCampaign_s3	SendRuleId	VARCHAR(36)
Bi_DimCampaign_s3	ExpiryDays	INT
Bi_DimCampaign_s3	IsBroadcast	BOOLEAN
Bi_DimCampaign_s3	SendOnlyOnce	BOOLEAN
Bi_DimCampaign_s3	MaximumAmount	DECIMAL(19	4)
Bi_DimCampaign_s3	OpportunityOwner	VARCHAR(36)
Bi_DimCampaign_s3	CampaignOpportunityType	NVARCHAR(1024)
Bi_DimCampaign_s3	WebstorePageTitle	NVARCHAR(1024)
Bi_DimCampaign_s3	MetaKeywords	NVARCHAR(1024)
Bi_DimCampaign_s3	MetaDescription	NVARCHAR(1024)
Bi_DimCampaign_s3	MaxRedemptionTimesPerGuest	INT
Bi_DimCampaign_s3	Void	BOOLEAN
Bi_DimCampaign_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimCampaign_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimCampaign_s3	PodName	VARCHAR(20)
Bi_DimCashRegister_s3	CashRegisterPK	DECIMAL(190)	PK
Bi_DimCashRegister_s3	CashRegisterId	VARCHAR(36)
Bi_DimCashRegister_s3	Code	NVARCHAR(128)
Bi_DimCashRegister_s3	Name	NVARCHAR(1024)
Bi_DimCashRegister_s3	Description	NVARCHAR(4096)
Bi_DimCashRegister_s3	Active	BOOLEAN
Bi_DimCashRegister_s3	CenterId	VARCHAR(36)
Bi_DimCashRegister_s3	void	BOOLEAN
Bi_DimCashRegister_s3	LastUpdated	TIMESTAMP
Bi_DimCashRegister_s3	UpdatedBy	VARCHAR(36)
Bi_DimCashRegister_s3	EnableInvoiceMirroring	INT
Bi_DimCashRegister_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimCashRegister_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimCashRegister_s3	PodName	VARCHAR(20)
Bi_DimCashRegister_s3	OrganizationId	VARCHAR(36)
Bi_DimCenter_s3	organizationID	VARCHAR(36)
Bi_DimCenter_s3	OrganizationName	NVARCHAR(512)
Bi_DimCenter_s3	orgAccountName	NVARCHAR(256)
Bi_DimCenter_s3	orgNoShowRefundValue	FLOAT
Bi_DimCenter_s3	orgEnableAnalytics	BOOLEAN
Bi_DimCenter_s3	orgCountryDispName	NVARCHAR(4096)
Bi_DimCenter_s3	orgCountryShortName	NVARCHAR(4096)
Bi_DimCenter_s3	orgCountryCode	NVARCHAR(40)
Bi_DimCenter_s3	orgstateDispName	NVARCHAR(4096)
Bi_DimCenter_s3	orgstateShortName	NVARCHAR(4096)
Bi_DimCenter_s3	orgstateCode	NVARCHAR(40)
Bi_DimCenter_s3	orgcultureDispName	NVARCHAR(4096)
Bi_DimCenter_s3	orgcultureCode	NVARCHAR(4096)
Bi_DimCenter_s3	orgcurrencyCode	NVARCHAR(4096)
Bi_DimCenter_s3	orgcurrDispName	NVARCHAR(4096)
Bi_DimCenter_s3	orgcurrSymbol	NVARCHAR(1024)
Bi_DimCenter_s3	orgcurrNumber	INT
Bi_DimCenter_s3	zoneID	VARCHAR(36)
Bi_DimCenter_s3	zonename	NVARCHAR(800)
Bi_DimCenter_s3	zonedesc	NVARCHAR(8000)
Bi_DimCenter_s3	centerid	VARCHAR(36)	PK
Bi_DimCenter_s3	centerName	NVARCHAR(512)
Bi_DimCenter_s3	centerCity	NVARCHAR(128)
Bi_DimCenter_s3	centerStateOther	NVARCHAR(128)
Bi_DimCenter_s3	centerzip	NVARCHAR(32)
Bi_DimCenter_s3	centerisHotel	BOOLEAN
Bi_DimCenter_s3	centerTgtRevenue	DECIMAL(19	4)
Bi_DimCenter_s3	centerCompanyName	NVARCHAR(200)
Bi_DimCenter_s3	centerRectPrefix	NVARCHAR(24)
Bi_DimCenter_s3	centerTallyCenter	NVARCHAR(256)
Bi_DimCenter_s3	centerisVendor	BOOLEAN
Bi_DimCenter_s3	centerisClinic	BOOLEAN
Bi_DimCenter_s3	centerCommission	FLOAT
Bi_DimCenter_s3	centerCommDate	TIMESTAMP
Bi_DimCenter_s3	centerEmailid	NVARCHAR(200)
Bi_DimCenter_s3	centerBiometricFlag	BOOLEAN
Bi_DimCenter_s3	centerGuestSearchAcrossCntrs	BOOLEAN
Bi_DimCenter_s3	centerGoLiveDate	TIMESTAMP
Bi_DimCenter_s3	centerPayable	BOOLEAN
Bi_DimCenter_s3	centerStartDate	TIMESTAMP
Bi_DimCenter_s3	centergeolatitude	FLOAT
Bi_DimCenter_s3	centerGeoLongitude	FLOAT
Bi_DimCenter_s3	centerinfo	NVARCHAR(4096)
Bi_DimCenter_s3	centerEnableAnalytics	BOOLEAN
Bi_DimCenter_s3	CenterDisplayName	NVARCHAR(128)
Bi_DimCenter_s3	centerAdoptionlevel	INT
Bi_DimCenter_s3	centerEnableOtp	BOOLEAN
Bi_DimCenter_s3	centerEnableAlerts	BOOLEAN
Bi_DimCenter_s3	centerCode	NVARCHAR(40)
Bi_DimCenter_s3	centerEndDate	TIMESTAMP
Bi_DimCenter_s3	centerCanBook	BOOLEAN
Bi_DimCenter_s3	centerEnableOffline	BOOLEAN
Bi_DimCenter_s3	centerEnableWebStore	BOOLEAN
Bi_DimCenter_s3	centerTZDispName	NVARCHAR(4096)
Bi_DimCenter_s3	centerTZStdName	NVARCHAR(4096)
Bi_DimCenter_s3	cntrcurrencyCode	NVARCHAR(4096)
Bi_DimCenter_s3	cntrcurrDispName	NVARCHAR(4096)
Bi_DimCenter_s3	cntrcurrSymbol	NVARCHAR(1024)
Bi_DimCenter_s3	cntrcurrNumber	INT
Bi_DimCenter_s3	cntrcultureDispName	NVARCHAR(4096)
Bi_DimCenter_s3	cntrcultureCode	NVARCHAR(4096)
Bi_DimCenter_s3	cntrCountryDispName	NVARCHAR(4096)
Bi_DimCenter_s3	cntrCountryShortName	NVARCHAR(4096)
Bi_DimCenter_s3	cntrCountryCode	NVARCHAR(40)
Bi_DimCenter_s3	cntrstateDispName	NVARCHAR(4096)
Bi_DimCenter_s3	cntrstateShortName	NVARCHAR(4096)
Bi_DimCenter_s3	cntrstateCode	NVARCHAR(40)
Bi_DimCenter_s3	cntrLangDispName	NVARCHAR(4096)
Bi_DimCenter_s3	cntrLangCode	NVARCHAR(4096)
Bi_DimCenter_s3	cntrBusTypeName	NVARCHAR(80)
Bi_DimCenter_s3	UtilizationFactor	NVARCHAR(MAX)
Bi_DimCenter_s3	centerAddress	NVARCHAR(256)
Bi_DimCenter_s3	centerPhone	NVARCHAR(64)
Bi_DimCenter_s3	void	BOOLEAN
Bi_DimCenter_s3	IsFranchise	BOOLEAN
Bi_DimCenter_s3	CSTNum	NVARCHAR(64)
Bi_DimCenter_s3	TINNum	NVARCHAR(64)
Bi_DimCenter_s3	TOTNum	NVARCHAR(64)
Bi_DimCenter_s3	ServiceTaxNum	NVARCHAR(64)
Bi_DimCenter_s3	VATNumber	NVARCHAR(80)
Bi_DimCenter_s3	LuxuryTaxNum	NVARCHAR(128)
Bi_DimCenter_s3	FSRBasedOnMembershipListPrice	INT
Bi_DimCenter_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimCenter_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimCenter_s3	PodName	VARCHAR(20)
Bi_DimCenterHolidays_s3	CenterHolidayId	VARCHAR(36)	PK
Bi_DimCenterHolidays_s3	centerid	VARCHAR(36)
Bi_DimCenterHolidays_s3	holiday	TIMESTAMP
Bi_DimCenterHolidays_s3	Holiday_Desc	NVARCHAR(800)
Bi_DimCenterHolidays_s3	recurring	BOOLEAN
Bi_DimCenterHolidays_s3	void	BOOLEAN
Bi_DimCenterHolidays_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimCenterHolidays_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimCenterHolidays_s3	PodName	VARCHAR(20)
Bi_DimCenterHolidays_s3	organizationID	VARCHAR(36)
Bi_DimCenterTiming_s3	CenterTimingPK	DECIMAL(19,0)	PK
Bi_DimCenterTiming_s3	CenterID	VARCHAR(36)
Bi_DimCenterTiming_s3	centerName	NVARCHAR(512)
Bi_DimCenterTiming_s3	DayOfWeek	VARCHAR(80)
Bi_DimCenterTiming_s3	CenterStartTime	FLOAT
Bi_DimCenterTiming_s3	CenterEndTime	FLOAT
Bi_DimCenterTiming_s3	OnlineBookingStartTime	FLOAT
Bi_DimCenterTiming_s3	OnlineBookingEndTime	FLOAT
Bi_DimCenterTiming_s3	cntrtimngPK	VARCHAR(50)
Bi_DimCenterTiming_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimCenterTiming_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimCenterTiming_s3	PodName	VARCHAR(20)
Bi_DimCenterTiming_s3	organizationid	VARCHAR(36)
Bi_DimCenterWorkingHoursExceptions_s3	ExceptionDatePK	DECIMAL(19	PK
Bi_DimCenterWorkingHoursExceptions_s3	CenterID	VARCHAR(36)
Bi_DimCenterWorkingHoursExceptions_s3	ExceptionDate	TIMESTAMP
Bi_DimCenterWorkingHoursExceptions_s3	opentime	FLOAT
Bi_DimCenterWorkingHoursExceptions_s3	closetime	FLOAT
Bi_DimCenterWorkingHoursExceptions_s3	OnlineBookingStart	FLOAT
Bi_DimCenterWorkingHoursExceptions_s3	OnlineBookingEnd	FLOAT
Bi_DimCenterWorkingHoursExceptions_s3	PeakStart	FLOAT
Bi_DimCenterWorkingHoursExceptions_s3	PeakEnd	FLOAT
Bi_DimCenterWorkingHoursExceptions_s3	Void	BOOLEAN
Bi_DimCenterWorkingHoursExceptions_s3	CreatedDate	TIMESTAMP
Bi_DimCenterWorkingHoursExceptions_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimCenterWorkingHoursExceptions_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimCenterWorkingHoursExceptions_s3	PodName	VARCHAR(20)
Bi_DimCenterWorkingHoursExceptions_s3	organizationid	VARCHAR(36)
Bi_DimCustomForms_s3	FormPk	DECIMAL(19	PK
Bi_DimCustomForms_s3	FormId	VARCHAR(36)
Bi_DimCustomForms_s3	FormName	NVARCHAR(1024)
Bi_DimCustomForms_s3	FormDesc	NVARCHAR(4096)
Bi_DimCustomForms_s3	FormType	INT
Bi_DimCustomForms_s3	OrganizationID	VARCHAR(36)
Bi_DimCustomForms_s3	void	BOOLEAN
Bi_DimCustomForms_s3	FormCode	NVARCHAR(128)
Bi_DimCustomForms_s3	Active	BOOLEAN
Bi_DimCustomForms_s3	ReviewNeeded	BOOLEAN
Bi_DimCustomForms_s3	ViewOnly	BOOLEAN
Bi_DimCustomForms_s3	FormExpiryType	INT
Bi_DimCustomForms_s3	ExpiryTime	NVARCHAR(65535)
Bi_DimCustomForms_s3	FormVersion	INT
Bi_DimCustomForms_s3	FormActionType	INT
Bi_DimCustomForms_s3	CopyPreviousData	BOOLEAN
Bi_DimCustomForms_s3	PrefillOldVersionData	BOOLEAN
Bi_DimCustomForms_s3	ExcludeChildFormsForReview	BOOLEAN
Bi_DimCustomForms_s3	CreatedOn	TIMESTAMP
Bi_DimCustomForms_s3	CreatedBy	VARCHAR(36)
Bi_DimCustomForms_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimCustomForms_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimCustomForms_s3	PodName	VARCHAR(20)
Bi_DimDate_s3	DateKey	INT	PK
Bi_DimDate_s3	Date	TIMESTAMP
Bi_DimDate_s3	FullDateUK	CHAR(40)
Bi_DimDate_s3	FullDateUSA	CHAR(40)
Bi_DimDate_s3	DayOfMonth	VARCHAR(8)
Bi_DimDate_s3	DaySuffix	VARCHAR(16)
Bi_DimDate_s3	DayName	VARCHAR(36)
Bi_DimDate_s3	DayOfWeekUSA	CHAR(4)
Bi_DimDate_s3	DayOfWeekUK	CHAR(4)
Bi_DimDate_s3	DayOfWeekInMonth	VARCHAR(8)
Bi_DimDate_s3	DayOfWeekInYear	VARCHAR(8)
Bi_DimDate_s3	DayOfQuarter	VARCHAR(12)
Bi_DimDate_s3	DayOfYear	VARCHAR(12)
Bi_DimDate_s3	WeekOfMonth	VARCHAR(4)
Bi_DimDate_s3	WeekOfQuarter	VARCHAR(8)
Bi_DimDate_s3	WeekOfYear	VARCHAR(8)
Bi_DimDate_s3	Month	VARCHAR(8)
Bi_DimDate_s3	MonthName	VARCHAR(36)
Bi_DimDate_s3	MonthOfQuarter	VARCHAR(8)
Bi_DimDate_s3	Quarter	CHAR(4)
Bi_DimDate_s3	QuarterName	VARCHAR(36)
Bi_DimDate_s3	Year	CHAR(16)
Bi_DimDate_s3	YearName	CHAR(28)
Bi_DimDate_s3	MonthYear	CHAR(40)
Bi_DimDate_s3	MMYYYY	CHAR(24)
Bi_DimDate_s3	FirstDayOfMonth	DATE
Bi_DimDate_s3	LastDayOfMonth	DATE
Bi_DimDate_s3	FirstDayOfQuarter	DATE
Bi_DimDate_s3	LastDayOfQuarter	DATE
Bi_DimDate_s3	FirstDayOfYear	DATE
Bi_DimDate_s3	LastDayOfYear	DATE
Bi_DimDate_s3	IsHolidayUSA	BOOLEAN
Bi_DimDate_s3	IsWeekday	BOOLEAN
Bi_DimDate_s3	HolidayUSA	VARCHAR(200)
Bi_DimDate_s3	IsHolidayUK	BOOLEAN
Bi_DimDate_s3	HolidayUK	VARCHAR(200)
Bi_DimDate_s3	FiscalDayOfYear	VARCHAR(12)
Bi_DimDate_s3	FiscalWeekOfYear	VARCHAR(12)
Bi_DimDate_s3	FiscalMonth	VARCHAR(8)
Bi_DimDate_s3	FiscalQuarter	CHAR(4)
Bi_DimDate_s3	FiscalQuarterName	VARCHAR(36)
Bi_DimDate_s3	FiscalYear	CHAR(16)
Bi_DimDate_s3	FiscalYearName	CHAR(28)
Bi_DimDate_s3	FiscalMonthYear	CHAR(40)
Bi_DimDate_s3	FiscalMMYYYY	CHAR(24)
Bi_DimDate_s3	FiscalFirstDayOfMonth	DATE
Bi_DimDate_s3	FiscalLastDayOfMonth	DATE
Bi_DimDate_s3	FiscalFirstDayOfQuarter	DATE
Bi_DimDate_s3	FiscalLastDayOfQuarter	DATE
Bi_DimDate_s3	FiscalFirstDayOfYear	DATE
Bi_DimDate_s3	FiscalLastDayOfYear	DATE
Bi_DimDate_s3	void	BOOLEAN
Bi_DimDate_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimDate_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimDate_s3	PodName	VARCHAR(20)
Bi_DimDiscount_s3	DiscountId	VARCHAR(36)	PK
Bi_DimDiscount_s3	DiscountCode	NVARCHAR(32)
Bi_DimDiscount_s3	OrganizationId	VARCHAR(36)
Bi_DimDiscount_s3	DiscountName	NVARCHAR(256)
Bi_DimDiscount_s3	DiscountValue	DECIMAL(19,4)
Bi_DimDiscount_s3	DiscountPercentage	FLOAT
Bi_DimDiscount_s3	Monday	BOOLEAN
Bi_DimDiscount_s3	Tuesday	BOOLEAN
Bi_DimDiscount_s3	Wednesday	BOOLEAN
Bi_DimDiscount_s3	Thursday	BOOLEAN
Bi_DimDiscount_s3	Friday	BOOLEAN
Bi_DimDiscount_s3	Saturday	BOOLEAN
Bi_DimDiscount_s3	Sunday	BOOLEAN
Bi_DimDiscount_s3	StartTime	FLOAT
Bi_DimDiscount_s3	EndTime	FLOAT
Bi_DimDiscount_s3	CombineSpecials	BOOLEAN
Bi_DimDiscount_s3	DiscountTypeId	INT
Bi_DimDiscount_s3	GiftCertificates	BOOLEAN
Bi_DimDiscount_s3	MinimumAmount	DECIMAL(19,4)
Bi_DimDiscount_s3	isDeferrable	BOOLEAN
Bi_DimDiscount_s3	deferred_expireson	DATE
Bi_DimDiscount_s3	serviceleveldiscounts	BOOLEAN
Bi_DimDiscount_s3	Packageleveldiscounts	BOOLEAN
Bi_DimDiscount_s3	MaximumAmount	DECIMAL(19,4)
Bi_DimDiscount_s3	ProductLevelDiscounts	BOOLEAN
Bi_DimDiscount_s3	MembershipLevelDiscounts	BOOLEAN
Bi_DimDiscount_s3	DiscountTypeName	NVARCHAR(128)
Bi_DimDiscount_s3	Void	BOOLEAN
Bi_DimDiscount_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimDiscount_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimDiscount_s3	PodName	VARCHAR(20)
Bi_DimEmployee_s3	employeeuniqueid	VARCHAR(36)	PK
Bi_DimEmployee_s3	employeeid	VARCHAR(36)
Bi_DimEmployee_s3	firstname	NVARCHAR(160)
Bi_DimEmployee_s3	lastname	NVARCHAR(256)
Bi_DimEmployee_s3	middlename	NVARCHAR(128)
Bi_DimEmployee_s3	address1	NVARCHAR(2048)
Bi_DimEmployee_s3	address2	NVARCHAR(2048)
Bi_DimEmployee_s3	city	NVARCHAR(128)
Bi_DimEmployee_s3	StateOther	NVARCHAR(128)
Bi_DimEmployee_s3	ZipCode	NVARCHAR(128)
Bi_DimEmployee_s3	UserTypeID	VARCHAR(36)
Bi_DimEmployee_s3	UserTypeName	NVARCHAR(128)
Bi_DimEmployee_s3	CreationDt	TIMESTAMP
Bi_DimEmployee_s3	CenterID	VARCHAR(36)
Bi_DimEmployee_s3	Email	NVARCHAR(256)
Bi_DimEmployee_s3	homephone	NVARCHAR(64)
Bi_DimEmployee_s3	mobilephone	NVARCHAR(64)
Bi_DimEmployee_s3	workphone	NVARCHAR(64)
Bi_DimEmployee_s3	username	NVARCHAR(256)
Bi_DimEmployee_s3	usercode	NVARCHAR(512)
Bi_DimEmployee_s3	lastlogin	TIMESTAMP
Bi_DimEmployee_s3	gender	INT
Bi_DimEmployee_s3	dob	TIMESTAMP
Bi_DimEmployee_s3	preferredTherapist	VARCHAR(36)
Bi_DimEmployee_s3	preferredRoom	VARCHAR(36)
Bi_DimEmployee_s3	otherpreferences	NVARCHAR(65535)
Bi_DimEmployee_s3	referralsourceid	VARCHAR(36)
Bi_DimEmployee_s3	roomno	NVARCHAR(80)
Bi_DimEmployee_s3	referredby	VARCHAR(36)
Bi_DimEmployee_s3	anniversarydate	TIMESTAMP
Bi_DimEmployee_s3	PreferedCenerId	VARCHAR(36)
Bi_DimEmployee_s3	registrationsource	INT
Bi_DimEmployee_s3	customerapplogin	INT
Bi_DimEmployee_s3	cultureCode	NVARCHAR(4096)
Bi_DimEmployee_s3	cultureDispName	NVARCHAR(4096)
Bi_DimEmployee_s3	langCode	NVARCHAR(4096)
Bi_DimEmployee_s3	LangDispName	NVARCHAR(4096)
Bi_DimEmployee_s3	mobileCountryDName	NVARCHAR(4096)
Bi_DimEmployee_s3	mobileCountrySName	NVARCHAR(4096)
Bi_DimEmployee_s3	workCountryDName	NVARCHAR(4096)
Bi_DimEmployee_s3	workCountrySName	NVARCHAR(4096)
Bi_DimEmployee_s3	homeCountryDName	NVARCHAR(4096)
Bi_DimEmployee_s3	homeCountrySName	NVARCHAR(4096)
Bi_DimEmployee_s3	stateDispName	NVARCHAR(4096)
Bi_DimEmployee_s3	stateShortName	NVARCHAR(4096)
Bi_DimEmployee_s3	statecode	NVARCHAR(40)
Bi_DimEmployee_s3	CountryDName	NVARCHAR(4096)
Bi_DimEmployee_s3	CountrySName	NVARCHAR(4096)
Bi_DimEmployee_s3	ReceiveTransactionalSMS	BOOLEAN
Bi_DimEmployee_s3	ReceiveMarketingSMS	BOOLEAN
Bi_DimEmployee_s3	UserPK	DECIMAL(19,0)
Bi_DimEmployee_s3	UnSubscribeToTransactionalEmail	BOOLEAN
Bi_DimEmployee_s3	UnSubscribeToMarketingEmail	BOOLEAN
Bi_DimEmployee_s3	PasswordUpdatedOn	TIMESTAMP
Bi_DimEmployee_s3	ReceiveTransactionalEMail	BOOLEAN
Bi_DimEmployee_s3	ReceiveMarketingEMail	BOOLEAN
Bi_DimEmployee_s3	AcceptedTAndC	INT
Bi_DimEmployee_s3	NationalityFK	INT
Bi_DimEmployee_s3	DOB_IncompleteYear	NVARCHAR(20)
Bi_DimEmployee_s3	OrganizationID	VARCHAR(36)
Bi_DimEmployee_s3	JobCode	NVARCHAR(8000)
Bi_DimEmployee_s3	JobName	NVARCHAR(1020)
Bi_DimEmployee_s3	JobDesc	NVARCHAR(8000)
Bi_DimEmployee_s3	StartDate	TIMESTAMP
Bi_DimEmployee_s3	LastDate	TIMESTAMP
Bi_DimEmployee_s3	MandatoryBreakTimePerDay	INT
Bi_DimEmployee_s3	EmployeeCode	NVARCHAR(512)
Bi_DimEmployee_s3	PodName	VARCHAR(20)
Bi_DimEmployee_s3	Void	BOOLEAN
Bi_DimEmployee_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimEmployee_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimEmployeeBreakCategory_s3	EmployeeBreakCategoryPK	DECIMAL(19,0)	PK
Bi_DimEmployeeBreakCategory_s3	EmployeeBreakCategoryName	NVARCHAR(256)
Bi_DimEmployeeBreakCategory_s3	EmployeeBreakCategoryCode	NVARCHAR(128)
Bi_DimEmployeeBreakCategory_s3	EmployeeBreakDuration	INT
Bi_DimEmployeeBreakCategory_s3	OrganizationId	VARCHAR(36)
Bi_DimEmployeeBreakCategory_s3	OrganizationName	NVARCHAR(512)
Bi_DimEmployeeBreakCategory_s3	AccountName	NVARCHAR(256)
Bi_DimEmployeeBreakCategory_s3	Active	BOOLEAN
Bi_DimEmployeeBreakCategory_s3	void	BOOLEAN
Bi_DimEmployeeBreakCategory_s3	CountInUtilization	BOOLEAN
Bi_DimEmployeeBreakCategory_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimEmployeeBreakCategory_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimEmployeeBreakCategory_s3	PodName	VARCHAR(20)
Bi_DimEmployeeRole_s3	DimEmployeeRoleId	DECIMAL(19,0)	PK
Bi_DimEmployeeRole_s3	EmployeeID	VARCHAR(36)
Bi_DimEmployeeRole_s3	EmployeeTypeName	NVARCHAR(128)
Bi_DimEmployeeRole_s3	CenterId	VARCHAR(36)
Bi_DimEmployeeRole_s3	StartDate	TIMESTAMP
Bi_DimEmployeeRole_s3	EndDate	TIMESTAMP
Bi_DimEmployeeRole_s3	IsCurrentRecord	BOOLEAN
Bi_DimEmployeeRole_s3	etlCreatedDate	TIMESTAMP
Bi_DimEmployeeRole_s3	Void	BOOLEAN
Bi_DimEmployeeRole_s3	PodName	VARCHAR(20)
Bi_DimEmployeeRole_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimEmployeeRole_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimEmployeeRole_s3	OrganizationId	VARCHAR(36)
Bi_DimEmployeeScheduleStatus_s3	StatusPK	DECIMAL(19,0)	PK
Bi_DimEmployeeScheduleStatus_s3	StatusName	NVARCHAR(1024)
Bi_DimEmployeeScheduleStatus_s3	OrganizationName	NVARCHAR(512)
Bi_DimEmployeeScheduleStatus_s3	AccountName	NVARCHAR(256)
Bi_DimEmployeeScheduleStatus_s3	Void	BOOLEAN
Bi_DimEmployeeScheduleStatus_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimEmployeeScheduleStatus_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimEmployeeScheduleStatus_s3	PodName	VARCHAR(20)
Bi_DimEmployeeScheduleStatus_s3	organizationid	VARCHAR(36)
Bi_DimEquipment_s3	EquipmentId	VARCHAR(36)
Bi_DimEquipment_s3	EquipmentPK	DECIMAL(19,0)	PK
Bi_DimEquipment_s3	EquipmentName	NVARCHAR(1024)
Bi_DimEquipment_s3	EquipmentCode	NVARCHAR(128)
Bi_DimEquipment_s3	Description	NVARCHAR(4096)
Bi_DimEquipment_s3	Capacity	INT
Bi_DimEquipment_s3	CenterId	VARCHAR(36)
Bi_DimEquipment_s3	LastUpdated	TIMESTAMP
Bi_DimEquipment_s3	Void	BOOLEAN
Bi_DimEquipment_s3	Active	BOOLEAN
Bi_DimEquipment_s3	AllowToBookMoreThanCapacity	BOOLEAN
Bi_DimEquipment_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimEquipment_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimEquipment_s3	PodName	VARCHAR(20)
Bi_DimEquipment_s3	organizationid	VARCHAR(36)
Bi_DimETLRefreshLog_s3	ETLRefreshLogID	DECIMAL(19,0)	PK
Bi_DimETLRefreshLog_s3	OrganizationID	VARCHAR(36)
Bi_DimETLRefreshLog_s3	AccountName	NVARCHAR(512)
Bi_DimETLRefreshLog_s3	CenterID	VARCHAR(36)
Bi_DimETLRefreshLog_s3	RefreshUTCDateTim	TIMESTAMP
Bi_DimETLRefreshLog_s3	CenterRefreshDateTime	TIMESTAMP
Bi_DimETLRefreshLog_s3	LastUpdatedDate	TIMESTAMP
Bi_DimETLRefreshLog_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimETLRefreshLog_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimETLRefreshLog_s3	PodName	VARCHAR(20)
Bi_DimFactChanges_s3	ETLFactChangeID	DECIMAL(19,0)	PK
Bi_DimFactChanges_s3	FactPk	DECIMAL(19,0)
Bi_DimFactChanges_s3	FactName	NVARCHAR(512)
Bi_DimFactChanges_s3	CreatedOnDate	TIMESTAMP
Bi_DimFactChanges_s3	FactId	SMALLINT
Bi_DimFactChanges_s3	GroupId	DECIMAL(19,0)
Bi_DimFactChanges_s3	PodName	VARCHAR(20)
Bi_DimFactChanges_s3	OrganizationId	VARCHAR(36)
Bi_DimFeedback_s3	FeedbackId	DECIMAL(19,0)	PK
Bi_DimFeedback_s3	OrganizationId	VARCHAR(36)
Bi_DimFeedback_s3	GuestFeedback_Ambience	NVARCHAR(4096)
Bi_DimFeedback_s3	GuestFeedback_Cleanliness	NVARCHAR(4096)
Bi_DimFeedback_s3	GuestFeedback_Service	NVARCHAR(4096)
Bi_DimFeedback_s3	GuestFeedback_Therapist	NVARCHAR(4096)
Bi_DimFeedback_s3	GuestFeedback_Question1	NVARCHAR(4096)
Bi_DimFeedback_s3	GuestFeedback_Question2	NVARCHAR(4096)
Bi_DimFeedback_s3	GuestFeedback_Question3	NVARCHAR(4096)
Bi_DimFeedback_s3	AmbienceCategory	NVARCHAR(4112)
Bi_DimFeedback_s3	CleanlinessCategory	NVARCHAR(4112)
Bi_DimFeedback_s3	ServiceCategory	NVARCHAR(4112)
Bi_DimFeedback_s3	TherapistCategory	NVARCHAR(4112)
Bi_DimFeedback_s3	RowInsertedDateTime	TIMESTAMP
Bi_DimFeedback_s3	Void	BOOLEAN
Bi_DimFeedback_s3	PodName	VARCHAR(20)
Bi_DimFeedback_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimFeedback_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimGiftCard_s3	GiftCardId	VARCHAR(36)	PK
Bi_DimGiftCard_s3	GiftCardCode	NVARCHAR(256)
Bi_DimGiftCard_s3	GiftCardValue	DECIMAL(19,4)
Bi_DimGiftCard_s3	CreationDate	TIMESTAMP
Bi_DimGiftCard_s3	GiftCardPurchasePrice	DECIMAL(19,4)
Bi_DimGiftCard_s3	GiftCardValidityDays	INT
Bi_DimGiftCard_s3	OrganizationId	VARCHAR(36)
Bi_DimGiftCard_s3	isonetimeuse	BOOLEAN
Bi_DimGiftCard_s3	IsGiftCard	BOOLEAN
Bi_DimGiftCard_s3	tax	DECIMAL(19,4)
Bi_DimGiftCard_s3	centertaxid	VARCHAR(36)
Bi_DimGiftCard_s3	ExpiryDate	DATE
Bi_DimGiftCard_s3	ComissionEligible	BOOLEAN
Bi_DimGiftCard_s3	FreeServiceCommissionEligible	BOOLEAN
Bi_DimGiftCard_s3	Notes	NVARCHAR(65535)
Bi_DimGiftCard_s3	GiftTypeId	VARCHAR(36)
Bi_DimGiftCard_s3	RecipientName	NVARCHAR(1024)
Bi_DimGiftCard_s3	RecipientId	VARCHAR(36)
Bi_DimGiftCard_s3	AuthenticatedBy	VARCHAR(36)
Bi_DimGiftCard_s3	GiftTypeCode	NVARCHAR(256)
Bi_DimGiftCard_s3	GiftTypeName	NVARCHAR(1024)
Bi_DimGiftCard_s3	GiftTypeDesc	NVARCHAR(4096)
Bi_DimGiftCard_s3	GiftTypeFrequency	INT
Bi_DimGiftCard_s3	void	BOOLEAN
Bi_DimGiftCard_s3	IsBonusGiftcard	BOOLEAN
Bi_DimGiftCard_s3	PromotionName	NVARCHAR(2048)
Bi_DimGiftCard_s3	PromotionCode	NVARCHAR(512)
Bi_DimGiftCard_s3	PromotionDescription	NVARCHAR(65535)
Bi_DimGiftCard_s3	PrmotionRuleCriteria	NVARCHAR(2000)
Bi_DimGiftCard_s3	PromotionRuleMinimumValue	DECIMAL(19,4)
Bi_DimGiftCard_s3	PromotionRuleMaximumValue	DECIMAL(19,4)
Bi_DimGiftCard_s3	PromotionRuleBonusValue	DECIMAL(19,4)
Bi_DimGiftCard_s3	TemplateName	NVARCHAR(512)
Bi_DimGiftCard_s3	TemplateDescription	NVARCHAR(4096)
Bi_DimGiftCard_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimGiftCard_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimGiftCard_s3	PodName	VARCHAR(20)
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_DimGuestCoupon_s3	guestcouponid	VARCHAR(36)	PK
Bi_DimGuestCoupon_s3	userid	VARCHAR(36)
Bi_DimGuestCoupon_s3	discountid	VARCHAR(36)
Bi_DimGuestCoupon_s3	couponnumber	INT
Bi_DimGuestCoupon_s3	printdate	TIMESTAMP
Bi_DimGuestCoupon_s3	expirydate	TIMESTAMP
Bi_DimGuestCoupon_s3	redemptiondt	TIMESTAMP
Bi_DimGuestCoupon_s3	redemptionnotes	NVARCHAR(800)
Bi_DimGuestCoupon_s3	cashback	NVARCHAR(32)
Bi_DimGuestCoupon_s3	invoiceid	VARCHAR(36)
Bi_DimGuestCoupon_s3	couponruleid	VARCHAR(36)
Bi_DimGuestCoupon_s3	baseinvoiceid	VARCHAR(36)
Bi_DimGuestCoupon_s3	campaignid	VARCHAR(36)
Bi_DimGuestCoupon_s3	skiprereq	BOOLEAN
Bi_DimGuestCoupon_s3	redeemedbyall	INT
Bi_DimGuestCoupon_s3	couponupdatedby	VARCHAR(36)
Bi_DimGuestCoupon_s3	couponupdatedon	TIMESTAMP
Bi_DimGuestCoupon_s3	void	BOOLEAN
Bi_DimGuestCoupon_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimGuestCoupon_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimGuestCoupon_s3	PodName	VARCHAR(20)
Bi_DimGuestCoupon_s3	CenterId	VARCHAR(36)
Bi_DimGuestCoupon_s3	organizationid	VARCHAR(36)
Bi_DimGuestLoyaltyTier_s3	userid	VARCHAR(36)
Bi_DimGuestLoyaltyTier_s3	GuestTierPK	INT	PK
Bi_DimGuestLoyaltyTier_s3	FirstName	NVARCHAR(160)
Bi_DimGuestLoyaltyTier_s3	LastName	NVARCHAR(256)
Bi_DimGuestLoyaltyTier_s3	centerid	VARCHAR(36)
Bi_DimGuestLoyaltyTier_s3	tierid	VARCHAR(36)
Bi_DimGuestLoyaltyTier_s3	TierName	NVARCHAR(512)
Bi_DimGuestLoyaltyTier_s3	StartDate	TIMESTAMP
Bi_DimGuestLoyaltyTier_s3	EndDate	TIMESTAMP
Bi_DimGuestLoyaltyTier_s3	organizationid	VARCHAR(36)
Bi_DimGuestLoyaltyTier_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimGuestLoyaltyTier_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimGuestLoyaltyTier_s3	PodName	VARCHAR(20)
Bi_DimIssueCategories_s3	IssueCategoryId	VARCHAR(36)	PK
Bi_DimIssueCategories_s3	OrganizationId	VARCHAR(36)
Bi_DimIssueCategories_s3	CategoryCode	NVARCHAR(256)
Bi_DimIssueCategories_s3	CategoryName	NVARCHAR(256)
Bi_DimIssueCategories_s3	CategoryDescription	NVARCHAR(4096)
Bi_DimIssueCategories_s3	Active	BOOLEAN
Bi_DimIssueCategories_s3	void	BOOLEAN
Bi_DimIssueCategories_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimIssueCategories_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimIssueCategories_s3	PodName	VARCHAR(20)
Bi_DimIssuePriorityType_s3	PK	DECIMAL(19,0)	PK
Bi_DimIssuePriorityType_s3	PriorityTypeId	VARCHAR(36)
Bi_DimIssuePriorityType_s3	PriorityName	NVARCHAR(64)
Bi_DimIssuePriorityType_s3	Priority	INT
Bi_DimIssuePriorityType_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimIssuePriorityType_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimIssuePriorityType_s3	PodName	VARCHAR(20)
Bi_DimIssuePriorityType_s3	organizationid	VARCHAR(36)
Bi_DimIssueSource_s3	IssueSourceId	VARCHAR(36)	PK
Bi_DimIssueSource_s3	SourceName	NVARCHAR(256)
Bi_DimIssueSource_s3	SourceCode	NVARCHAR(256)
Bi_DimIssueSource_s3	SourceDescription	NVARCHAR(4096)
Bi_DimIssueSource_s3	OrganizationId	VARCHAR(36)
Bi_DimIssueSource_s3	Active	BOOLEAN
Bi_DimIssueSource_s3	void	BOOLEAN
Bi_DimIssueSource_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimIssueSource_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimIssueSource_s3	PodName	VARCHAR(20)
Bi_DimIssueStatusType_s3	PK	DECIMAL(19,0)	PK
Bi_DimIssueStatusType_s3	IssueStatusTypeID	VARCHAR(36)
Bi_DimIssueStatusType_s3	StatusName	NVARCHAR(512)
Bi_DimIssueStatusType_s3	IssueTypeId	VARCHAR(36)
Bi_DimIssueStatusType_s3	Priority	INT
Bi_DimIssueStatusType_s3	OrganizationId	VARCHAR(36)
Bi_DimIssueStatusType_s3	Code	NVARCHAR(256)
Bi_DimIssueStatusType_s3	Description	NVARCHAR(4096)
Bi_DimIssueStatusType_s3	Active	BOOLEAN
Bi_DimIssueStatusType_s3	void	BOOLEAN
Bi_DimIssueStatusType_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimIssueStatusType_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimIssueStatusType_s3	PodName	VARCHAR(20)
Bi_DimIssueSubCategories_s3	IssueSubCategoryId	VARCHAR(36)	PK
Bi_DimIssueSubCategories_s3	IssueCategoryId	VARCHAR(36)
Bi_DimIssueSubCategories_s3	OrganizationId	VARCHAR(36)
Bi_DimIssueSubCategories_s3	SubCategoryCode	NVARCHAR(256)
Bi_DimIssueSubCategories_s3	SubCategoryName	NVARCHAR(256)
Bi_DimIssueSubCategories_s3	SubCategoryDescription	NVARCHAR(4096)
Bi_DimIssueSubCategories_s3	Active	BOOLEAN
Bi_DimIssueSubCategories_s3	void	BOOLEAN
Bi_DimIssueSubCategories_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimIssueSubCategories_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimIssueSubCategories_s3	PodName	VARCHAR(20)
Bi_DimIssueTreatment_s3	IssueTreatmentId	VARCHAR(36)	PK
Bi_DimIssueTreatment_s3	OrganizationId	VARCHAR(36)
Bi_DimIssueTreatment_s3	TreatmentCode	NVARCHAR(256)
Bi_DimIssueTreatment_s3	TreatmentName	NVARCHAR(256)
Bi_DimIssueTreatment_s3	TreatmentDescription	NVARCHAR(4096)
Bi_DimIssueTreatment_s3	Active	BOOLEAN
Bi_DimIssueTreatment_s3	void	BOOLEAN
Bi_DimIssueTreatment_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimIssueTreatment_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimIssueTreatment_s3	PodName	VARCHAR(20)
Bi_DimIssueType_s3	IssueTypeId	VARCHAR(36)	PK
Bi_DimIssueType_s3	IssueTypeName	NVARCHAR(1020)
Bi_DimIssueType_s3	void	BOOLEAN
Bi_DimIssueType_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimIssueType_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimIssueType_s3	PodName	VARCHAR(20)
Bi_DimIssueType_s3	organizationid	VARCHAR(36)
Bi_DimItem_s3	ItemId	VARCHAR(36)	PK
Bi_DimItem_s3	ItemName	NVARCHAR(512)
Bi_DimItem_s3	ItemCode	NVARCHAR(512)
Bi_DimItem_s3	BusinessUnitId	NVARCHAR(MAX)
Bi_DimItem_s3	BusinessUnitName	NVARCHAR(MAX)
Bi_DimItem_s3	TAGS	VARCHAR(MAX)
Bi_DimItem_s3	OrganizationId	VARCHAR(36)
Bi_DimItem_s3	void	BOOLEAN
Bi_DimItem_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimItem_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimItem_s3	PodName	VARCHAR(20)
Bi_DimItemSource_s3	SourceNum	INT	PK
Bi_DimItemSource_s3	SourceName	NVARCHAR(128)
Bi_DimItemSource_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimItemSource_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimItemSource_s3	PodName	VARCHAR(20)
Bi_DimItemSource_s3	organizationid	VARCHAR(36)
Bi_DimItemType_s3	ItemTypeId	INT	PK
Bi_DimItemType_s3	ItemTypeCode	NVARCHAR(400)
Bi_DimItemType_s3	ItemTypeValue	DECIMAL(19,0)
Bi_DimItemType_s3	void	BOOLEAN
Bi_DimItemType_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimItemType_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimItemType_s3	PodName	VARCHAR(20)
Bi_DimItemType_s3	organizationid	VARCHAR(36)
Bi_DimLoyaltyPointActions_s3	ActionId	VARCHAR(36)	PK
Bi_DimLoyaltyPointActions_s3	ActionName	NVARCHAR(1024)
Bi_DimLoyaltyPointActions_s3	displayorder	INT
Bi_DimLoyaltyPointActions_s3	Void	BOOLEAN
Bi_DimLoyaltyPointActions_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimLoyaltyPointActions_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimLoyaltyPointActions_s3	PodName	VARCHAR(20)
Bi_DimLoyaltyPointActions_s3	OrganizationId	VARCHAR(36)
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_DimMembership_s3	membershipversionid	VARCHAR(36)	PK
Bi_DimMembership_s3	membershipName	NVARCHAR(256)
Bi_DimMembership_s3	membershipdays	INT
Bi_DimMembership_s3	SaleStartDate	TIMESTAMP
Bi_DimMembership_s3	SaleEndDate	TIMESTAMP
Bi_DimMembership_s3	MembershipCategoryName	NVARCHAR(800)
Bi_DimMembership_s3	MembershipCategoryDescription	NVARCHAR(4096)
Bi_DimMembership_s3	MembershipDesc	NVARCHAR(4096)
Bi_DimMembership_s3	creationDate	TIMESTAMP
Bi_DimMembership_s3	organizationID	VARCHAR(36)
Bi_DimMembership_s3	CreditAmount	FLOAT
Bi_DimMembership_s3	Active	BOOLEAN
Bi_DimMembership_s3	ComissionEligible	BOOLEAN
Bi_DimMembership_s3	membershipId	VARCHAR(36)
Bi_DimMembership_s3	enddate	TIMESTAMP
Bi_DimMembership_s3	CreditAmountExpiration	BOOLEAN
Bi_DimMembership_s3	NumGuests	INT
Bi_DimMembership_s3	AllowGiftCertificates	BOOLEAN
Bi_DimMembership_s3	DifferentMembershipCode	BOOLEAN
Bi_DimMembership_s3	CommissionFactor	FLOAT
Bi_DimMembership_s3	InitiallyRecognizedAmt	DECIMAL(19,4)
Bi_DimMembership_s3	MonthlyRecognizedAmt	DECIMAL(19,4)
Bi_DimMembership_s3	RestrictPayment	BOOLEAN
Bi_DimMembership_s3	Code	NVARCHAR(128)
Bi_DimMembership_s3	NeedOtpAuthorization	BOOLEAN
Bi_DimMembership_s3	FreeServiceCommissionEligible	BOOLEAN
Bi_DimMembership_s3	DiscountType	INT
Bi_DimMembership_s3	DisplayName	NVARCHAR(256)
Bi_DimMembership_s3	DisplayPrice	NVARCHAR(256)
Bi_DimMembership_s3	ShowPrice	BOOLEAN
Bi_DimMembership_s3	BusinessUnitId	VARCHAR(36)
Bi_DimMembership_s3	ShowFrequencyInWeeks	BOOLEAN
Bi_DimMembership_s3	MembershipMonths	INT
Bi_DimMembership_s3	RecurringType	INT
Bi_DimMembership_s3	CarryoverMembers	BOOLEAN
Bi_DimMembership_s3	RecurringCycle	NVARCHAR(256)
Bi_DimMembership_s3	RecurringCycleType	INT
Bi_DimMembership_s3	LockCycles	INT
Bi_DimMembership_s3	PaymentType	INT
Bi_DimMembership_s3	StartValidityAtFirstRedemption	BOOLEAN
Bi_DimMembership_s3	VisitFrequencyRedemption	INT
Bi_DimMembership_s3	CanBook	BOOLEAN
Bi_DimMembership_s3	MembershipType	INT
Bi_DimMembership_s3	MembershiptypeDisplayValue	NVARCHAR(MAX)
Bi_DimMembership_s3	SetupMembershipId	VARCHAR(36)
Bi_DimMembership_s3	void	BOOLEAN
Bi_DimMembership_s3	TAGS	VARCHAR(MAX)
Bi_DimMembership_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimMembership_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimMembership_s3	PodName	VARCHAR(20)
Bi_DimMembershipUser_s3	UserMembershipId	VARCHAR(36)	PK
Bi_DimMembershipUser_s3	UserId	VARCHAR(36)
Bi_DimMembershipUser_s3	MembershipId	VARCHAR(36)
Bi_DimMembershipUser_s3	CreationDate	TIMESTAMP
Bi_DimMembershipUser_s3	StartDate	TIMESTAMP
Bi_DimMembershipUser_s3	EndDate	TIMESTAMP
Bi_DimMembershipUser_s3	Void	BOOLEAN
Bi_DimMembershipUser_s3	CreditAmount	FLOAT
Bi_DimMembershipUser_s3	invoiceid	VARCHAR(36)
Bi_DimMembershipUser_s3	TransactionInvoiceNo	NVARCHAR(128)
Bi_DimMembershipUser_s3	SubscriptionStatus	INT
Bi_DimMembershipUser_s3	SubscriptionSource	INT
Bi_DimMembershipUser_s3	CancelledDate	TIMESTAMP
Bi_DimMembershipUser_s3	Recurring	INT
Bi_DimMembershipUser_s3	CancellationSource	NVARCHAR(128)
Bi_DimMembershipUser_s3	FirstSale	BOOLEAN
Bi_DimMembershipUser_s3	Closed	BOOLEAN
Bi_DimMembershipUser_s3	ClosedBy	VARCHAR(36)
Bi_DimMembershipUser_s3	ClosedOn	TIMESTAMP
Bi_DimMembershipUser_s3	ClosedInvoice	VARCHAR(36)
Bi_DimMembershipUser_s3	GroupUserMembershipid	VARCHAR(36)
Bi_DimMembershipUser_s3	RecurrenceOrder	INT
Bi_DimMembershipUser_s3	MembershipStatus	INT
Bi_DimMembershipUser_s3	AcceptedOn	TIMESTAMP
Bi_DimMembershipUser_s3	AcceptedFromIP	NVARCHAR(1024)
Bi_DimMembershipUser_s3	CancelledBy	VARCHAR(36)
Bi_DimMembershipUser_s3	NoOfCyclesPaid	INT
Bi_DimMembershipUser_s3	RenewalMembershipId	VARCHAR(36)
Bi_DimMembershipUser_s3	PreviousUserMembershipId	VARCHAR(36)
Bi_DimMembershipUser_s3	ChildInvoiceId	VARCHAR(36)
Bi_DimMembershipUser_s3	RedeemPostExpiry	BOOLEAN
Bi_DimMembershipUser_s3	ServiceCreditAmt	FLOAT
Bi_DimMembershipUser_s3	ProductCreditAmt	FLOAT
Bi_DimMembershipUser_s3	OtherCreditAmt	FLOAT
Bi_DimMembershipUser_s3	RenewMembershipAmount	FLOAT
Bi_DimMembershipUser_s3	RenewalDiscountAppliedBy	VARCHAR(36)
Bi_DimMembershipUser_s3	RenewalDiscountAppliedOn	TIMESTAMP
Bi_DimMembershipUser_s3	NumVisits	INT
Bi_DimMembershipUser_s3	SaleCenterId	VARCHAR(36)
Bi_DimMembershipUser_s3	OrganizationId	VARCHAR(36)
Bi_DimMembershipUser_s3	MembershipName	NVARCHAR(256)
Bi_DimMembershipUser_s3	Code	NVARCHAR(128)
Bi_DimMembershipUser_s3	DisplayPrice	NVARCHAR(256)
Bi_DimMembershipUser_s3	BusinessUnitId	VARCHAR(36)
Bi_DimMembershipUser_s3	FirstName	NVARCHAR(160)
Bi_DimMembershipUser_s3	LastName	NVARCHAR(256)
Bi_DimMembershipUser_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimMembershipUser_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimMembershipUser_s3	PodName	VARCHAR(20)
Bi_DimMembershipUser_s3	CenterId	VARCHAR(36)
Bi_DimOpportunitySource_s3	OpportunitySourceId	VARCHAR(36)	PK
Bi_DimOpportunitySource_s3	OrganizationId	VARCHAR(36)
Bi_DimOpportunitySource_s3	OpportunitySourceCode	NVARCHAR(256)
Bi_DimOpportunitySource_s3	OpportunitySourceName	NVARCHAR(256)
Bi_DimOpportunitySource_s3	OpportunitySourceDescription	NVARCHAR(4096)
Bi_DimOpportunitySource_s3	Active	BOOLEAN
Bi_DimOpportunitySource_s3	void	BOOLEAN
Bi_DimOpportunitySource_s3	OptionalField1	NVARCHAR(16000)
Bi_DimOpportunitySource_s3	OptionalField2	NVARCHAR(16000)
Bi_DimOpportunitySource_s3	OptionalField3	NVARCHAR(16000)
Bi_DimOpportunitySource_s3	OptionalField4	NVARCHAR(16000)
Bi_DimOpportunitySource_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimOpportunitySource_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimOpportunitySource_s3	PodName	VARCHAR(20)
Bi_DimOrgCustomFields_s3	FieldId	VARCHAR(36)	PK
Bi_DimOrgCustomFields_s3	FieldName	NVARCHAR(1024)
Bi_DimOrgCustomFields_s3	FieldDesc	NVARCHAR(4000)
Bi_DimOrgCustomFields_s3	OrganizationId	VARCHAR(36)
Bi_DimOrgCustomFields_s3	PrintOnReceipt	BOOLEAN
Bi_DimOrgCustomFields_s3	FieldTypeId	VARCHAR(36)
Bi_DimOrgCustomFields_s3	FieldTypeName	NVARCHAR(1024)
Bi_DimOrgCustomFields_s3	ListId	VARCHAR(36)
Bi_DimOrgCustomFields_s3	ListName	NVARCHAR(1024)
Bi_DimOrgCustomFields_s3	ListValue	NVARCHAR(65535)
Bi_DimOrgCustomFields_s3	ListDesc	NVARCHAR(4000)
Bi_DimOrgCustomFields_s3	FieldOrder	INT
Bi_DimOrgCustomFields_s3	CustomFieldType	INT
Bi_DimOrgCustomFields_s3	Void	BOOLEAN
Bi_DimOrgCustomFields_s3	Active	BOOLEAN
Bi_DimOrgCustomFields_s3	FieldAttributes	NVARCHAR(4000)
Bi_DimOrgCustomFields_s3	GroupId	DECIMAL(19,0)
Bi_DimOrgCustomFields_s3	DefaultValue	NVARCHAR(65535)
Bi_DimOrgCustomFields_s3	AllowGuestToView	BOOLEAN
Bi_DimOrgCustomFields_s3	AllowGuestToEdit	BOOLEAN
Bi_DimOrgCustomFields_s3	DataType	NVARCHAR(1024)
Bi_DimOrgCustomFields_s3	IsRequired	BOOLEAN
Bi_DimOrgCustomFields_s3	ShowInGrid	BOOLEAN
Bi_DimOrgCustomFields_s3	EntityDefinitionFK	DECIMAL(19,0)
Bi_DimOrgCustomFields_s3	ReferenceEntityDefFK	DECIMAL(19,0)
Bi_DimOrgCustomFields_s3	SpanAcrossColumns	BOOLEAN
Bi_DimOrgCustomFields_s3	MatchRegex	NVARCHAR(1020)
Bi_DimOrgCustomFields_s3	FormatFunc	NVARCHAR(16000)
Bi_DimOrgCustomFields_s3	ValidationMsgLabel	NVARCHAR(1020)
Bi_DimOrgCustomFields_s3	updatedOn	TIMESTAMP
Bi_DimOrgCustomFields_s3	FieldCode	NVARCHAR(128)
Bi_DimOrgCustomFields_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimOrgCustomFields_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimOrgCustomFields_s3	PodName	VARCHAR(20)
Bi_DimOrgDispositions_s3	OrgDispositionId	VARCHAR(36)	PK
Bi_DimOrgDispositions_s3	OrganizationId	VARCHAR(36)
Bi_DimOrgDispositions_s3	DispositionName	NVARCHAR(1600)
Bi_DimOrgDispositions_s3	Description	NVARCHAR(16000)
Bi_DimOrgDispositions_s3	FollowupDays	INT
Bi_DimOrgDispositions_s3	void	BOOLEAN
Bi_DimOrgDispositions_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimOrgDispositions_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimOrgDispositions_s3	PodName	VARCHAR(20)
Bi_DimOrgLPTier_s3	LPTierPK	INT	PK
Bi_DimOrgLPTier_s3	TierId	VARCHAR(36)
Bi_DimOrgLPTier_s3	OrganizationId	VARCHAR(36)
Bi_DimOrgLPTier_s3	TierName	NVARCHAR(512)
Bi_DimOrgLPTier_s3	MinSpent	DECIMAL(19,4)
Bi_DimOrgLPTier_s3	DaysToStayBeforeDowngrade	INT
Bi_DimOrgLPTier_s3	ExpiryInDaysForPointsEarned	INT
Bi_DimOrgLPTier_s3	Void	BOOLEAN
Bi_DimOrgLPTier_s3	TierDesc	NVARCHAR(65535)
Bi_DimOrgLPTier_s3	LPItemTypesMask	INT
Bi_DimOrgLPTier_s3	MinSpentToStay	FLOAT
Bi_DimOrgLPTier_s3	AllowRedemtpionByThisTierGuests	BOOLEAN
Bi_DimOrgLPTier_s3	AllowDowngradeToThisTier	BOOLEAN
Bi_DimOrgLPTier_s3	LpTierIcon	INT
Bi_DimOrgLPTier_s3	ExchangeRate	FLOAT
Bi_DimOrgLPTier_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimOrgLPTier_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimOrgLPTier_s3	PodName	VARCHAR(20)
Bi_DimOrgPaymentOption_s3	organizationid	VARCHAR(36)
Bi_DimOrgPaymentOption_s3	paymentoptiontype	NVARCHAR(160)
Bi_DimOrgPaymentOption_s3	paymenttype	NVARCHAR(40)
Bi_DimOrgPaymentOption_s3	orgaPaymentOptionId	VARCHAR(36)	PK
Bi_DimOrgPaymentOption_s3	paymenttypedisplayname	NVARCHAR(MAX)
Bi_DimOrgPaymentOption_s3	void	INT
Bi_DimOrgPaymentOption_s3	paymentoptiontypeintid	VARCHAR(100)
Bi_DimOrgPaymentOption_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimOrgPaymentOption_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimOrgPaymentOption_s3	PodName	VARCHAR(20)
Bi_DimPackage_s3	PackageversionID	VARCHAR(36)
Bi_DimPackage_s3	PackageId	VARCHAR(36)	PK
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_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_DimPackageCenter_s3	PackageCenterId	varchar(36)	PK
Bi_DimPackageCenter_s3	PackageId	varchar(36)
Bi_DimPackageCenter_s3	CenterId	varchar(36)
Bi_DimPackageCenter_s3	PackageVersionId	varchar(36)
Bi_DimPackageCenter_s3	Price	NUMERIC(19,4)
Bi_DimPackageCenter_s3	CenterTaxId	varchar(36)
Bi_DimPackageCenter_s3	AutoRenewalPrice	float
Bi_DimPackageCenter_s3	RenewalDiscount	varchar(150)
Bi_DimPackageCenter_s3	Active	BOOLEAN
Bi_DimPackageCenter_s3	CalculateServiceLevelTax	BOOLEAN
Bi_DimPackageCenter_s3	EnableItemLevelTax	INT
Bi_DimPackageCenter_s3	Void	BOOLEAN
Bi_DimPackageCenter_s3	OrganizationId	varchar(36)
Bi_DimPackageCenter_s3	tpcImportId	BIGINT
Bi_DimPackageCenter_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimPackageCenter_s3	EtlLastUpdatedBy	VARCHAR(50)
Bi_DimPackageCenter_s3	PodName	VARCHAR(20)
Bi_DimPackageUser_s3	PackageUserId	VARCHAR(36)	PK
Bi_DimPackageUser_s3	PackageId	VARCHAR(36)
Bi_DimPackageUser_s3	UserId	VARCHAR(36)
Bi_DimPackageUser_s3	CreationDate	TIMESTAMP
Bi_DimPackageUser_s3	StartDate	TIMESTAMP
Bi_DimPackageUser_s3	EndDate	TIMESTAMP
Bi_DimPackageUser_s3	invoiceid	VARCHAR(36)
Bi_DimPackageUser_s3	EndDateWithGracePeriod	TIMESTAMP
Bi_DimPackageUser_s3	Closed	BOOLEAN
Bi_DimPackageUser_s3	ClosedBy	VARCHAR(36)
Bi_DimPackageUser_s3	ClosedOn	TIMESTAMP
Bi_DimPackageUser_s3	closedinvoice	VARCHAR(36)
Bi_DimPackageUser_s3	PackageUserPK	DECIMAL(19,0)
Bi_DimPackageUser_s3	PackageStatus	INT
Bi_DimPackageUser_s3	invoiceitemid	VARCHAR(36)
Bi_DimPackageUser_s3	Void	BOOLEAN
Bi_DimPackageUser_s3	PodName	VARCHAR(20)
Bi_DimPackageUser_s3	PackageName	NVARCHAR(512)
Bi_DimPackageUser_s3	PackageCode	NVARCHAR(512)
Bi_DimPackageUser_s3	PackagePrice	DECIMAL(19,4)
Bi_DimPackageUser_s3	BusinessUnitId	VARCHAR(36)
Bi_DimPackageUser_s3	FirstName	NVARCHAR(160)
Bi_DimPackageUser_s3	LastName	NVARCHAR(256)
Bi_DimPackageUser_s3	organizationid	VARCHAR(36)
Bi_DimPackageUser_s3	SaleCenterId	VARCHAR(36)
Bi_DimPackageUser_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimPackageUser_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimPackageUser_s3	CenterId	VARCHAR(36)
Bi_DimProduct_s3	BusinessUnitId	VARCHAR(36)
Bi_DimProduct_s3	CategoryId	VARCHAR(36)
Bi_DimProduct_s3	CategoryName	NVARCHAR(1024)
Bi_DimProduct_s3	CategoryCode	NVARCHAR(128)
Bi_DimProduct_s3	ParentCategoryID	VARCHAR(36)
Bi_DimProduct_s3	ParentCategoryName	NVARCHAR(1024)
Bi_DimProduct_s3	ParentCategoryCode	NVARCHAR(128)
Bi_DimProduct_s3	BusinessUnitName	NVARCHAR(800)
Bi_DimProduct_s3	BusinessUnitDescription	NVARCHAR(8000)
Bi_DimProduct_s3	ComissionEligible	BOOLEAN
Bi_DimProduct_s3	CommissionFactor	FLOAT
Bi_DimProduct_s3	Consummable	BOOLEAN
Bi_DimProduct_s3	HasVariant	BOOLEAN
Bi_DimProduct_s3	IsSouldOut	BOOLEAN
Bi_DimProduct_s3	LoyaltyEligible	BOOLEAN
Bi_DimProduct_s3	MetaDescription	NVARCHAR(1024)
Bi_DimProduct_s3	MetaKeywords	NVARCHAR(1024)
Bi_DimProduct_s3	MRP	FLOAT
Bi_DimProduct_s3	organizationID	VARCHAR(36)
Bi_DimProduct_s3	ProductCatalogPrice	NVARCHAR(256)
Bi_DimProduct_s3	ProductCode	NVARCHAR(128)
Bi_DimProduct_s3	ProductDesc	NVARCHAR(4096)
Bi_DimProduct_s3	ProductDisplayName	NVARCHAR(512)
Bi_DimProduct_s3	productid	VARCHAR(36)	PK
Bi_DimProduct_s3	ProductName	NVARCHAR(1024)
Bi_DimProduct_s3	ProductNew	BOOLEAN
Bi_DimProduct_s3	ProductRecommended	BOOLEAN
Bi_DimProduct_s3	ProductSortOrder	INT
Bi_DimProduct_s3	Retail	BOOLEAN
Bi_DimProduct_s3	TransferPrice	FLOAT
Bi_DimProduct_s3	Volumeperitem	FLOAT
Bi_DimProduct_s3	VolumeTypeName	NVARCHAR(256)
Bi_DimProduct_s3	void	BOOLEAN
Bi_DimProduct_s3	TAGS	VARCHAR(MAX)
Bi_DimProduct_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimProduct_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimProduct_s3	ProductColorName	NVARCHAR(1024)
Bi_DimProduct_s3	ProductSizeName	NVARCHAR(1024)
Bi_DimProduct_s3	BrandId	VARCHAR(36)
Bi_DimProduct_s3	BrandCode	VARCHAR(512)
Bi_DimProduct_s3	BrandName	VARCHAR(512)
Bi_DimProduct_s3	PodName	VARCHAR(20)
Bi_DimProductCenter_s3	ProductCenterId	VARCHAR(36)	PK
Bi_DimProductCenter_s3	ProductId	VARCHAR(36)
Bi_DimProductCenter_s3	CenterId	VARCHAR(36)
Bi_DimProductCenter_s3	SalePrice	DECIMAL(19,4)
Bi_DimProductCenter_s3	IncludesTax	BOOLEAN
Bi_DimProductCenter_s3	CenterTaxId	VARCHAR(36)
Bi_DimProductCenter_s3	Void	BOOLEAN
Bi_DimProductCenter_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimProductCenter_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimProductCenter_s3	PodName	VARCHAR(20)
Bi_DimProductCenter_s3	OrganizationId	VARCHAR(36)
Bi_DimProductCenter_s3	DesiredInventory	float
Bi_DimProductCenter_s3	OrderInventory	float
Bi_DimProductCenter_s3	AlertInventory	float
Bi_DimProductCenter_s3	ConsumableDesiredInventory	float
Bi_DimProductCenter_s3	ConsumableOrderInventory	float
Bi_DimProductCenter_s3	ConsumableAlertInventory	float
Bi_DimReasons_s3	ReasonId	VARCHAR(36)
Bi_DimReasons_s3	ReasonCode	NVARCHAR(512)
Bi_DimReasons_s3	Reason	NVARCHAR(1024)
Bi_DimReasons_s3	Description	NVARCHAR(2048)
Bi_DimReasons_s3	ObjectType	INT
Bi_DimReasons_s3	ActionType	INT
Bi_DimReasons_s3	OrganizationId	VARCHAR(36)
Bi_DimReasons_s3	Active	BOOLEAN
Bi_DimReasons_s3	CreatedDate	TIMESTAMP
Bi_DimReasons_s3	ReasonPK	DECIMAL(19,0)	PK
Bi_DimReasons_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimReasons_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimReasons_s3	PodName	VARCHAR(20)
Bi_DimRecurrenceDetails_s3	RecurrenceId	VARCHAR(36)	PK
Bi_DimRecurrenceDetails_s3	centerId	VARCHAR(36)
Bi_DimRecurrenceDetails_s3	CreatedBy	VARCHAR(36)
Bi_DimRecurrenceDetails_s3	createon	TIMESTAMP
Bi_DimRecurrenceDetails_s3	EndDate	TIMESTAMP
Bi_DimRecurrenceDetails_s3	Interval	INT
Bi_DimRecurrenceDetails_s3	IsPerpetual	BOOLEAN
Bi_DimRecurrenceDetails_s3	LastUpdated	TIMESTAMP
Bi_DimRecurrenceDetails_s3	Occurences	INT
Bi_DimRecurrenceDetails_s3	StandingAppts	INT
Bi_DimRecurrenceDetails_s3	StartDate	TIMESTAMP
Bi_DimRecurrenceDetails_s3	Timeperiod	VARCHAR(80)
Bi_DimRecurrenceDetails_s3	unchecked	BOOLEAN
Bi_DimRecurrenceDetails_s3	weekdays	INT
Bi_DimRecurrenceDetails_s3	OrganizationId	VARCHAR(36)
Bi_DimRecurrenceDetails_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimRecurrenceDetails_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimRecurrenceDetails_s3	PodName	VARCHAR(20)
Bi_DimResource_s3	ResourceId	VARCHAR(36)	PK
Bi_DimResource_s3	ResourceName	NVARCHAR(128)
Bi_DimResource_s3	ResourceTypeName	NVARCHAR(128)
Bi_DimResource_s3	CenterId	VARCHAR(36)
Bi_DimResource_s3	ResourceTypeId	VARCHAR(36)
Bi_DimResource_s3	Capacity	INT
Bi_DimResource_s3	ShowInReceipt	BOOLEAN
Bi_DimResource_s3	IndicatorColor	NVARCHAR(128)
Bi_DimResource_s3	ResourceCode	NVARCHAR(128)
Bi_DimResource_s3	CanExceedRoomCapacity	BOOLEAN
Bi_DimResource_s3	void	BOOLEAN
Bi_DimResource_s3	RoomCategoryId	VARCHAR(36)
Bi_DimResource_s3	RoomCategoryCode	NVARCHAR(800)
Bi_DimResource_s3	RoomCategoryName	NVARCHAR(800)
Bi_DimResource_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimResource_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimResource_s3	PodName	VARCHAR(20)
Bi_DimResource_s3	organizationid	VARCHAR(36)
Bi_DimResourceServiceAssociation_s3	ResourceServiceId	VARCHAR(36)	PK
Bi_DimResourceServiceAssociation_s3	ResourceId	VARCHAR(36)
Bi_DimResourceServiceAssociation_s3	ServiceId	VARCHAR(36)
Bi_DimResourceServiceAssociation_s3	CategoryId	VARCHAR(36)
Bi_DimResourceServiceAssociation_s3	Factor	FLOAT
Bi_DimResourceServiceAssociation_s3	Void	BOOLEAN
Bi_DimResourceServiceAssociation_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimResourceServiceAssociation_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimResourceServiceAssociation_s3	PodName	VARCHAR(20)
Bi_DimResourceServiceAssociation_s3	CenterId	VARCHAR(36)
Bi_DimResourceServiceAssociation_s3	OrganizationId	VARCHAR(36)
Bi_DimService_s3	ServiceID	VARCHAR(36)	PK
Bi_DimService_s3	ServiceName	NVARCHAR(512)
Bi_DimService_s3	ServiceLength	INT
Bi_DimService_s3	CategoryID	VARCHAR(36)
Bi_DimService_s3	CategoryName	NVARCHAR(1024)
Bi_DimService_s3	CategoryCode	NVARCHAR(128)
Bi_DimService_s3	ParentCategoryID	VARCHAR(36)
Bi_DimService_s3	ParentCategoryName	NVARCHAR(1024)
Bi_DimService_s3	ParentCategoryCode	NVARCHAR(128)
Bi_DimService_s3	ServiceDesc	NVARCHAR(4096)
Bi_DimService_s3	OrganizationID	VARCHAR(36)
Bi_DimService_s3	ServiceInternalCost	DECIMAL(19,4)
Bi_DimService_s3	ComissionEligible	BOOLEAN
Bi_DimService_s3	RecoveryTime	INT
Bi_DimService_s3	CommissionFactor	FLOAT
Bi_DimService_s3	ShowInCatalog	INT
Bi_DimService_s3	CatalogRecommended	INT
Bi_DimService_s3	CatalogNew	INT
Bi_DimService_s3	ServiceDisplayName	NVARCHAR(512)
Bi_DimService_s3	ServiceCatalogPrice	NVARCHAR(128)
Bi_DimService_s3	HasVariant	INT
Bi_DimService_s3	IsVariant	INT
Bi_DimService_s3	Code	NVARCHAR(128)
Bi_DimService_s3	ShowPrice	BOOLEAN
Bi_DimService_s3	BusinessUnitId	VARCHAR(36)
Bi_DimService_s3	Frequency	FLOAT
Bi_DimService_s3	CommissionType	INT
Bi_DimService_s3	FlatCommissionValue	FLOAT
Bi_DimService_s3	ServiceNotes	NVARCHAR(8192)
Bi_DimService_s3	IsAddOn	BOOLEAN
Bi_DimService_s3	BusinessUnitName	NVARCHAR(800)
Bi_DimService_s3	BusinessUnitDescription	NVARCHAR(8000)
Bi_DimService_s3	void	BOOLEAN
Bi_DimService_s3	TAGS	VARCHAR(MAX)
Bi_DimService_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimService_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimService_s3	PodName	VARCHAR(20)
Bi_DimServiceCenter_s3	ServiceCenterId	VARCHAR(36)	PK
Bi_DimServiceCenter_s3	ServiceId	VARCHAR(36)
Bi_DimServiceCenter_s3	CenterId	VARCHAR(36)
Bi_DimServiceCenter_s3	ServicePrice	DECIMAL(19,4)
Bi_DimServiceCenter_s3	IncludesTax	BOOLEAN
Bi_DimServiceCenter_s3	CenterTaxId	VARCHAR(36)
Bi_DimServiceCenter_s3	SSGValue	FLOAT
Bi_DimServiceCenter_s3	DemandGroupId	VARCHAR(36)
Bi_DimServiceCenter_s3	MemberServicePrice	DECIMAL(19,4)
Bi_DimServiceCenter_s3	Void	BOOLEAN
Bi_DimServiceCenter_s3	ShowInCatalog	BOOLEAN
Bi_DimServiceCenter_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimServiceCenter_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimServiceCenter_s3	PodName	VARCHAR(20)
Bi_DimServiceCenter_s3	OrganizationId	VARCHAR(36)
Bi_DimServiceSegment_s3	ServiceID	VARCHAR(36)
Bi_DimServiceSegment_s3	ServiceSegmentID	VARCHAR(36)
Bi_DimServiceSegment_s3	ServiceSegmentName	NVARCHAR(2048)
Bi_DimServiceSegment_s3	ServiceSegmentType	INT
Bi_DimServiceSegment_s3	ServiceSegmentLength	INT
Bi_DimServiceSegment_s3	SegmentOrder	INT
Bi_DimServiceSegment_s3	Commission	FLOAT
Bi_DimServiceSegment_s3	void	BOOLEAN
Bi_DimServiceSegment_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimServiceSegment_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimServiceSegment_s3	PodName	VARCHAR(20)
Bi_DimServiceSegment_s3	organizationid	VARCHAR(36)
Bi_DimSession_s3	DimSegmentID	DECIMAL(19,0)
Bi_DimSession_s3	sessionpk	DECIMAL(19,0)	PK
Bi_DimSession_s3	classfk	DECIMAL(19,0)
Bi_DimSession_s3	organizationid	VARCHAR(36)
Bi_DimSession_s3	CenterID	VARCHAR(36)
Bi_DimSession_s3	sessionname	NVARCHAR(512)
Bi_DimSession_s3	sessioncode	NVARCHAR(128)
Bi_DimSession_s3	sessionstartdt	TIMESTAMP
Bi_DimSession_s3	sessionenddt	TIMESTAMP
Bi_DimSession_s3	internalcost	DECIMAL(19,4)
Bi_DimSession_s3	iscancelled	BOOLEAN
Bi_DimSession_s3	instructoruserid	VARCHAR(36)
Bi_DimSession_s3	assistantuserid	VARCHAR(36)
Bi_DimSession_s3	roomresourceid	VARCHAR(36)
Bi_DimSession_s3	catalogname	NVARCHAR(512)
Bi_DimSession_s3	showincatalog	INT
Bi_DimSession_s3	showprice	BOOLEAN
Bi_DimSession_s3	catalogprice	NVARCHAR(128)
Bi_DimSession_s3	void	BOOLEAN
Bi_DimSession_s3	capacity	INT
Bi_DimSession_s3	webcapacity	INT
Bi_DimSession_s3	isopenforreg	BOOLEAN
Bi_DimSession_s3	canbook	BOOLEAN
Bi_DimSession_s3	allowdirectbooking	BOOLEAN
Bi_DimSession_s3	minsbeforeclasswebbookingclose	INT
Bi_DimSession_s3	minsafterregistrationforearlycancel	INT
Bi_DimSession_s3	recoverytime	INT
Bi_DimSession_s3	comissioneligible	BOOLEAN
Bi_DimSession_s3	commissionfactor	FLOAT
Bi_DimSession_s3	commissiontype	INT
Bi_DimSession_s3	flatcommissionvalue	FLOAT
Bi_DimSession_s3	earlycancellationfee	DECIMAL(19,4)
Bi_DimSession_s3	latecancellationfee	DECIMAL(19,4)
Bi_DimSession_s3	noshowfee	DECIMAL(19,4)
Bi_DimSession_s3	allowwaitlist	BOOLEAN
Bi_DimSession_s3	allowsubstitution	BOOLEAN
Bi_DimSession_s3	lock	BOOLEAN
Bi_DimSession_s3	statusfk	INT
Bi_DimSession_s3	classrecurrencefk	DECIMAL(19,0)
Bi_DimSession_s3	waitlistlockwindow	INT
Bi_DimSession_s3	isfreesession	BOOLEAN
Bi_DimSession_s3	registrationlockwindow	FLOAT
Bi_DimSession_s3	automaticconfirmationlockwindow	FLOAT
Bi_DimSession_s3	eventfk	DECIMAL(19,0)
Bi_DimSession_s3	isinstructorsubstituted	BOOLEAN
Bi_DimSession_s3	instructorvirtuallink	NVARCHAR(65535)
Bi_DimSession_s3	studentvirtuallink	NVARCHAR(65535)
Bi_DimSession_s3	minsbeforeclassforearlycancel	INT
Bi_DimSession_s3	sessiondesc	NVARCHAR(65535)
Bi_DimSession_s3	classname	NVARCHAR(512)
Bi_DimSession_s3	categoryfk	DECIMAL(19,0)
Bi_DimSession_s3	classcode	NVARCHAR(128)
Bi_DimSession_s3	businessunitfk	DECIMAL(19,0)
Bi_DimSession_s3	durationinmins	INT
Bi_DimSession_s3	classdesc	NVARCHAR(65535)
Bi_DimSession_s3	waitinglisttype	INT
Bi_DimSession_s3	levelfk	DECIMAL(19,0)
Bi_DimSession_s3	enablepayments	BOOLEAN
Bi_DimSession_s3	classtype	INT
Bi_DimSession_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimSession_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimSession_s3	ClassVoid	BOOLEAN
Bi_DimSession_s3	InitialInstructorID	VARCHAR(36)
Bi_DimSession_s3	PodName	VARCHAR(20)
Bi_DimStatus_s3	DimStatusId	INT	PK
Bi_DimStatus_s3	StatusTypeCode	NVARCHAR(400)
Bi_DimStatus_s3	StatusDisplayValue	NVARCHAR(400)
Bi_DimStatus_s3	StatusCode	NVARCHAR(400)
Bi_DimStatus_s3	StatusValue	INT
Bi_DimStatus_s3	void	BOOLEAN
Bi_DimStatus_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimStatus_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimStatus_s3	PodName	VARCHAR(20)
Bi_DimStatus_s3	organizationid	VARCHAR(36)
Bi_DimTrainingCenter_s3	trainingcenterid	DECIMAL(19,0)	PK
Bi_DimTrainingCenter_s3	Classid	VARCHAR(36)
Bi_DimTrainingCenter_s3	CenterId	VARCHAR(36)
Bi_DimTrainingCenter_s3	Price	DECIMAL(19,4)
Bi_DimTrainingCenter_s3	IncludesTax	BOOLEAN
Bi_DimTrainingCenter_s3	CenterTaxId	VARCHAR(36)
Bi_DimTrainingCenter_s3	Void	BOOLEAN
Bi_DimTrainingCenter_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimTrainingCenter_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimTrainingCenter_s3	PodName	VARCHAR(20)
Bi_DimTrainingCenter_s3	OrganizationId	VARCHAR(36)
Bi_DimTrainingClass_s3	Classid	VARCHAR(36)	PK
Bi_DimTrainingClass_s3	ClassName	NVARCHAR(512)
Bi_DimTrainingClass_s3	ClassType	INT
Bi_DimTrainingClass_s3	ClassLength	INT
Bi_DimTrainingClass_s3	CategoryID	VARCHAR(36)
Bi_DimTrainingClass_s3	CategoryName	NVARCHAR(1024)
Bi_DimTrainingClass_s3	CategoryCode	NVARCHAR(200)
Bi_DimTrainingClass_s3	ParentCategoryID	VARCHAR(36)
Bi_DimTrainingClass_s3	ParentCategoryName	NVARCHAR(1024)
Bi_DimTrainingClass_s3	ParentCategoryCode	NVARCHAR(200)
Bi_DimTrainingClass_s3	ClassDesc	NVARCHAR(65535)
Bi_DimTrainingClass_s3	OrganizationID	VARCHAR(36)
Bi_DimTrainingClass_s3	ClassInternalCost	DECIMAL(19,4)
Bi_DimTrainingClass_s3	ComissionEligible	BOOLEAN
Bi_DimTrainingClass_s3	RecoveryTime	INT
Bi_DimTrainingClass_s3	CommissionFactor	FLOAT
Bi_DimTrainingClass_s3	ShowInCatalog	INT
Bi_DimTrainingClass_s3	CatalogRecommended	INT
Bi_DimTrainingClass_s3	CatalogNew	INT
Bi_DimTrainingClass_s3	ClassDisplayName	NVARCHAR(512)
Bi_DimTrainingClass_s3	ClassCatalogPrice	NVARCHAR(128)
Bi_DimTrainingClass_s3	Code	NVARCHAR(128)
Bi_DimTrainingClass_s3	ShowPrice	BOOLEAN
Bi_DimTrainingClass_s3	BusinessUnitId	VARCHAR(36)
Bi_DimTrainingClass_s3	CommissionType	INT
Bi_DimTrainingClass_s3	FlatCommissionValue	FLOAT
Bi_DimTrainingClass_s3	RegistrationNotes	NVARCHAR(4096)
Bi_DimTrainingClass_s3	BusinessUnitName	NVARCHAR(800)
Bi_DimTrainingClass_s3	BusinessUnitDescription	NVARCHAR(8000)
Bi_DimTrainingClass_s3	void	BOOLEAN
Bi_DimTrainingClass_s3	TAGS	VARCHAR(MAX)
Bi_DimTrainingClass_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimTrainingClass_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimTrainingClass_s3	PodName	VARCHAR(20)
Bi_Dimuser_s3	userid	NVARCHAR(144)	PK
Bi_Dimuser_s3	firstname	NVARCHAR(160)
Bi_Dimuser_s3	lastname	NVARCHAR(256)
Bi_Dimuser_s3	middlename	NVARCHAR(128)
Bi_Dimuser_s3	address1	NVARCHAR(2048)
Bi_Dimuser_s3	address2	NVARCHAR(2048)
Bi_Dimuser_s3	city	NVARCHAR(128)
Bi_Dimuser_s3	StateOther	NVARCHAR(128)
Bi_Dimuser_s3	ZipCode	NVARCHAR(128)
Bi_Dimuser_s3	UserTypeID	VARCHAR(36)
Bi_Dimuser_s3	UserTypeName	NVARCHAR(128)
Bi_Dimuser_s3	CreationDt	TIMESTAMP
Bi_Dimuser_s3	CenterID	VARCHAR(36)
Bi_Dimuser_s3	Email	NVARCHAR(256)
Bi_Dimuser_s3	homephone	NVARCHAR(64)
Bi_Dimuser_s3	mobilephone	NVARCHAR(64)
Bi_Dimuser_s3	workphone	NVARCHAR(64)
Bi_Dimuser_s3	username	NVARCHAR(256)
Bi_Dimuser_s3	usercode	NVARCHAR(512)
Bi_Dimuser_s3	lastlogin	TIMESTAMP
Bi_Dimuser_s3	gender	INT
Bi_Dimuser_s3	dob	TIMESTAMP
Bi_Dimuser_s3	preferredTherapist	VARCHAR(36)
Bi_Dimuser_s3	preferredRoom	VARCHAR(36)
Bi_Dimuser_s3	otherpreferences	NVARCHAR(65535)
Bi_Dimuser_s3	referralsourceid	VARCHAR(36)
Bi_Dimuser_s3	roomno	NVARCHAR(80)
Bi_Dimuser_s3	referredby	VARCHAR(36)
Bi_Dimuser_s3	anniversarydate	TIMESTAMP
Bi_Dimuser_s3	PreferedCenerId	VARCHAR(36)
Bi_Dimuser_s3	registrationsource	INT
Bi_Dimuser_s3	customerapplogin	INT
Bi_Dimuser_s3	mobilecountrydname	NVARCHAR(4096)
Bi_Dimuser_s3	mobilecountrysname	NVARCHAR(4096)
Bi_Dimuser_s3	stateDispName	NVARCHAR(4096)
Bi_Dimuser_s3	stateShortName	NVARCHAR(4096)
Bi_Dimuser_s3	statecode	NVARCHAR(40)
Bi_Dimuser_s3	CountryDName	NVARCHAR(4096)
Bi_Dimuser_s3	CountrySName	NVARCHAR(4096)
Bi_Dimuser_s3	ReceiveTransactionalSMS	BOOLEAN
Bi_Dimuser_s3	ReceiveMarketingSMS	BOOLEAN
Bi_Dimuser_s3	UserPK	DECIMAL(19,0)
Bi_Dimuser_s3	UnSubscribeToTransactionalEmail	BOOLEAN
Bi_Dimuser_s3	UnSubscribeToMarketingEmail	BOOLEAN
Bi_Dimuser_s3	PasswordUpdatedOn	TIMESTAMP
Bi_Dimuser_s3	ReceiveTransactionalEMail	BOOLEAN
Bi_Dimuser_s3	ReceiveMarketingEMail	BOOLEAN
Bi_Dimuser_s3	AcceptedTAndC	INT
Bi_Dimuser_s3	NationalityFK	INT
Bi_Dimuser_s3	DOB_IncompleteYear	NVARCHAR(20)
Bi_Dimuser_s3	organizationid	VARCHAR(36)
Bi_Dimuser_s3	Void	BOOLEAN
Bi_Dimuser_s3	employeetags	VARCHAR(MAX)
Bi_Dimuser_s3	usertags	VARCHAR(MAX)
Bi_Dimuser_s3	JobName	NVARCHAR(1020)
Bi_Dimuser_s3	JobCode	NVARCHAR(8000)
Bi_Dimuser_s3	GuestReferralSource	NVARCHAR(1600)
Bi_Dimuser_s3	EmailState	INT
Bi_Dimuser_s3	MandatoryBreakTimePerDay	INT
Bi_Dimuser_s3	PhoneCode	INT
Bi_Dimuser_s3	StartDate	TIMESTAMP
Bi_Dimuser_s3	LastDate	TIMESTAMP
Bi_Dimuser_s3	NoSaleComments	VARCHAR(MAX)
Bi_Dimuser_s3	AdditionalField1	NVARCHAR(4096)
Bi_Dimuser_s3	AdditionalField2	NVARCHAR(4096)
Bi_Dimuser_s3	EmployeeCode	NVARCHAR(512)
Bi_Dimuser_s3	RelationshipManager	VARCHAR(36)
Bi_Dimuser_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_Dimuser_s3	EtlLastUpdatedBy	NVARCHAR(512)
Bi_Dimuser_s3	Date1	TIMESTAMP
Bi_Dimuser_s3	Date2	TIMESTAMP
Bi_Dimuser_s3	PodName	VARCHAR(20)
Bi_DimUserNotes_s3	NoteId	VARCHAR(36)	PK
Bi_DimUserNotes_s3	UserId	VARCHAR(36)
Bi_DimUserNotes_s3	CenterId	VARCHAR(36)
Bi_DimUserNotes_s3	ObjectId	VARCHAR(36)
Bi_DimUserNotes_s3	NoteType	NVARCHAR(4096)
Bi_DimUserNotes_s3	Privacytype	NVARCHAR(4096)
Bi_DimUserNotes_s3	IsPrivate	BOOLEAN
Bi_DimUserNotes_s3	Note	NVARCHAR(65535)
Bi_DimUserNotes_s3	Alert	BOOLEAN
Bi_DimUserNotes_s3	CreatedBy	VARCHAR(36)
Bi_DimUserNotes_s3	CreateDate	TIMESTAMP
Bi_DimUserNotes_s3	UpdatedBy	VARCHAR(36)
Bi_DimUserNotes_s3	UpdatedOn	TIMESTAMP
Bi_DimUserNotes_s3	SOURCE	NVARCHAR(128)
Bi_DimUserNotes_s3	Entity	DECIMAL(19,0)
Bi_DimUserNotes_s3	Void	BOOLEAN
Bi_DimUserNotes_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimUserNotes_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimUserNotes_s3	PodName	VARCHAR(20)
Bi_DimUserNotes_s3	organizationid	VARCHAR(36)
Bi_DimUserUpdateHistory_s3	UserHistoryPK	DECIMAL(19,0)	PK
Bi_DimUserUpdateHistory_s3	userid	VARCHAR(36)
Bi_DimUserUpdateHistory_s3	TuuhOrgId	VARCHAR(36)
Bi_DimUserUpdateHistory_s3	CurrentValue	NVARCHAR(65535)
Bi_DimUserUpdateHistory_s3	settingname	NVARCHAR(2048)
Bi_DimUserUpdateHistory_s3	startDate	TIMESTAMP
Bi_DimUserUpdateHistory_s3	enddate	TIMESTAMP
Bi_DimUserUpdateHistory_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimUserUpdateHistory_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimUserUpdateHistory_s3	organizationid	VARCHAR(36)
Bi_DimUserUpdateHistory_s3	PodName	VARCHAR(20)
Bi_DimUtcToCenterTime_s3	MinutesToAdd	INT
Bi_DimUtcToCenterTime_s3	centerid	VARCHAR(36)	PK
Bi_DimUtcToCenterTime_s3	centername	NVARCHAR(512)
Bi_DimUtcToCenterTime_s3	organizationid	VARCHAR(36)
Bi_DimUtcToCenterTime_s3	OrgAccountName	NVARCHAR(256)
Bi_DimUtcToCenterTime_s3	organizationname	NVARCHAR(512)
Bi_DimUtcToCenterTime_s3	void	BOOLEAN
Bi_DimUtcToCenterTime_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimUtcToCenterTime_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimUtcToCenterTime_s3	PodName	VARCHAR(20)
Bi_DimVendor_s3	VendorId	VARCHAR(36)	PK
Bi_DimVendor_s3	VendorName	NVARCHAR(512)
Bi_DimVendor_s3	VendorEmail	NVARCHAR(256)
Bi_DimVendor_s3	VendorAddress1	NVARCHAR(256)
Bi_DimVendor_s3	VendorAddress2	NVARCHAR(256)
Bi_DimVendor_s3	VendorCity	NVARCHAR(128)
Bi_DimVendor_s3	VendorStateOther	NVARCHAR(128)
Bi_DimVendor_s3	VendorZipCode	NVARCHAR(32)
Bi_DimVendor_s3	VendorWorkPhone	NVARCHAR(64)
Bi_DimVendor_s3	TaxCharged	FLOAT
Bi_DimVendor_s3	OrganizationID	VARCHAR(36)
Bi_DimVendor_s3	VendorCST	NVARCHAR(256)
Bi_DimVendor_s3	VendorTIN	NVARCHAR(256)
Bi_DimVendor_s3	VendorWorkPhoneCountryFk	INT
Bi_DimVendor_s3	VendorCode	NVARCHAR(512)
Bi_DimVendor_s3	VendorDesc	NVARCHAR(8000)
Bi_DimVendor_s3	Void	BOOLEAN
Bi_DimVendor_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimVendor_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimVendor_s3	PodName	VARCHAR(20)
Bi_DimWorkshop_s3	DimSegmentID	DECIMAL(19,0)
Bi_DimWorkshop_s3	trackpk	DECIMAL(19,0)	PK
Bi_DimWorkshop_s3	classfk	DECIMAL(19,0)
Bi_DimWorkshop_s3	organizationid	VARCHAR(36)
Bi_DimWorkshop_s3	centerid	VARCHAR(36)
Bi_DimWorkshop_s3	trackname	NVARCHAR(512)
Bi_DimWorkshop_s3	trackcode	NVARCHAR(128)
Bi_DimWorkshop_s3	trackstartdt	TIMESTAMP
Bi_DimWorkshop_s3	trackenddt	TIMESTAMP
Bi_DimWorkshop_s3	internalcost	DECIMAL(19,4)
Bi_DimWorkshop_s3	price	DECIMAL(19,4)
Bi_DimWorkshop_s3	iscancelled	BOOLEAN
Bi_DimWorkshop_s3	void	BOOLEAN
Bi_DimWorkshop_s3	isopenforreg	BOOLEAN
Bi_DimWorkshop_s3	isfreesession	BOOLEAN
Bi_DimWorkshop_s3	canbook	BOOLEAN
Bi_DimWorkshop_s3	lock	BOOLEAN
Bi_DimWorkshop_s3	capacity	INT
Bi_DimWorkshop_s3	statusfk	INT
Bi_DimWorkshop_s3	workshopname	NVARCHAR(512)
Bi_DimWorkshop_s3	categoryfk	DECIMAL(19,0)
Bi_DimWorkshop_s3	workshopcode	NVARCHAR(128)
Bi_DimWorkshop_s3	businessunitfk	DECIMAL(19,0)
Bi_DimWorkshop_s3	durationinmins	INT
Bi_DimWorkshop_s3	workshopdesc	NVARCHAR(65535)
Bi_DimWorkshop_s3	waitinglisttype	INT
Bi_DimWorkshop_s3	levelfk	DECIMAL(19,0)
Bi_DimWorkshop_s3	enablepayments	BOOLEAN
Bi_DimWorkshop_s3	classtype	INT
Bi_DimWorkshop_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimWorkshop_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimWorkshop_s3	WorkshopVoid	BOOLEAN
Bi_DimWorkshop_s3	PodName	VARCHAR(20)
Bi_DimWorkshopSession_s3	trackeventpk	DECIMAL(19,0)	PK
Bi_DimWorkshopSession_s3	TrackFK	DECIMAL(19,0)
Bi_DimWorkshopSession_s3	SessionFK	DECIMAL(19,0)
Bi_DimWorkshopSession_s3	OrganizationId	VARCHAR(36)
Bi_DimWorkshopSession_s3	TrackClassFK	DECIMAL(19,0)
Bi_DimWorkshopSession_s3	WorkshopName	NVARCHAR(512)
Bi_DimWorkshopSession_s3	void	BOOLEAN
Bi_DimWorkshopSession_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimWorkshopSession_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimWorkshopSession_s3	PodName	VARCHAR(20)
Bi_DimWorkTasks_s3	WorkTaskPK	DECIMAL(19,0)	PK
Bi_DimWorkTasks_s3	WorkTaskId	VARCHAR(36)
Bi_DimWorkTasks_s3	WorkTaskCode	NVARCHAR(512)
Bi_DimWorkTasks_s3	WorkTaskName	NVARCHAR(1024)
Bi_DimWorkTasks_s3	Description	NVARCHAR(4096)
Bi_DimWorkTasks_s3	OrganizationId	VARCHAR(36)
Bi_DimWorkTasks_s3	CreatedDate	TIMESTAMP
Bi_DimWorkTasks_s3	LastUpdated	TIMESTAMP
Bi_DimWorkTasks_s3	CreatedBy	VARCHAR(36)
Bi_DimWorkTasks_s3	LastUpdatedBy	VARCHAR(36)
Bi_DimWorkTasks_s3	Active	BOOLEAN
Bi_DimWorkTasks_s3	Void	BOOLEAN
Bi_DimWorkTasks_s3	EtlLastUpdatedOn	TIMESTAMP
Bi_DimWorkTasks_s3	EtlLastUpdatedBy	NVARCHAR(50)
Bi_DimWorkTasks_s3	PodName	VARCHAR(20)

In this section:

Data share through S3 dimension tables

Search results