Tables

DEPRECATED. Use fct_trainer_appointment instead. Stores all appointments for trainers

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

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

Additional dimensional information about an idle period. A junk dimension containing the properties that describe how an idle period was configured and what its effects are on the customer’s contract and gym access.

Irregular or recurring closure times for an organization unit (gym). Defines exceptions to the regular opening hours, including one-time closures and yearly recurring closures (holidays, maintenance, etc.). YEARLY entries are expanded into specific datetime ranges based on creation/archival dates.

Table contains all employees and their relevant information

A definition of a voucher that can be generated into voucher codes and applied to a contract to get a discount or credit. Vouchers can be used to grant discounts on contracts, waive fees, or provide credit.

This table records actual cash inflows related to revenue, providing a cash-basis accounting view. It captures when cash was physically received, including payment method details and electronic payment transaction information.

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

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

A timeframe in which a customer does not have to pay for their contract(s). Includes member idle periods, contract idle periods, trial periods, and bonus periods.

Date dimension covering years 1900-2099

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

The term of the contract.

Role based access control information showing which employee has access to which organization unit (studio) through which role. This table represents the access permissions configured in the ERP system.

Link organization unit (gym) to all its organization unit codes (tags).

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 table contains simple properties of class events. This is a junk dimension that stores distinct combinations of event status, source, and booked_for_free flag.

Lookup table for status values of trainer assignments to appointments

Dimension table containing customer codes (tags) used to categorize customers. Customer codes help organize and filter customers based on business-defined categories. Each customer code has a unique identifier and can be associated with multiple customers.

Configuration of contract terms, extensions, cancellations and idle periods for a rate. This table details the rules governing the lifecycle of a contract associated with a specific rate, including initial duration, renewal policies, cancellation notice periods, and allowances for pausing the contract (idle periods).

The localized version of a rate, defining translated information of a rate per locale. One rate can have multiple localized versions.

A voucher code that can be applied to a contract to get a discount or credit. Only includes vouchers that have been redeemed or withdrawn. Represents the actual usage of a voucher.

Campaign dimension

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

The localized version of a cancellation reason, defining translated information of a cancellation reason per locale. One cancellation reason can have multiple localized versions.

Tracks the history of customers’ associations with studios over time, including start and end dates of these relationships.

Contract cancellations with their reasons. Built from actual contract cancellations that occurred in the system. Includes information about how the cancellation was initiated, the type of cancellation, and the reason.

Company codes (tags) that can be assigned to companies for categorization and filtering purposes. Similar to customer codes but for partner companies.

DEPRECATED. Use dim_contract_cancellation_reason instead.

A set of basic properties of cancellation such as origin and if the cancellation was extraordinary. This is a junk dimension containing all distinct combinations of cancellation properties.

General opening hours for organization units (gyms). Defines the regular operating hours for each gym by day of week in a range.

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.

DEPRECATED. Use dim_contract_cancellation_reason instead.

A reason for contract cancellation

Bridge table linking companies to their assigned company codes (tags). A company can have multiple codes and a code can be assigned to multiple companies.

Link customer to all his customer codes.

A tag/code assigned to organization units (gyms) to group them.

A period during which a discount is applied for a certain rate in the context of a contract voucher. This defines the discount structure (e.g., 100% off for the first 3 months).

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

Contract cancellation fact table

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

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.

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).

Custom field values assigned to customers on lead or member level.

Dimension table that tracks customer communication consent preferences across different message categories. This table combines customer-level and organization-level communication configurations, with customer-level settings taking priority over organization-level defaults.

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

The individual usage event of a service by a customer at a studio (organization_unit).

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.

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.

Bridge table linking companies to organization units (gyms) they are whitelisted for. Represents access permissions for gyms on companies.

Contract term dates fact table

Class appointment fact table

Stores all customer 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.