dim_loss_reason


Description

The reasons available for explaining why a lead was lost.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
loss_reason_id int8 19 null
fct_lead_stage_history.loss_reason_id fct_lead_stage_history_loss_reason_id_fkey R

The primary key of the loss reason.

name varchar 65535 null

The name of the reason a lead was lost.

default_loss_reason varchar 65535 null

The system-defined default category for this loss reason, when available.

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