Skip to main content

Fact and dimension tables (Redshift)

Below is the list of Redshift fact and dimension tables:

Account name dimension table

Add on user membership dimension table

Agent dimension table

Appointment categories dimension table

Appointment fact table for Dedicated Redshift

Appointment redo fact table

Campaign centers dimension table (redshift)

Campaign dimension table

Campaign discounts fact table

Campaigns summary fact table columns

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

Custom forms dimension table

Custom macro data dimension table

Date dimension table

Declare tips fact table

Deleted appointments fact table

Discount dimension table

Donations dimension table

Employee attendance dimension table

Employee break category dimension table

Employee commission fact table

Employee deputation dimension table

Employee dimension table

Employee hourly pay fact table

Employee invoice item revenue fact table

Employee item level commissions fact table

Employee membership commissions fact table

Employee role dimension table

Employee salary fact table

Employee schedule fact table

Employee schedule status dimension table

Employee work tasks for payroll fact table

Equipment dimension table

ER Diagrams

ETL refresh log dimension table

Fact changes dimension table

Feedback dimension table

Feedback v2 fact table

Forms fact table

Forms metadata dimension table

Get Started

Gift card and prepaid card liability fact table

Gift card dimension table

Gift card user dimension table

Guest checkin fact table

Guest coupon dimension table

Guest dimension table

Guest loyalty tier dimension table

Guest merge log fact table

Guest tier changes fact table

Inventory fact table

Invoice donations fact table columns

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 sub categories dimension table

Issue treatment dimension table

Issue type dimension table

Issues fact table

Item commission deductions fact table

Item source dimension table

Item type dimension table

Items dimension table

Loyalty point actions dimension table

Loyalty point programs dimension table

Loyalty points liability data fact table

Membership dimension table

Membership dunning collections 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

Memberships fact table

Multiple employee appointment fact table

Multiple employee commission fact table

Opportunity custom field values fact table

Opportunity source dimension table

Org custom fields dimension table

Org dispositions dimension table

Org payment option dimension table

Organization loyalty points tier dimension table

Package benefits dimension table

Package center dimension table

Package dimension table

Package liability fact table

Package user dimension table

Package value fact table

Petty cash details fact table

Product barcodes dimension table

Product batches dimension table

Product categories dimension table

Product center dimension table

Product dimension table

Product vendors dimension table

Reasons dimension table

Record type dimension table

Recurrence details dimension table

Recurring membership status fact table

Recurring payment amount log fact table

Registrations data fact table

Resource dimension table

Resource service association dimension table

Scheduled collections fact table

Service categories dimension table

Service center dimension table

Service dimension table

Service segment dimension table

Session dimension table

Sold by employee tag dimension table

Status dimension table

Tax group details dimension table

Tips and SSG data fact table

Tips payout center settings dimension table

Tips payout employee settings dimension table

Tips payout fact table

Training center dimension table

Training class dimension table

Turnaways fact table

User dimension table

User guest pass fact table

User membership dimension 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: