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 erp_v2_dim_contract_cancellation_reason_cancellation_reason_id__erp_v2_dim_cancellation_reason_cancellation_re_644d1c4c8bb7 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
is_archived bool 1 √ null

Indicates whether this cancellation reason has been archived.
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags shortly behind source system).
data_landing_time timestamptz 35 getdate()

Relationships

Close relationships within degrees of separation