> ## Documentation Index
> Fetch the complete documentation index at: https://offthepace.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# stg_session_status

> Session lifecycle events from FastF1 session.session_status (Inactive / Started / Aborted / Finished / Finalised).

<Note>Part of the [Staging](/transform/families/staging) family.</Note>

Session lifecycle events from FastF1 session.session\_status (Inactive / Started / Aborted / Finished / Finalised). 'Aborted' marks red-flag stoppages, surfaced as is\_red\_flag\_stop. One row per lifecycle event.

## Lineage

```mermaid theme={null}
flowchart LR
  stg_session_status
  style stg_session_status fill:#e40404,stroke:#e40404,color:#fff
```

## Overview

| Property          | Value                                  |
| ----------------- | -------------------------------------- |
| Layer             | `staging`                              |
| Family            | [Staging](/transform/families/staging) |
| Contract enforced | No                                     |

**3 tests** [guard](/transform/ci/overview) this model  -  3 generic, 0 singular.

## Columns

| Column              | Type      | Nullable | Tests                                  | Description                                                         |
| ------------------- | --------- | -------- | -------------------------------------- | ------------------------------------------------------------------- |
| `session_status_id` | `varchar` | Yes      | [`not_null`](/transform/ci/structural) | Surrogate key   \{race\_id}\_\{session\_time\_s}.                   |
| `race_year`         | `integer` | Yes      |                                        | Season year.                                                        |
| `race_id`           | `varchar` | Yes      | [`not_null`](/transform/ci/structural) | Numeric FastF1 event id cast to string; matches stg\_laps.race\_id. |
| `race_slug`         | `varchar` | Yes      |                                        | Human-readable event name.                                          |
| `session_time_s`    | `double`  | Yes      | [`not_null`](/transform/ci/structural) | Session clock (s) at the lifecycle event.                           |
| `status`            | `varchar` | Yes      |                                        | Raw FastF1 session status ('Started', 'Aborted', 'Finished', ...).  |
| `is_red_flag_stop`  | `boolean` | Yes      |                                        | TRUE when status is 'Aborted' (a red-flag stoppage).                |