dim_contract_cancellation_reason


Description

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.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
contract_cancellation_reason_id int8 19 null
fct_contract.contract_cancellation_reason_id fct_contract_contract_cancellation_reason_id_fkey R

The primary key of this table.

cancellation_reason_id int8 19 null
dim_cancellation_reason.cancellation_reason_id dim_contract_cancellation_reason_cancellation_reason_id_fkey R

The cancellation reason to link to a localized contract_cancellation_reason_localized entry.

origin varchar 256 null

How the contract cancellation was initiated. Possible values:

  • CONTRACT_SWITCH (automated or manual switch to new contract),
  • CUSTOMER (customer initiated via self-service or staff request),
  • STUDIO (staff initiated via backoffice),
  • DUNNING (automated due to non-payment),
  • IMPORT (migrated from legacy systems).
extraordinary bool 1 null

If the contract was canceled before or after terms end date due to a particular reasons.

name varchar 256 null

The human-readable cancellation reason text in the language of the studio where it was first created.

type varchar 256 null

Categorization of the cancellation reason. Possible values: * CONTRACT_SWITCH (membership continues with new contract), * CUSTOM (contract cancelled with custom reason), * REST_MATURITY (immediate payment of all outstanding fees due upon cancellation).

default_value varchar 256 null

System-readable value for pre-generated cancellation reasons displayed as system reasons in the source system.

last_updated timestamptz 35 null

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

Relationships