> ## 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.

# int_sector_residual_decomposed

> One row per lap per sector (3 rows/lap).

<Note>Part of the [Residual](/transform/families/residual) family.</Note>

One row per lap per sector (3 rows/lap). Breaks down lap-level physics components (fuel, compound, rubber, ambient, constructor, dirty\_air) to individual sectors proportional to sector time. Grain: (lap\_id, sector). Allows per-sector skill analysis. Matches stg\_sector\_times granularity. Identity: sector\_pace\_delta = sector\_components + sector\_skill\_residual.

## Lineage

```mermaid theme={null}
flowchart LR
  int_lap_air_state --> int_sector_residual_decomposed
  int_lap_residual_decomposed --> int_sector_residual_decomposed
  stg_laps --> int_sector_residual_decomposed
  stg_sector_times --> int_sector_residual_decomposed
  style int_sector_residual_decomposed fill:#e40404,stroke:#e40404,color:#fff
```

## Overview

| Property          | Value                                                                                                                                                                                    |
| ----------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Layer             | `intermediate`                                                                                                                                                                           |
| Family            | [Residual](/transform/families/residual)                                                                                                                                                 |
| Contract enforced | No                                                                                                                                                                                       |
| Tags              | `feature_engineering`                                                                                                                                                                    |
| Upstream          | [`stg_sector_times`](../stg/stg_sector_times), [`stg_laps`](../stg/stg_laps), [`int_lap_residual_decomposed`](./int_lap_residual_decomposed), [`int_lap_air_state`](./int_lap_air_state) |

**11 tests** [guard](/transform/ci/overview) this model  -  10 generic, 1 singular.

## Columns

| Column                           | Type | Nullable | Tests                                                                                       | Description                                                                                                                                  |
| -------------------------------- | ---- | -------- | ------------------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------- |
| `sector_id`                      |      | Yes      | [`not_null`](/transform/ci/structural), [`unique`](/transform/ci/structural)                | PK = lap\_id \|\| '\_S' \|\| sector. Matches stg\_sector\_times convention.                                                                  |
| `lap_id`                         |      | Yes      | [`not_null`](/transform/ci/structural)                                                      | FK to stg\_laps                                                                                                                              |
| `sector`                         |      | Yes      | [`not_null`](/transform/ci/structural), [`accepted_values`](/transform/ci/range-and-domain) | Sector number (1, 2, or 3)                                                                                                                   |
| `sector_time_s`                  |      | Yes      | [`not_null`](/transform/ci/structural)                                                      | Raw sector time in seconds                                                                                                                   |
| `sector_pace_delta_s`            |      | Yes      | [`not_null`](/transform/ci/structural)                                                      | sector\_time\_s minus rolling ±3 lap field sector median                                                                                     |
| `sector_driver_skill_residual_s` |      | Yes      | [`not_null`](/transform/ci/structural)                                                      | Closure residual after all 6 allocated components                                                                                            |
| `sector_total_explained_s`       |      | Yes      | [`not_null`](/transform/ci/structural)                                                      | Sum of the 6 allocated components                                                                                                            |
| `dominant_component_class`       |      | Yes      | [`accepted_values`](/transform/ci/range-and-domain)                                         | Component with the largest absolute value among the 6 allocated components. Values: fuel, compound, rubber, ambient, constructor, dirty\_air |