dim_cancellation_reason


Description

DEPRECATED. Use dim_contract_cancellation_reason instead.
A reason for contract cancellation

Columns

Column Type Size Nulls Auto Default Children Parents Comments
cancellation_reason_id int8 19 null
dim_cancellation_reason_localized.cancellation_reason_id dim_cancellation_reason_localized_cancellation_reason_id_fkey R
dim_contract_cancellation_reason.cancellation_reason_id dim_contract_cancellation_reason_cancellation_reason_id_fkey R
fct_contract_cancellation.cancellation_reason_id fct_contract_cancellation_cancellation_reason_id_fkey R

The primary key of this table. System column calculated by the source System.
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