Tables

DEPRECATED. Use fct_trainer_appointment instead.

Stores all appointments for trainers

A contingent how often a service can be used, that is included in a contract (rate) of a customer.

DEPRECATED. Use dim_contract_cancellation_reason instead.
A reason for contract cancellation

Link customer to all his customer codes.

This table contains all payment run bookings together with information about the payment run itself. A payment run is a scheduled event where a financial institution attempts to collect money from the customers. It consists of individual payment run bookings, those that are regular, those that failed and those that were already excluded before and therefore technically do not represent actually processed bookings

This table contains all times of a day from 00:00:00 to 23:59:59 with the granularity of one second.

A set of basic payment run booking properties

The event of a customer visiting a gym (organization_unit) owned by you.

Additional dimensional information about a fct_idle_period.

A ‘partner company’ that contracts can be related to for the Corporate Fitness program. Only includes companies that are currently whitelisted for the studios related to this DWH instance.

Table contains all employees and their relevant information

A contingent how often a service can be used, that is paid for (not included in a customers contract).

A hierarchical categorization of revenues into a broad main_group and a finer grained sub_group.

DEPRECATED. Use fct_contract instead.

The table tracks canceled contracts and specific reasons for its cancelation

A class that a customer can participate in, e.g. yoga, dance class, etc

A timeframe in which a customer doesnt have to pay for his contract(s).

All dates from 1900-01-01 to 2099-12-31 with some precalculated values for common operations.

Defines how often and how much is paid for an individual contract.

An article that is sold physically or virtually. It is either defined with multiple attributes beforehand or just with a name being specified ad hoc when a sale is made (further referenced as dynamic product).

Representation of the lead conversion process of every customer (PROSPECT/MEMBER/FORMER_MEMBER), by the start and end date of the conversion/loss. Sourced by both Lead Management section and a fallback logic (see lead_source).

An appointment (class, trial session or personal training) by the trainer(s) leading it. Note: There can be multiple trainers per appointment, leading to multiple entries of the same appointment_id.

The term of the contract.

A general service (a class, a personal training, the replacement of a member card…), that can be provided to a customer. The service could be included in the customers contract(s), with a limiting contingent (eg when its a Sauna subscription) or be booked individually (eg when its a class).

All available currencies

The contract between a customer and a gym (organization_unit). Includes different contract_types (CONTRACT, MODULE, FLAT_FEE see dim_rate.contract_type) and reversed contracts (see is_reversed).

A device connected to the system, which enables registering customers using certain areas (the whole gym, the gym sauna) or machines (eg a massage bed) of a gym.

The tables contains simple properties of the class events.

The message categories a customer gave consent to be messaged for, over the specified communication channels. Consent could be given directly on a specfic customer or as a default via the Studio Settings.

The new price and price change information whenever the price of a contract is adjusted. The current_price of a contract can be built with condition valid_from_date >= CURRENT_DATE < valid_to_date

A set of basic contract properties, e.g whether or not contract is signed, via which service it was created, is contract disabled, which payment type was used for the contract, etc.

A standard tariff a contract is created with.

Statuses of the employee for a specific appointment

The event of an accrued income (positive/negative) of contracts, sales and everything else. Nightly updated with entries of the past day. NOTE: multi-purpose vouchers (de: ‘Wertgutscheine’) are only considered once they are used or expired.

The unique event of an appointment on the calendar with its properties.

Each individual contract term of a customer.

A tag or ‘member code’ set on customers to organize them into groups.

All campaigns or ‘marketing initiatives designed to promote contract sales’, that are whitelisted for this DWH instance. A campaign can be associated to customers (fct_lead_lifetime), contracts and vouchers.

A gym. The physical location at which people go to work out. But also the abstract entity to which customers sign up to.

A set of basic properties of the cancellation such as origin, if the cancellation was extraordinary and the reason for the cancellation.

Stores all appointments for a particular class

DEPRECATED. Use dim_contract_cancellation_reason instead.
A set of basic properties of cancelation such as origin, if the cancelationwas extraordinary, etc

An appointment (class, trial session or personal training) by the customer(s) taking part in it. Note: There can be multiple customers per appointment, leading to multiple entries of the same appointment_id.

Stores all customers events for class appointments such as booking or cancellations

A customer is a person who signed up to a studio owned by you or your franchise.