fct_contract_cancellation


Description

DEPRECATED. Use fct_contract instead.

The table tracks canceled contracts and specific reasons for its cancelation

Columns

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

The primary key of this table. System column calculated by the source System.
organization_unit_id int8 19 null
dim_organization_unit.organization_unit_id fct_contract_cancellation_organization_unit_id_fkey R

The home studio of the customer whose contract is canceled
customer_id int8 19 null
dim_customer.customer_id fct_contract_cancellation_customer_id_fkey R

The customer whose contract was canceled
cancellation_date_id int8 19 null
dim_date.date_id fct_contract_cancellation_cancellation_date_id_fkey R

Date when a contracts cancellation comes into effect, ending the contract.
cancellation_receipt_date_id int8 19 null
dim_date.date_id fct_contract_cancellation_cancellation_receipt_date_id_fkey R

The date when the receipt of cancellation was provided
pre_cancellation_end_date_id int8 19 null
dim_date.date_id fct_contract_cancellation_pre_cancellation_end_date_id_fkey R

The contract end date before cancellation
contract_end_date_id int8 19 null
dim_date.date_id fct_contract_cancellation_contract_end_date_id_fkey R

The end date of the contract
contract_cancellation_property_id int8 19 null
dim_contract_cancellation_property.contract_cancellation_property_id fct_contract_cancellation_contract_cancellation_property_id_fkey R

The property of the contract cancellation such as origin, if there were extraordinary conditions to cancel contract, etc
rate_id int8 19 null
dim_rate.rate_id fct_contract_cancellation_rate_id_fkey R

The tariff of the contract generating an income
cancellation_reason_id int8 19 null
dim_cancellation_reason.cancellation_reason_id fct_contract_cancellation_cancellation_reason_id_fkey R

The reason why the contract was canceled
fee numeric 19,2 null

Amount of fee that a customer must pay for the cancellation
currency_id int8 19 null
dim_currency.currency_id fct_contract_cancellation_currency_id_fkey R

The system of money in which income was generated.
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