dim_contract_property__old


Description

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.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
contract_property_id varchar 256 null

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 1 √ 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 1 √ null

Whether or not the contract is subsidized by the company the customer is employed at
last_updated timestamptz 35 √ null

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

Relationships

Close relationships within degrees of separation