Adoption Summary Fact Table
ZTZenoti Docs Team Updated April 10, 2026 5 min readGuide
Stores daily adoption summary metrics per center, tracking feature usage, sales counts, integrations, and operational indicators.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| factadoptionwid | BIGINT IDENTITY | NOT NULL | Surrogate key for the adoption summary record. |
| factadoptionid | BIGINT | YES | Source system identifier for the adoption summary. |
| rundate | TIMESTAMP | YES | Date/time when the adoption summary was computed. |
| runid | VARCHAR(36) | YES | GUID identifying the specific adoption run. |
| accountname | VARCHAR(4000) | YES | Name of the account. |
| organizationname | VARCHAR(4000) | YES | Name of the organization. |
| centerwid | BIGINT | YES | Foreign key to the center dimension (Bi_DimCenter.centerwid). |
| centername | VARCHAR(4000) | YES | Name of the center. |
| countrycode | VARCHAR(4000) | YES | Country code for the center. |
| displayname | VARCHAR(4000) | YES | Display name of the center or organization. |
| product_sales | BIGINT | YES | Count of product sales. |
| membership_sales | BIGINT | YES | Count of membership sales. |
| package_sales | BIGINT | YES | Count of package sales. |
| giftcard_sales | BIGINT | YES | Count of gift card sales. |
| recurringmembership_sales | BIGINT | YES | Count of recurring membership sales. |
| priceadjustment_flag | BOOLEAN | YES | Whether price adjustment feature is enabled. |
| priceincrease_flag | BOOLEAN | YES | Whether price increase feature is enabled. |
| invoicelock_flag | BOOLEAN | YES | Whether invoice locking feature is enabled. |
| discountadjustment_flag | BOOLEAN | YES | Whether discount adjustment feature is enabled. |
| authenticationneedfordiscount_flag | BOOLEAN | YES | Whether authentication is required for discounts. |
| restricttxnsifregisternotclosed_flag | BOOLEAN | YES | Whether transactions are restricted if register is not closed. |
| otp_flag | BOOLEAN | YES | Whether OTP (one-time password) feature is enabled. |
| noofpackagesassociated | BIGINT | YES | Number of packages associated with the center. |
| noofmembershipsassociated | BIGINT | YES | Number of memberships associated with the center. |
| biometric_flag | BOOLEAN | YES | Whether biometric authentication is enabled. |
| noofservicesassociated | BIGINT | YES | Number of services associated with the center. |
| noofservicesbooked | BIGINT | YES | Total number of services booked. |
| noofservicesbooked_webstore | BIGINT | YES | Number of services booked via webstore. |
| noofservicesbooked_cma | BIGINT | YES | Number of services booked via CMA (Customer Mobile App) (client mobile app). |
| noofnonservices_sold | BIGINT | YES | Number of non-service items sold. |
| noofnonservices_webstore | BIGINT | YES | Number of non-service items sold via webstore. |
| noofnonservices_cma | BIGINT | YES | Number of non-service items sold via CMA. |
| nooftransactionalsms_apptcreate | BIGINT | YES | Count of transactional SMS for appointment creation. |
| nooftransactionalsms_apptrem | BIGINT | YES | Count of transactional SMS for appointment reminders. |
| nooftransactionalsms_thankyou | BIGINT | YES | Count of transactional SMS for thank-you messages. |
| nooftransactionalsms_others | BIGINT | YES | Count of other transactional SMS messages. |
| nooftransactionalemail_apptcreate | BIGINT | YES | Count of transactional emails for appointment creation. |
| nooftransactionalemail_apptrem | BIGINT | YES | Count of transactional emails for appointment reminders. |
| nooftransactionalemail_thankyou | BIGINT | YES | Count of transactional emails for thank-you messages. |
| nooftransactionalemail_others | BIGINT | YES | Count of other transactional emails. |
| noofcampaigns | BIGINT | YES | Number of campaigns created. |
| noofcampaignsalwaysonactive | BIGINT | YES | Number of always-on active campaigns. |
| appconfirmationtempenabled_sms_flag | BIGINT | YES | Whether appointment confirmation SMS template is enabled. |
| appremindertempenabled_sms_flag | BIGINT | YES | Whether appointment reminder SMS template is enabled. |
| membershipbalancetempenabled_sms_flag | BIGINT | YES | Whether membership balance SMS template is enabled. |
| thankyoutempenabled_sms_flag | BIGINT | YES | Whether thank-you SMS template is enabled. |
| paymentmadetempenabled_sms_flag | BIGINT | YES | Whether payment-made SMS template is enabled. |
| appconfirmationtempenabled_email_flag | BIGINT | YES | Whether appointment confirmation email template is enabled. |
| appremindertempenabled_email_flag | BIGINT | YES | Whether appointment reminder email template is enabled. |
| membershipbalancetempenabled_email_flag | BIGINT | YES | Whether membership balance email template is enabled. |
| thankyoutempenabled_email_flag | BIGINT | YES | Whether thank-you email template is enabled. |
| paymentmadetempenabled_email_flag | BIGINT | YES | Whether payment-made email template is enabled. |
| retailposdelivered | BIGINT | YES | Number of retail POS (Point of Sale) items delivered. |
| consumableposdelivered | BIGINT | YES | Number of consumable POS items delivered. |
| noofemailreceipts | BIGINT | YES | Number of email receipts sent. |
| emailpackageexpiry_flag | BOOLEAN | YES | Whether email package expiry notifications are enabled. |
| emailmembershipexpiry_flag | BOOLEAN | YES | Whether email membership expiry notifications are enabled. |
| noofdailyreportstoowneremp_email | BIGINT | YES | Number of daily report emails sent to owner/employee. |
| noofservicesbomdefined | BIGINT | YES | Number of services with Bill of Materials defined. |
| retailreconcilationssubmitted | BIGINT | YES | Number of retail reconciliations submitted. |
| consummablereconcilationssubmitted | BIGINT | YES | Number of consumable reconciliations submitted. |
| facebookintegration_flag | BIGINT | YES | Whether Facebook integration is enabled. |
| twitterintegration_flag | BIGINT | YES | Whether Twitter integration is enabled. |
| socialposts_flag | BIGINT | YES | Whether social posts feature is enabled. |
| paymentsenabledwebstore | BIGINT | YES | Whether payments are enabled on the webstore. |
| invoicesdeletedinaday | BIGINT | YES | Number of invoices deleted in a day. |
| productconsqty_negative | BIGINT | YES | Count of consumable products with negative quantity. |
| productretailqty_negative | BIGINT | YES | Count of retail products with negative quantity. |
| productorderlevelalert | BIGINT | YES | Count of product order level alerts triggered. |
| appointmentsmissingproductconsumption | BIGINT | YES | Number of appointments missing product consumption entries. |
| tallyenabledatorg | BOOLEAN | YES | Whether Tally integration is enabled at the organization level. |
| tallyenabledatcenter | BIGINT | YES | Count of centers with Tally integration enabled. |
| enablenavisionatorg | BOOLEAN | YES | Whether Navision integration is enabled at the organization level. |
| quickbooksenabled_flag | BIGINT | YES | Whether QuickBooks integration is enabled. |
| quickbooksenabledat | VARCHAR(4000) | YES | Location/level where QuickBooks is enabled. |
| xerosenabled_flag | BIGINT | YES | Whether Xero integration is enabled. |
| xeroenabledat | VARCHAR(4000) | YES | Location/level where Xero is enabled. |
| guestcategoriesenabled | BIGINT | YES | Whether guest categories feature is enabled. |
| lpprogramenabled | BIGINT | YES | Whether loyalty points program is enabled. |
| nooffeedbacks_created | BIGINT | YES | Number of feedback records created. |
| noofissuescreated | BIGINT | YES | Number of issues created. |
| noofpayrollsrun | BIGINT | YES | Number of payroll runs executed. |
| noofpos_retailproducts | BIGINT | YES | Number of retail products in POS. |
| noofopportunities_created | BIGINT | YES | Number of opportunities created. |
| noofopportunities_updated | BIGINT | YES | Number of opportunities updated. |
| noofpos_consumableproducts | BIGINT | YES | Number of consumable products in POS. |
| noofemployeesscheduled | BIGINT | YES | Number of employees with schedules. |
| noofcheckincheckouts | BIGINT | YES | Number of check-in/check-out events. |
| nopettycashtransactions | BIGINT | YES | Number of petty cash transactions. |
| noofzenotipayments | BIGINT | YES | Number of Zenoti payments. |
| noofemailcampaigns | BIGINT | YES | Number of email campaigns. |
| invoicetotal | BIGINT | YES | Total invoice amount. |
| noofformsfilled | BIGINT | YES | Number of forms filled. |
| noofperformancetargets | BIGINT | YES | Number of performance targets defined. |
| noofaudit_consummable | BIGINT | YES | Number of consumable audits performed. |
| noofaudit_retail | BIGINT | YES | Number of retail audits performed. |
| noofapptsclosedonehourafterbookingtime | BIGINT | YES | Number of appointments closed one hour after booking time. |
| noofapptsclosedonehourafterbookingtime_campapied | BIGINT | YES | Number of campaign-applied appointments closed one hour after booking time. |
| nooftransactionalsms | BIGINT | YES | Total number of transactional SMS sent. |
| nooftransactionalemail | BIGINT | YES | Total number of transactional emails sent. |
| noofsmscampaign | BIGINT | YES | Number of SMS campaigns. |
| nooffutureappts | BIGINT | YES | Number of future appointments. |
| noofregclosures | BIGINT | YES | Number of register closures. |
| nooftargetsegments | BIGINT | YES | Number of target segments defined. |
| void | BOOLEAN | YES | Soft-delete flag indicating the record is logically deleted. |
| podid | INTEGER | YES | Identifier for the pod (database partition). |
Note: All fact tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlCreatedDate) which are omitted from this reference for brevity.
Primary Key
factadoptionwid
Foreign Keys
| Column | References |
|---|---|
| centerwid | Bi_DimCenter.centerwid |
Enumerator Values
| Column | Values |
|---|---|
| priceadjustment_flag | FALSE = Disabled, TRUE = Enabled |
| priceincrease_flag | FALSE = Disabled, TRUE = Enabled |
| invoicelock_flag | FALSE = Disabled, TRUE = Enabled |
| discountadjustment_flag | FALSE = Disabled, TRUE = Enabled |
| authenticationneedfordiscount_flag | FALSE = Disabled, TRUE = Enabled |
| restricttxnsifregisternotclosed_flag | FALSE = Disabled, TRUE = Enabled |
| otp_flag | FALSE = Disabled, TRUE = Enabled |
| biometric_flag | FALSE = Disabled, TRUE = Enabled |
| emailpackageexpiry_flag | FALSE = Disabled, TRUE = Enabled |
| emailmembershipexpiry_flag | FALSE = Disabled, TRUE = Enabled |
| tallyenabledatorg | FALSE = Disabled, TRUE = Enabled |
| enablenavisionatorg | FALSE = Disabled, TRUE = Enabled |
| void | TRUE if the record is soft-deleted; FALSE otherwise. |
Was this article helpful?
Your feedback helps us improve our documentation.