Adoption summary fact table

Bi_FactAdoptionSummary_s3

Table	Field	Field type	Description	Primary key	MappedDimensionTable	DimensionTableField
Bi_FactAdoptionSummary_s3	FactAdoptionID	DECIMAL(19,0)	unique identifier for the row. Primary key	PK
Bi_FactAdoptionSummary_s3	RunDate	TIMESTAMP
Bi_FactAdoptionSummary_s3	RunId	VARCHAR(36)
Bi_FactAdoptionSummary_s3	AccountName	NVARCHAR(16000)	organization account name		Bi_DimCenter_s3	orgAccountName
Bi_FactAdoptionSummary_s3	OrganizationId	VARCHAR(36)	Unique identifier for the organization		Bi_DimCenter_s3	organizationID
Bi_FactAdoptionSummary_s3	OrganizationName	NVARCHAR(16000)	Organization name		Bi_DimCenter_s3	OrganizationName
Bi_FactAdoptionSummary_s3	CenterId	VARCHAR(36)	Unique identifier for the center		Bi_DimCenter_s3	centerid
Bi_FactAdoptionSummary_s3	CenterName	NVARCHAR(16000)	Name of the center		Bi_DimCenter_s3	centerName
Bi_FactAdoptionSummary_s3	CountryCode	NVARCHAR(16000)	Country code for the country in which center is located		Bi_DimCenter_s3	cntrCountryCode
Bi_FactAdoptionSummary_s3	Displayname	NVARCHAR(16000)	Name of the country
Bi_FactAdoptionSummary_s3	Product_Sales	INT	Value of products sold
Bi_FactAdoptionSummary_s3	Membership_Sales	INT	Value of memberships sold
Bi_FactAdoptionSummary_s3	Package_Sales	INT	Value of packages sold
Bi_FactAdoptionSummary_s3	GiftCard_Sales	INT	Value of giftcards sold
Bi_FactAdoptionSummary_s3	RecurringMembership_Sales	INT	Count of recurring membership sales
Bi_FactAdoptionSummary_s3	PriceAdjustment_Flag	BOOLEAN	center level setting(EnablePriceAdjustment)
Bi_FactAdoptionSummary_s3	PriceIncrease_Flag	BOOLEAN	center level setting(EnablePriceIncrease)
Bi_FactAdoptionSummary_s3	InvoiceLock_Flag	BOOLEAN	center level setting(InvoiceLock)
Bi_FactAdoptionSummary_s3	DiscountAdjustment_Flag	BOOLEAN	center level setting(EnableDiscountAdjustment)
Bi_FactAdoptionSummary_s3	AuthenticationNeedforDiscount_Flag	BOOLEAN	center level setting(IsAuthenticationNeedforDiscount)
Bi_FactAdoptionSummary_s3	RestrictTxnsIfRegisterNotClosed_Flag	BOOLEAN	center level setting(RestrictTxnsIfRegisterNotClosed)
Bi_FactAdoptionSummary_s3	Otp_Flag	BOOLEAN	center level setting(EnableOtp)
Bi_FactAdoptionSummary_s3	NoOfPackagesAssociated	INT	Number of active packages associated for a center
Bi_FactAdoptionSummary_s3	NoOfMembershipsAssociated	INT	Number of active memberships associated for a center
Bi_FactAdoptionSummary_s3	Biometric_Flag	BOOLEAN	center level setting(BiometricFlag)
Bi_FactAdoptionSummary_s3	NoOfServicesAssociated	INT	Number of active services associated for a center
Bi_FactAdoptionSummary_s3	NoOfServicesBooked	INT	Number of services created in the last 30 days with appointment status as open and confirmend
Bi_FactAdoptionSummary_s3	NoOfServicesBooked_Webstore	INT	Number of services created through webstore in the last 30 days with appointment status as open and confirmend
Bi_FactAdoptionSummary_s3	NoOfServicesBooked_CMA	INT	Number of services created through CMA in the last 30 days with appointment status as open and confirmend
Bi_FactAdoptionSummary_s3	NoOfNonServices_Sold	INT	Number of invoice items created in the last 30 days which are closed and excluding services
Bi_FactAdoptionSummary_s3	NoOfNonServices_Webstore	INT	Number of invoice items created through webstore in the last 30 days which are closed and excluding services
Bi_FactAdoptionSummary_s3	NoOfNonServices_CMA	INT	Number of invoice items created through CMA in the last 30 days which are closed and excluding services
Bi_FactAdoptionSummary_s3	NoOfTransactionalSMS_ApptCreate	INT	Number of SMS for appointment creation
Bi_FactAdoptionSummary_s3	NoOfTransactionalSMS_ApptRem	INT	Number of SMS for appointment Reminder
Bi_FactAdoptionSummary_s3	NoOfTransactionalSMS_ThankYou	INT	Number of SMS sent after service is provided
Bi_FactAdoptionSummary_s3	NoOfTransactionalSMS_Others	INT
Bi_FactAdoptionSummary_s3	NoOfTransactionalEmail_ApptCreate	INT	Number of email for appointment creation
Bi_FactAdoptionSummary_s3	NoOfTransactionalEmail_ApptRem	INT	Number of email for appointment Reminder
Bi_FactAdoptionSummary_s3	NoOfTransactionalEmail_ThankYou	INT	Number of email sent after service is provided
Bi_FactAdoptionSummary_s3	NoOfTransactionalEmail_Others	INT
Bi_FactAdoptionSummary_s3	NoOfCampaigns	INT
Bi_FactAdoptionSummary_s3	NoOfCampaignsAlwaysOnActive	INT
Bi_FactAdoptionSummary_s3	AppConfirmationTempEnabled_SMS_Flag	INT
Bi_FactAdoptionSummary_s3	AppReminderTempEnabled_SMS_Flag	INT
Bi_FactAdoptionSummary_s3	MembershipBalanceTempEnabled_SMS_Flag	INT
Bi_FactAdoptionSummary_s3	ThankYouTempEnabled_SMS_Flag	INT
Bi_FactAdoptionSummary_s3	PaymentMadeTempEnabled_SMS_Flag	INT
Bi_FactAdoptionSummary_s3	AppConfirmationTempEnabled_Email_Flag	INT
Bi_FactAdoptionSummary_s3	AppReminderTempEnabled_Email_Flag	INT
Bi_FactAdoptionSummary_s3	MembershipBalanceTempEnabled_Email_Flag	INT
Bi_FactAdoptionSummary_s3	ThankYouTempEnabled_Email_Flag	INT
Bi_FactAdoptionSummary_s3	PaymentMadeTempEnabled_Email_Flag	INT
Bi_FactAdoptionSummary_s3	RetailPOsDelivered	INT
Bi_FactAdoptionSummary_s3	ConsumablePOsDelivered	INT
Bi_FactAdoptionSummary_s3	NoOfEmailReceipts	INT
Bi_FactAdoptionSummary_s3	EmailPackageExpiry_Flag	BOOLEAN
Bi_FactAdoptionSummary_s3	EmailMembershipExpiry_Flag	BOOLEAN
Bi_FactAdoptionSummary_s3	NoOfDailyReportsToOwnerEmp_Email	INT
Bi_FactAdoptionSummary_s3	NoOfServicesBOMdefined	INT
Bi_FactAdoptionSummary_s3	RetailReconcilationsSubmitted	INT
Bi_FactAdoptionSummary_s3	ConsummableReconcilationsSubmitted	INT
Bi_FactAdoptionSummary_s3	FacebookIntegration_Flag	INT
Bi_FactAdoptionSummary_s3	TwitterIntegration_Flag	INT
Bi_FactAdoptionSummary_s3	SocialPosts_Flag	INT
Bi_FactAdoptionSummary_s3	PaymentsEnabledWebstore	INT
Bi_FactAdoptionSummary_s3	InvoicesDeletedInADay	INT
Bi_FactAdoptionSummary_s3	ProductConsQty_Negative	INT
Bi_FactAdoptionSummary_s3	ProductRetailQty_Negative	INT
Bi_FactAdoptionSummary_s3	ProductOrderLevelAlert	INT
Bi_FactAdoptionSummary_s3	AppointmentsMissingProductConsumption	INT
Bi_FactAdoptionSummary_s3	TallyEnabledAtORG	BOOLEAN
Bi_FactAdoptionSummary_s3	TallyEnabledAtCenter	INT
Bi_FactAdoptionSummary_s3	EnableNavisionAtORG	BOOLEAN
Bi_FactAdoptionSummary_s3	QuickbooksEnabled_Flag	INT
Bi_FactAdoptionSummary_s3	QuickbooksEnabledat	NVARCHAR(16000)
Bi_FactAdoptionSummary_s3	Xerosenabled_Flag	INT
Bi_FactAdoptionSummary_s3	XeroenabledAt	NVARCHAR(16000)
Bi_FactAdoptionSummary_s3	GuestCategoriesenabled	INT
Bi_FactAdoptionSummary_s3	LPProgramenabled	INT
Bi_FactAdoptionSummary_s3	NoOfFeedbacks_Created	INT
Bi_FactAdoptionSummary_s3	NoOfIssuesCreated	INT
Bi_FactAdoptionSummary_s3	NoOfPayrollsRun	INT
Bi_FactAdoptionSummary_s3	NoOfPOs_RetailProducts	INT
Bi_FactAdoptionSummary_s3	NoOfOpportunities_Created	INT
Bi_FactAdoptionSummary_s3	NoOfOpportunities_Updated	INT
Bi_FactAdoptionSummary_s3	NoOfPOs_ConsumableProducts	INT
Bi_FactAdoptionSummary_s3	NoOfEmployeesScheduled	INT
Bi_FactAdoptionSummary_s3	NoOfCheckInCheckOuts	INT
Bi_FactAdoptionSummary_s3	NoPettyCashTransactions	INT
Bi_FactAdoptionSummary_s3	NoOfZenotiPayments	INT
Bi_FactAdoptionSummary_s3	NoOfEmailCampaigns	INT
Bi_FactAdoptionSummary_s3	InvoiceTotal	INT
Bi_FactAdoptionSummary_s3	NoOfFormsFilled	INT
Bi_FactAdoptionSummary_s3	NoOfPerformanceTargets	INT
Bi_FactAdoptionSummary_s3	NoOfAudit_Consummable	INT
Bi_FactAdoptionSummary_s3	NoOfAudit_Retail	INT
Bi_FactAdoptionSummary_s3	NoOfApptsClosedOneHourAfterBookingTime	INT
Bi_FactAdoptionSummary_s3	NoOfApptsClosedOneHourAfterBookingTime_CampApied	INT
Bi_FactAdoptionSummary_s3	NoOfTransactionalSMS	INT
Bi_FactAdoptionSummary_s3	NoOfTransactionalEmail	INT
Bi_FactAdoptionSummary_s3	NoOfSMSCampaign	INT
Bi_FactAdoptionSummary_s3	NoOfFutureAppts	INT
Bi_FactAdoptionSummary_s3	NoOfRegClosures	INT
Bi_FactAdoptionSummary_s3	NoOfTargetSegments	INT
Bi_FactAdoptionSummary_s3	Void	BOOLEAN
Bi_FactAdoptionSummary_s3	PodName	VARCHAR(20)
Bi_FactAdoptionSummary_s3	groupid	BIGINT	Internal to Zenoti. Used for data processing.

In this section:

Adoption summary fact table

Search results