fct_contract_cancellation


Description

DEPRECATED. Use fct_contract instead. Records each contract cancellation event, capturing the cancellation reason, effective dates, associated fee, customer, organization unit, and tariff rate. Use this table to analyze cancellation patterns, churn drivers, and associated revenue impact.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
contract_cancellation_id int8 19 null

Primary key for contract cancellation
cancellation_reason_id int8 19 √ null
dim_cancellation_reason.cancellation_reason_id fct_contract_cancellation_cancellation_reason_id_fkey R

Foreign key to cancellation reason - the reason why the contract was canceled
organization_unit_id int8 19 √ null
dim_organization_unit.organization_unit_id fct_contract_cancellation_organization_unit_id_fkey R

Foreign key to the organization unit (gym) associated with the customer of the canceled contract
fee numeric 23,2 √ null

Amount of fee that a customer must pay for the cancellation
currency_id varchar 256 √ null
dim_currency.currency_id fct_contract_cancellation_currency_id_fkey R

Currency code in which the cancellation fee is denominated (e.g. EUR)
cancellation_receipt_date_id int4 10 √ null
dim_date.date_id fct_contract_cancellation_cancellation_receipt_date_id_fkey R

Foreign key to date dimension - the date when the receipt of cancellation was provided (YYYYMMDD format)
pre_cancellation_end_date_id int4 10 √ null
dim_date.date_id fct_contract_cancellation_pre_cancellation_end_date_id_fkey R

Foreign key to date dimension - the contract end date before cancellation (YYYYMMDD format)
cancellation_date_id int4 10 √ null
dim_date.date_id fct_contract_cancellation_cancellation_date_id_fkey R

Foreign key to date dimension - date when the contract cancellation comes into effect (YYYYMMDD format)
contract_end_date_id int4 10 √ null
dim_date.date_id fct_contract_cancellation_contract_end_date_id_fkey R

Foreign key to date dimension - the end date of the contract (YYYYMMDD format)
customer_id int8 19 √ null
dim_customer.customer_id fct_contract_cancellation_customer_id_fkey R

Foreign key to customer
contract_cancellation_property_id varchar 256 √ null
dim_contract_cancellation_property.contract_cancellation_property_id Implied Constraint R

Foreign key to contract cancellation property
rate_id int8 19 √ null
dim_rate.rate_id fct_contract_cancellation_rate_id_fkey R

The tariff of the contract generating an income
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