dim_contract_cancellation_reason

-1 rows


Description

A set of basic properties of the cancellation such as origin, if the cancellation was extraordinary and the reason for the cancellation.

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.
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.
name varchar 256 null

The name of the reason.
type varchar 256 null

The type of the reason.
default_value varchar 256 null

Default value for the reason.
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