---
title: Retire the seasonlog fantasy-points columns
type: task
status: draft
description: >-
  Replace the six player_fantasy_points*_from_seasonlogs data-view columns with the window-capable
  gamelog columns that reproduce them, migrating saved views and short URLs, so one fact has one
  spelling.
base_uri: user:task/league/data-views/retire-seasonlog-fantasy-columns.md
created_at: '2026-10-15T16:37:42.402Z'
entity_id: f9dac7ec-0237-480c-aeac-b31780220285
observations:
  - ████████████████████████████████████████████████
owner_identity_uri: █████████████████████████
priority: Low
public_read: true
relations:
  - relates [[█████████████████████-█████████████-██████████-███████-██-████-████-████████]]
tags:
  - user:tag/league-xo-football.md
  - user:tag/software-task.md
updated_at: '2026-10-28T02:11:02.848Z'
visibility_analyzed_at: '2026-11-05T23:49:00.731Z'
---

# Retire the seasonlog fantasy-points columns

## Why

`player_fantasy_points_from_gamelogs` and `player_fantasy_points_position_rank_from_gamelogs` read the same scored gamelogs the season table is generated from, at any window. Window-free, they reproduce `scoring_format_player_seasonlogs` to its 0.1 rounding (4,378 of 4,518 RB seasons 2002-2025 identical, 58 off by the rounding, 82 rank ties one place apart). The six `player_fantasy_points*_from_seasonlogs` columns are then a second spelling of one fact.

## Scope

- Measure which saved views, short URLs and default views carry the six columns (`check-saved-view-param-coverage.mjs --column-ids`, the `urls` table).
- Decide each column's replacement: points and position rank map directly; overall rank, per-game and per-game ranks have no gamelog twin yet and either gain one or stay.
- A saved-view migration rule in `libs-shared/data-views-saved-view-migration.mjs` and a short-URL alias, then the definitions, fields and descriptions come out.
- Keep `scoring_format_player_seasonlogs` itself: league surfaces outside the data views read it.

## Open questions

- Whether the per-game columns need a gamelog games-played denominator first.