fct_contract

-1 rows


Description

Stores all the contracts of all the customers.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
contract_id int8 19 null
fct_contract_price_history.contract_id fct_contract_price_history_contract_id_fkey R
fct_idle_period.contract_id fct_idle_period_contract_id_fkey R
fct_revenue.contract_id fct_revenue_contract_id_fkey R

The primary key of this table. System column calculated by the source System.
imported_contract_number varchar 256 √ null

The contract number as it was set in a previous system the contract was imported from. Only set if it was specifically required in the import-process.
cancellation_fee numeric 23,6 √ null

Amount of fee that a customer must pay for the cancellation. Is Null for contracts which are not cancelled.
created_date_id int4 10 null
dim_date.date_id fct_contract_created_date_id_fkey R

Date when the contract was added to the Systems database. Contracts might be imported into the System after the actual sign/conclusion date. There is no information when a contract was actually signed/concluded because it’s not provided on the migration stage to the System.
start_date_id int4 10 null
dim_date.date_id fct_contract_start_date_id_fkey R

Date when the contract starts.
start_date_of_use_id int4 10 null
dim_date.date_id fct_contract_start_date_of_use_id_fkey R

Date when the customer can already visit the facility. If the customer is allowed to use the gym before the actual contract starts this column contains a date which is before the start_date_id of the contract. Otherwise this column is equal to start_date_id.
end_date_id int4 10 null
dim_date.date_id fct_contract_end_date_id_fkey R

Date when the contract ends.
cancellation_date_id int4 10 √ null
dim_date.date_id fct_contract_cancellation_date_id_fkey R

Date when a contracts cancellation comes into effect, ending the contract. Is Null for contracts which are not cancelled.
cancellation_receipt_date_id int8 19 √ null
dim_date.date_id fct_contract_cancellation_receipt_date_id_fkey R

The date when the receipt of cancellation was provided. Is Null for contracts which are not cancelled.
pre_cancellation_end_date_id int8 19 √ null
dim_date.date_id fct_contract_pre_cancellation_end_date_id_fkey R

The contract end date before cancellation. Is Null for contracts which are not cancelled.
rate_id int8 19 null
dim_rate.rate_id fct_contract_rate_id_fkey R

The tariff of the contract generating an income.
organization_unit_id int8 19 null
dim_organization_unit.organization_unit_id fct_contract_organization_unit_id_fkey R

The gym (organization_unit) to which the customer and therefore the contract belongs.
employee_id int8 19 √ null
dim_employee.employee_id fct_contract_employee_id_fkey R

The employee responsible for making the customer sign the contract. Is Null in case there was no such employee.
customer_id int8 19 √ null
dim_customer.customer_id fct_contract_customer_id_fkey R

The person who the contract belongs to. Is set to Null when privacy settings come into effect.
contract_property_id int8 19 null
dim_contract_property.contract_property_id fct_contract_contract_property_id_fkey R

ID of the contract property, e.g signature_status, disabled, etc.
contract_term_id int8 19 null
dim_contract_term.contract_term_id fct_contract_contract_term_id_fkey R

ID of the contract term.
contract_cancellation_reason_id int8 19 √ null
dim_contract_cancellation_reason.contract_cancellation_reason_id fct_contract_contract_cancellation_reason_id_fkey R

The reason why the contract was cancelled. Is Null for contracts which are not cancelled.
company_id int8 19 √ null
dim_company.company_id fct_contract_company_id_fkey R

The partner company (Corporate Fitness) assigned to this contract.
contract_payment_frequency_id int8 19 √ null
dim_contract_payment_frequency.contract_payment_frequency_id fct_contract_contract_payment_frequency_id_fkey R

The setting of how often and how much is paid for this contract.
original_monthly_price float8 17,17 null

The estimated price, amortized over the contracts (initial) term, that has to be paid for this contract each month. By the original contract settings, without taking adjustments or contract starts in between payment periods into account. See fct_revenue for more accurate data.
current_monthly_price float8 17,17 null

The estimated price, amortized over the contracts term, that has to be paid for this contract each month. Taking adjustments until the current date but not contract starts in between payment periods into account. See fct_revenue for more accurate data.
original_total_price float8 17,17 null

The estimated price, that has to be paid for this contracts (initial) term in total. By the original contract settings, without taking adjustments or contract starts in between payment periods into account. See fct_revenue for more accurate data.
last_updated timestamptz 35 √ null

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

Relationships

Close relationships within degrees of separation