dim_contract_cancellation_property


Description

DEPRECATED. Use dim_contract_cancellation_reason instead.

A set of basic properties of cancellation such as origin and if the cancellation was extraordinary. This is a junk dimension containing all distinct combinations of cancellation properties.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
contract_cancellation_property_id varchar 256 null
fct_contract_cancellation.contract_cancellation_property_id Implied Constraint 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 particular reasons.
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()

System column. UTC timestamp assigned when a table batch is applied on Redshift. It represents warehouse landing order at table-batch granularity, not source event order. Usable to filter for incremental extractions.

Relationships

Close relationships within degrees of separation