Event clock active intervals

​

Locked target

​

How to read an interval

​

Event intervals

​

Offer, availability, and RoS intervals

​

Two meanings of active

​

Active Events by createdAt interval

• 131 are pre-mobile / mobile / gap (47 + 17 + 67). Almost no IANA (0 + 0 + 3).
• 19 are Flex Instant overlap (14 starts, 12 with IANA).
• 4 are web fake Z (2 starts, 0 IANA).
• 2 are after #1328 (1 start, both have IANA).

​

What this file can rewrite of the 156

​

Recommended fix

1. Same deploy: writers store a real Instant and a real IANA; readers format Instant → Event.timezone (Phase 2 + Phase 4/5 branch code); ship 20260817180000_event_clock_alignment and 20260819170000_event_schedule_item_formula_b as written. Schedule Formula B SQL covers hour 10–23, overnight inverted ends, and invalid Event IANA → org, but no schedule rows convert while convert_schedule_wall is empty — populate dump-proved ids before prod. Run the :5434 integration test before prod.
2. Transitional read for leftovers: real IANA → Instant; startTime = show_start_at → Instant even if the zone was just filled; null / 'UTC' and not quote-equal → still wall.
3. Zone ladder, display-active first. Fill a label, then formula B. Never use a CT prior as the convert zone. Order: real Event.timezone → Flex metadata.timezone (skip UTC) → Event / Venue lat/lng (skip 0,0) → sibling Event IANA → Venue.address.state → America/Chicago label only after venues agree. Then the 25+1 Flex-linked created before #1062 (query 11). Hours 0–9 stay Instant candidates.
4. The same file Instant-izes offer Formula B (56) + crew_offer_days overrides, and avail same-UTC-day hour 10–23 evening walls (row IANA, fake-Z updated_at band). Avail hour-0 and 5→4 are nulled with a required IANA. RoS has 0 clocks. See cohort-alignment leftovers.
5. Make Organization.timezone a real writer so new orgs stop landing in the leftover bucket.

​

Queries

​

Status rollup

SELECT
  e."eventStatus",
  COUNT(*) AS events,
  COUNT(*) FILTER (
    WHERE e."eventStatus" IN ('ACTIVE', 'UNARCHIVED')
      AND COALESCE(e."endDate", e."eventDate")::date >= DATE '2026-08-17'
  ) AS display_active_on_snapshot
FROM "Event" e
GROUP BY 1
ORDER BY events DESC;

​

Stored-active and display-active by interval

SELECT
  CASE
    WHEN e."createdAt" < TIMESTAMP '2026-04-14 00:00:00' THEN 'e_pre_mobile'
    WHEN e."createdAt" < TIMESTAMP '2026-05-06 14:53:38' THEN 'e_mobile_local_as_z'
    WHEN e."createdAt" < TIMESTAMP '2026-07-16 20:13:31' THEN 'e_gap_before_web_rfc'
    WHEN e."createdAt" < TIMESTAMP '2026-07-23 00:27:23' THEN 'e_web_z_pre_flex'
    WHEN e."createdAt" < TIMESTAMP '2026-08-16 20:08:29' THEN 'e_flex_instant_overlap'
    ELSE 'e_after_flex_wallclock'
  END AS interval,
  COUNT(*) AS stored_active,
  COUNT(*) FILTER (
    WHERE COALESCE(e."endDate", e."eventDate")::date >= DATE '2026-08-17'
  ) AS display_active,
  COUNT(*) FILTER (
    WHERE COALESCE(e."endDate", e."eventDate")::date < DATE '2026-08-17'
  ) AS stored_active_already_completed_in_list,
  COUNT(e."startTime") AS with_start,
  COUNT(*) FILTER (
    WHERE e.timezone IS NOT NULL AND e.timezone <> 'UTC'
  ) AS has_iana
FROM "Event" e
WHERE e."eventStatus" IN ('ACTIVE', 'UNARCHIVED')
GROUP BY 1
ORDER BY 1;

​

Related

• Event clock writeup (ENG-580)
• Event clock problem canvas
• Event clock cohort alignment
• Availability and engagement clock semantics
• Database
• ENG-580
• ENG-581