Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| loss_reason_id | int8 | 19 | null |
|
|
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. |

