Adoption summary fact table
Bi_FactAdoptionSummary_s3
Field | Field type | Description | Primary Key | Mapped Dimension table | Mapped Dimension field |
FactAdoptionID | DECIMAL(19,0) | Unique identifier for the adoption summary record | PK | ||
RunDate | TIMESTAMP | Date and time the summary was generated | |||
RunId | VARCHAR(36) | Unique identifier for the ETL run | |||
AccountName | NVARCHAR(16000) | Name of the account | |||
OrganizationId | VARCHAR(36) | Unique identifier of the organization | |||
OrganizationName | NVARCHAR(16000) | Name of the organization | |||
CenterId | VARCHAR(36) | Unique identifier of the center | Bi_DimCenter | centerwid | |
CenterName | NVARCHAR(16000) | Name of the center | |||
CountryCode | NVARCHAR(16000) | Country code of the center | |||
Displayname | NVARCHAR(16000) | Display name for the center | |||
Product_Sales | INT | Count of product sales | |||
Membership_Sales | INT | Count of membership sales | |||
Package_Sales | INT | Count of package sales | |||
GiftCard_Sales | INT | Count of gift card sales | |||
RecurringMembership_Sales | INT | Count of recurring membership sales | |||
PriceAdjustment_Flag | BOOLEAN | Whether price adjustment is enabled | |||
PriceIncrease_Flag | BOOLEAN | Whether price increase is enabled | |||
InvoiceLock_Flag | BOOLEAN | Whether invoice lock is enabled | |||
DiscountAdjustment_Flag | BOOLEAN | Whether discount adjustment is enabled | |||
AuthenticationNeedforDiscount_Flag | BOOLEAN | Whether authentication is required for discounts | |||
RestrictTxnsIfRegisterNotClosed_Flag | BOOLEAN | Whether transactions are restricted if register is not closed | |||
Otp_Flag | BOOLEAN | Whether OTP verification is enabled | |||
NoOfPackagesAssociated | INT | Number of packages associated | |||
NoOfMembershipsAssociated | INT | Number of memberships associated | |||
Biometric_Flag | BOOLEAN | Whether biometric authentication is enabled | |||
NoOfServicesAssociated | INT | Number of services associated | |||
NoOfServicesBooked | INT | Number of services booked | |||
NoOfServicesBooked_Webstore | INT | Number of services booked via webstore | |||
NoOfServicesBooked_CMA | INT | Number of services booked via CMA | |||
NoOfNonServices_Sold | INT | Number of non-service items sold | |||
NoOfNonServices_Webstore | INT | Number of non-service items sold via webstore | |||
NoOfNonServices_CMA | INT | Number of non-service items sold via CMA | |||
NoOfTransactionalSMS_ApptCreate | INT | Transactional SMS sent for appointment creation | |||
NoOfTransactionalSMS_ApptRem | INT | Transactional SMS sent for appointment reminders | |||
NoOfTransactionalSMS_ThankYou | INT | Transactional SMS sent for thank you messages | |||
NoOfTransactionalSMS_Others | INT | Transactional SMS sent for other purposes | |||
NoOfTransactionalEmail_ApptCreate | INT | Transactional emails sent for appointment creation | |||
NoOfTransactionalEmail_ApptRem | INT | Transactional emails sent for appointment reminders | |||
NoOfTransactionalEmail_ThankYou | INT | Transactional emails sent for thank you messages | |||
NoOfTransactionalEmail_Others | INT | Transactional emails sent for other purposes | |||
NoOfCampaigns | INT | Total number of campaigns | |||
NoOfCampaignsAlwaysOnActive | INT | Number of always-on active campaigns | |||
AppConfirmationTempEnabled_SMS_Flag | INT | Whether appointment confirmation SMS template is enabled | |||
AppReminderTempEnabled_SMS_Flag | INT | Whether appointment reminder SMS template is enabled | |||
MembershipBalanceTempEnabled_SMS_Flag | INT | Whether membership balance SMS template is enabled | |||
ThankYouTempEnabled_SMS_Flag | INT | Whether thank you SMS template is enabled | |||
PaymentMadeTempEnabled_SMS_Flag | INT | Whether payment made SMS template is enabled | |||
AppConfirmationTempEnabled_Email_Flag | INT | Whether appointment confirmation email template is enabled | |||
AppReminderTempEnabled_Email_Flag | INT | Whether appointment reminder email template is enabled | |||
MembershipBalanceTempEnabled_Email_Flag | INT | Whether membership balance email template is enabled | |||
ThankYouTempEnabled_Email_Flag | INT | Whether thank you email template is enabled | |||
PaymentMadeTempEnabled_Email_Flag | INT | Whether payment made email template is enabled | |||
RetailPOsDelivered | INT | Number of retail purchase orders delivered | |||
ConsumablePOsDelivered | INT | Number of consumable purchase orders delivered | |||
NoOfEmailReceipts | INT | Number of email receipts sent | |||
EmailPackageExpiry_Flag | BOOLEAN | Whether email package expiry notification is enabled | |||
EmailMembershipExpiry_Flag | BOOLEAN | Whether email membership expiry notification is enabled | |||
NoOfDailyReportsToOwnerEmp_Email | INT | Number of daily report emails sent to owner/employees | |||
NoOfServicesBOMdefined | INT | Number of services with BOM (Bill of Materials) defined | |||
RetailReconcilationsSubmitted | INT | Number of retail reconciliations submitted | |||
ConsummableReconcilationsSubmitted | INT | Number of consumable reconciliations submitted | |||
FacebookIntegration_Flag | INT | Whether Facebook integration is enabled | |||
TwitterIntegration_Flag | INT | Whether Twitter integration is enabled | |||
SocialPosts_Flag | INT | Whether social posts feature is enabled | |||
PaymentsEnabledWebstore | INT | Whether payments are enabled on webstore | |||
InvoicesDeletedInADay | INT | Number of invoices deleted in a day | |||
ProductConsQty_Negative | INT | Count of products with negative consumable quantity | |||
ProductRetailQty_Negative | INT | Count of products with negative retail quantity | |||
ProductOrderLevelAlert | INT | Count of products at order-level alert threshold | |||
AppointmentsMissingProductConsumption | INT | Count of appointments missing product consumption | |||
TallyEnabledAtORG | BOOLEAN | Whether Tally is enabled at organization level | |||
TallyEnabledAtCenter | INT | Whether Tally is enabled at center level | |||
EnableNavisionAtORG | BOOLEAN | Whether Navision is enabled at organization level | |||
QuickbooksEnabled_Flag | INT | Whether QuickBooks integration is enabled | |||
QuickbooksEnabledat | NVARCHAR(16000) | Level at which QuickBooks is enabled | |||
Xerosenabled_Flag | INT | Whether Xero integration is enabled | |||
XeroenabledAt | NVARCHAR(16000) | Level at which Xero is enabled | |||
GuestCategoriesenabled | INT | Whether guest categories are enabled | |||
LPProgramenabled | INT | Whether loyalty points program is enabled | |||
NoOfFeedbacks_Created | INT | Number of feedbacks created | |||
NoOfIssuesCreated | INT | Number of issues created | |||
NoOfPayrollsRun | INT | Number of payrolls run | |||
NoOfPOs_RetailProducts | INT | Number of purchase orders for retail products | |||
NoOfOpportunities_Created | INT | Number of opportunities created | |||
NoOfOpportunities_Updated | INT | Number of opportunities updated | |||
NoOfPOs_ConsumableProducts | INT | Number of purchase orders for consumable products | |||
NoOfEmployeesScheduled | INT | Number of employees scheduled | |||
NoOfCheckInCheckOuts | INT | Number of check-in and check-out events | |||
NoPettyCashTransactions | INT | Number of petty cash transactions | |||
NoOfZenotiPayments | INT | Number of Zenoti payments processed | |||
NoOfEmailCampaigns | INT | Number of email campaigns | |||
InvoiceTotal | INT | Total invoice amount | |||
NoOfFormsFilled | INT | Number of forms filled | |||
NoOfPerformanceTargets | INT | Number of performance targets | |||
NoOfAudit_Consummable | INT | Number of consumable audits | |||
NoOfAudit_Retail | INT | Number of retail audits | |||
NoOfApptsClosedOneHourAfterBookingTime | INT | Appointments closed one hour after booking time | |||
NoOfApptsClosedOneHourAfterBookingTime_CampApied | INT | Appointments closed one hour after booking time with campaign applied | |||
NoOfTransactionalSMS | INT | Total transactional SMS sent | |||
NoOfTransactionalEmail | INT | Total transactional emails sent | |||
NoOfSMSCampaign | INT | Number of SMS campaigns | |||
NoOfFutureAppts | INT | Number of future appointments | |||
NoOfRegClosures | INT | Number of register closures | |||
NoOfTargetSegments | INT | Number of target segments | |||
Void | BOOLEAN | Indicates if the record is voided | |||
PodName | VARCHAR(20) | Name of the data pod | |||
groupid | BIGINT | Internal to Zenoti. Used for data processing. |