Adoption summary fact table (Redshift)

factadoptionwid

BIGINT IDENTITY

Surrogate key for the adoption summary record.

PK

factadoptionid

BIGINT

Source system identifier for the adoption summary.

rundate

TIMESTAMP

Date/time when the adoption summary was computed.

runid

VARCHAR(36)

GUID identifying the specific adoption run.

accountname

VARCHAR(4000)

Name of the account.

organizationid

VARCHAR(36)

GUID of the organization.

organizationname

VARCHAR(4000)

Name of the organization.

centerwid

BIGINT

Foreign key to the center dimension (Bi_DimCenter.centerwid).

Bi_DimCenter

centerwid

centername

VARCHAR(4000)

Name of the center.

countrycode

VARCHAR(4000)

Country code for the center.

displayname

VARCHAR(4000)

Display name of the center or organization.

product_sales

BIGINT

Count of product sales.

membership_sales

BIGINT

Count of membership sales.

package_sales

BIGINT

Count of package sales.

giftcard_sales

BIGINT

Count of gift card sales.

recurringmembership_sales

BIGINT

Count of recurring membership sales.

priceadjustment_flag

BOOLEAN

Whether price adjustment feature is enabled.

priceincrease_flag

BOOLEAN

Whether price increase feature is enabled.

invoicelock_flag

BOOLEAN

Whether invoice locking feature is enabled.

discountadjustment_flag

BOOLEAN

Whether discount adjustment feature 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 (one-time password) feature is enabled.

noofpackagesassociated

BIGINT

Number of packages associated with the center.

noofmembershipsassociated

BIGINT

Number of memberships associated with the center.

biometric_flag

BOOLEAN

Whether biometric authentication is enabled.

noofservicesassociated

BIGINT

Number of services associated with the center.

noofservicesbooked

BIGINT

Total number of services booked.

noofservicesbooked_webstore

BIGINT

Number of services booked via webstore.

noofservicesbooked_cma

BIGINT

Number of services booked via CMA (client mobile app).

noofnonservices_sold

BIGINT

Number of non-service items sold.

noofnonservices_webstore

BIGINT

Number of non-service items sold via webstore.

noofnonservices_cma

BIGINT

Number of non-service items sold via CMA.

nooftransactionalsms_apptcreate

BIGINT

Count of transactional SMS for appointment creation.

nooftransactionalsms_apptrem

BIGINT

Count of transactional SMS for appointment reminders.

nooftransactionalsms_thankyou

BIGINT

Count of transactional SMS for thank-you messages.

nooftransactionalsms_others

BIGINT

Count of other transactional SMS messages.

nooftransactionalemail_apptcreate

BIGINT

Count of transactional emails for appointment creation.

nooftransactionalemail_apptrem

BIGINT

Count of transactional emails for appointment reminders.

nooftransactionalemail_thankyou

BIGINT

Count of transactional emails for thank-you messages.

nooftransactionalemail_others

BIGINT

Count of other transactional emails.

noofcampaigns

BIGINT

Number of campaigns created.

noofcampaignsalwaysonactive

BIGINT

Number of always-on active campaigns.

appconfirmationtempenabled_sms_flag

BIGINT

Whether appointment confirmation SMS template is enabled.

appremindertempenabled_sms_flag

BIGINT

Whether appointment reminder SMS template is enabled.

membershipbalancetempenabled_sms_flag

BIGINT

Whether membership balance SMS template is enabled.

thankyoutempenabled_sms_flag

BIGINT

Whether thank-you SMS template is enabled.

paymentmadetempenabled_sms_flag

BIGINT

Whether payment-made SMS template is enabled.

appconfirmationtempenabled_email_flag

BIGINT

Whether appointment confirmation email template is enabled.

appremindertempenabled_email_flag

BIGINT

Whether appointment reminder email template is enabled.

membershipbalancetempenabled_email_flag

BIGINT

Whether membership balance email template is enabled.

thankyoutempenabled_email_flag

BIGINT

Whether thank-you email template is enabled.

paymentmadetempenabled_email_flag

BIGINT

Whether payment-made email template is enabled.

retailposdelivered

BIGINT

Number of retail POS items delivered.

consumableposdelivered

BIGINT

Number of consumable POS items delivered.

noofemailreceipts

BIGINT

Number of email receipts sent.

emailpackageexpiry_flag

BOOLEAN

Whether email package expiry notifications are enabled.

emailmembershipexpiry_flag

BOOLEAN

Whether email membership expiry notifications are enabled.

noofdailyreportstoowneremp_email

BIGINT

Number of daily report emails sent to owner/employee.

noofservicesbomdefined

BIGINT

Number of services with Bill of Materials defined.

retailreconcilationssubmitted

BIGINT

Number of retail reconciliations submitted.

consummablereconcilationssubmitted

BIGINT

Number of consumable reconciliations submitted.

facebookintegration_flag

BIGINT

Whether Facebook integration is enabled.

twitterintegration_flag

BIGINT

Whether Twitter integration is enabled.

socialposts_flag

BIGINT

Whether social posts feature is enabled.

paymentsenabledwebstore

BIGINT

Whether payments are enabled on the webstore.

invoicesdeletedinaday

BIGINT

Number of invoices deleted in a day.

productconsqty_negative

BIGINT

Count of consumable products with negative quantity.

productretailqty_negative

BIGINT

Count of retail products with negative quantity.

productorderlevelalert

BIGINT

Count of product order level alerts triggered.

appointmentsmissingproductconsumption

BIGINT

Number of appointments missing product consumption entries.

tallyenabledatorg

BOOLEAN

Whether Tally integration is enabled at the organization level.

tallyenabledatcenter

BIGINT

Count of centers with Tally integration enabled.

enablenavisionatorg

BOOLEAN

Whether Navision integration is enabled at the organization level.

quickbooksenabled_flag

BIGINT

Whether QuickBooks integration is enabled.

quickbooksenabledat

VARCHAR(4000)

Location/level where QuickBooks is enabled.

xerosenabled_flag

BIGINT

Whether Xero integration is enabled.

xeroenabledat

VARCHAR(4000)

Location/level where Xero is enabled.

guestcategoriesenabled

BIGINT

Whether guest categories feature is enabled.

lpprogramenabled

BIGINT

Whether loyalty points program is enabled.

nooffeedbacks_created

BIGINT

Number of feedback records created.

noofissuescreated

BIGINT

Number of issues created.

noofpayrollsrun

BIGINT

Number of payroll runs executed.

noofpos_retailproducts

BIGINT

Number of retail products in POS.

noofopportunities_created

BIGINT

Number of opportunities created.

noofopportunities_updated

BIGINT

Number of opportunities updated.

noofpos_consumableproducts

BIGINT

Number of consumable products in POS.

noofemployeesscheduled

BIGINT

Number of employees with schedules.

noofcheckincheckouts

BIGINT

Number of check-in/check-out events.

nopettycashtransactions

BIGINT

Number of petty cash transactions.

noofzenotipayments

BIGINT

Number of Zenoti payments.

noofemailcampaigns

BIGINT

Number of email campaigns.

invoicetotal

BIGINT

Total invoice amount.

noofformsfilled

BIGINT

Number of forms filled.

noofperformancetargets

BIGINT

Number of performance targets defined.

noofaudit_consummable

BIGINT

Number of consumable audits performed.

noofaudit_retail

BIGINT

Number of retail audits performed.

noofapptsclosedonehourafterbookingtime

BIGINT

Number of appointments closed one hour after booking time.

noofapptsclosedonehourafterbookingtime_campapied

BIGINT

Number of campaign-applied appointments closed one hour after booking time.

nooftransactionalsms

BIGINT

Total number of transactional SMS sent.

nooftransactionalemail

BIGINT

Total number of transactional emails sent.

noofsmscampaign

BIGINT

Number of SMS campaigns.

nooffutureappts

BIGINT

Number of future appointments.

noofregclosures

BIGINT

Number of register closures.

nooftargetsegments

BIGINT

Number of target segments defined.

void

BOOLEAN

Soft-delete flag indicating the record is logically deleted.

podid

INTEGER

Identifier for the pod (database partition).

etlCreatedDate

TIMESTAMP

Timestamp when the ETL process created this record (defaults to UTC sysdate).

groupid

BIGINT

Identifier for the organizational group.