dim_contract_cancellation_property

-1 rows


Description

DEPRECATED. Use dim_contract_cancellation_reason instead.
A set of basic properties of cancelation such as origin, if the cancelationwas extraordinary, etc

Columns

Column Type Size Nulls Auto Default Children Parents Comments
contract_cancellation_property_id int8 19 null
fct_contract_cancellation.contract_cancellation_property_id fct_contract_cancellation_contract_cancellation_property_id_fkey R

The primary key of this table.
origin varchar 256 null

Who or what initiated contract cancellation
extraordinary bool 1 null

If the contract was canceled before or after terms end date due to a particular reasons
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