int_sector_residual_decomposed

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

Part of the Residual family.

One row per lap per sector (3 rows/lap). Breaks down lap-level physics components (fuel, compound, 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. Note: rubber and ambient components are now part of base_track_pace and are not allocated separately (removed per WI-01).

​

Lineage

​

Overview

Property	Value
Layer	intermediate
Family	Residual
Contract enforced	No
Tags	feature_engineering
Upstream	stg_sector_times, stg_laps, stg_lap_tyre_qa, int_lap_residual_decomposed, int_lap_air_state

10 tests guard this model - 8 generic, 2 singular.

​

Columns

Column	Type	Nullable	Tests	Description
sector_id		Yes	not_null, unique	PK = lap_id || ‘_S’ || sector. Matches stg_sector_times convention.
lap_id		Yes	not_null	FK to stg_laps
sector		Yes	not_null, accepted_values	Sector number (1, 2, or 3)
sector_time_s		Yes	not_null	Raw sector time in seconds
sector_pace_delta_s		Yes	not_null	sector_time_s minus rolling ±3 lap field sector median
sector_driver_skill_residual_s		Yes		Closure residual after all 4 allocated components (fuel, compound, constructor, dirty_air)
sector_total_explained_s		Yes		Sum of the 4 allocated components (fuel, compound, constructor, dirty_air)
dominant_component_class		Yes	accepted_values	Component with the largest absolute value among the 4 allocated components. Values: fuel, compound, constructor, dirty_air; NULL when any of the four components is NULL (e.g. compound_component_s on unknown-age laps).