PLUTO-137 Inactivity-warning baseline floor: don't count dormancy before 2026-06-09 clinical go-live

PLUTO-137 · pluto

Inactivity-warning baseline floor: don't count dormancy before 2026-06-09 clinical go-live

Ref: PLUTO-137 (#1108)
Project: pluto
Status: done
Priority: normal
Type: task
Assigned: db-pluto-cc db
Created by: wi-cli-venus
Blocked reason: Pending Elazar greenlight on bs-mqffo95d1vs suppress-and-reset direction. Scope: inactivity-warning eligibility query baseline floor — daysSince = now - GREATEST(lastLogin, goLiveConst 2026-06-09), so onboarding-era users aren't flagged. Separate from PLUTO-135 (cron archive-context fix) and from the immediate db emailedAt-stamp suppression of the 103. Small, coder-owned.
Created: 2026-06-15T16:38:26.608Z
Updated: 2026-06-16T02:10:34.590Z
Closed: 2026-06-16T02:10:34.590Z

No sub-items.

No questions.

2026-06-15T16:38:26.608Z · created · wi-cli-venus
2026-06-15T16:38:34.829Z · blocked · wi-cli-venus

Pending Elazar greenlight on bs-mqffo95d1vs suppress-and-reset direction. Scope: inactivity-warning eligibility query baseline floor — daysSince = now - GREATEST(lastLogin, goLiveConst 2026-06-09), so onboarding-era users aren't flagged. Separate from PLUTO-135 (cron archive-context fix) and from the immediate db emailedAt-stamp suppression of the 103. Small, coder-owned.
2026-06-16T02:05:47.083Z · assigned · wi-cli-venus

db-pluto-cc / db
2026-06-16T02:05:47.601Z · statusChanged · wi-cli-venus

Elazar greenlit 2026-06-16. fn_lifecycleInactivity baseline floor (GREATEST(lastLogin, 2026-06-09 go-live)). db owns (fn migration lane). Applied to prod + verified; migration 032 in audit pre-push review.
2026-06-16T02:10:34.590Z · completed · wi-cli-venus

Shipped 4feaaf8 / v1.73.0. fn_lifecycleInactivity now floors daysSince at GREATEST(lastLogin, 2026-06-09 go-live) so no user reads 'inactive' merely because the login system is young. Audit: pre-push diff APPROVE (archive-context + GREATEST-floor/null-lastLogin safe) + PTD PASS:4feaaf8 (READY/SHA/1.73.0/clean runtime) + live prod pg_get_functiondef BYTE-IDENTICAL to migration 032 (90/90 lines). Root fix for the 103-blast class (103 already suppressed via emailedAt stamp).