dim_contract_property

Columns

Related columns Constraint Comments

Search:

Column Type Size Nulls Auto Default Children Parents Comments

contract_property_id

int8

null

fct_contract.contract_property_id

fct_contract_contract_property_id_fkey

The primary key of this table.

contract_status

varchar

256

null

CANCELLED if the contract is cancelled, else ACTIVE. It doesn’t matter if the contract’s end date is in the future or in the past. It’s only relevant if the contract was cancelled or not.

signature_status

varchar

256

null

Whether or not contract was signed, is still in process, or unknown.

payment_choice

varchar

256

null

The payment choice that customer was using for the contract.

sales_source

varchar

256

null

Through which service the contract was created.
- WEBCLIENT: Contract created on System Website by employee.
- CONNECT_API: Contract created via public API (eg tenant website)
- SALES_TOOL: Contract created via “Sales Tool” a special part of the Website optimized for tablets to easily create contracts together with the (to-be) member.
- MYSPORTS: Contract created via Mysports/Branded App or mysports.com.
- TOUCHPOINT: Contract created via Touchpoint, a self service solution enabling members to book additional modules via touch screen in the studio.
- ONLINE_CHECKOUT_PAGE: Contract created via Studio Pages feature (See Settings > Websites > Studio pages)
- LANDING_PAGE: Contract created via Landing Page feature (See Settings > Websites > Landing pages)

preuse_type

varchar

256

null

If a customer is able to visit the studio before their contract has started:
- NONE: customer is not allowed to checkin before start_date.
- FREE: customer is allowed to checkin before start_date but not before start_date_of_use (the pre usage is free).
- CHARGEABLE: customer is allowed to checkin before start_date but not before start_date_of_use (customer has to pay for the pre usage).

disabled

bool

null

DEPRECATED, use fct_contract.is_reversed instead. Indicates if the contract has been reversed, effectively nullifying any associated payments and treating the contract as if it never existed in the originating system.

company_contract

bool

null

Whether or not the contract is subsidized by the company the customer is employed at.

last_updated

timestamptz

√

null

System column. UTC Timestamp at which entry was calculated (lags behind source system).

Showing 1 to 9 of 9 entries

Relationships

Close relationships within degrees of separation

One
Two degrees

Description

Columns

Relationships

Close relationships within degrees of separation