ZenotiHelp

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.