Skip to main content

Fact and dimension tables (S3)

Below is the list of S3 fact and dimension tables:

Account name dimension table

Add on user membership dimension table

Adoption summary fact table

Adoption summary fact table

Agent dimension table

Appointment categories dimension table

Appointment fact table

Appointment redo fact table

Campaign centers dimension table (s3)

Campaign dimension table

Campaign discount fact table

Campaign summary fact table

Cash register dimension table

Cash register fact table

Cash register fact table v2

Center dimension table

Center holidays dimension table

Center royalty category dimension table

Center royalty settings dimension table

Center timing dimension table

Center working hours exceptions dimension table

Collections fact table

Commission deduction fact table

Custom forms dimension table

Custom macro data dimension table

Data share through S3 dimension tables

Date dimension table

Deleted appointment fact table

Discount dimension table

Donations dimension table

Donations fact table

Employee break category dimension table

Employee commission fact table

Employee declared tips fact table

Employee dimension table

Employee invoice items revenue fact table

Employee item level commissions fact table

Employee membership commissions fact table

Employee pay fact table

Employee role dimension table

Employee salary fact table

Employee schedule fact table

Employee schedule status dimension table

Employee tips and SSG details fact table

Employee work tasks for payroll fact table

Equipment dimension table

ETL Refresh Log dimension table

Fact changes dimension table

Feedback dimension table

Feedback v2 fact table

Forms fact table

Forms metadata dimension table

Gift card dimension table

Gift card user dimension table

Gift cards fact table

Guest checkin fact table

Guest coupon dimension table

Guest loyalty tier dimension table

Guest merge log fact table

Guest tier changes fact table

Inventory fact table

Invoice item fact table

Invoice item taxes fact table

Issue categories dimension table

Issue priority type dimension table

Issue source dimension table

Issue status type dimension table

Issue subcategories dimension table

Issue treatment dimension table

Issue type dimension table

Issues fact table

Item commission deductions fact table

Item dimension table

Item source dimension table

Item type dimension table

Loyalty point actions dimension table

Loyalty point programs dimension table

Loyalty points fact table

Membership dimension table

Membership dunning fact table

Membership fact table

Membership fee type details dimension table

Membership status fact table

Membership transfers fact table

Membership user dimension table

Membership user redemptions fact table

Multiple employee appointment fact table

Multiple employee commission fact table

Opportunity custom field value fact table

Opportunity source dimension table

Org custom fields dimension table

Org dispositions dimension table

Org LP Tier dimension table

Org payment option dimension table

Organization Royalty Category dimension table

Package benefits dimension table

Package center dimension table

Package dimension table

Package user dimension table

Package user redemptions fact table

Package value fact table

Petty cash details fact table

Product barcodes dimension table

Product batches dimension table

Product center dimension table

Product dimension table

Product vendors dimension table

Reasons dimension table

Recurrence details dimension table

Recurring membership status fact table

Recurring payment amount log fact table

Registration fact table

Resource dimension table

Resource service association dimension table

S3_Tips payout center settings dimension table

S3_Tips payout employee settings dimension table

S3_Tips payout fact table

Scheduled collections fact table

Service center dimension table

Service dimension table

Service segment dimension table

Session dimension table

Status dimension table

Tax group details dimension table

Training center dimension table

Training class dimension table

Turnaways fact table

User dimension table

User guest pass fact table

User notes dimension table

User update history dimension table

UTC to Center Time dimension table

Vendor dimension table

Work tasks dimension table

Workshop dimension table

Workshop session dimension table

In this section: