Create
Query
event_store.db
—
events
actions
approvals
artifacts
commitments
constraints
conversation_state
conversation_turns
dead_letters
decisions
deliveries
effects
email_messages
email_reply_drafts
email_threads
entities
entity_aliases
entity_tags
episode_context_index
episodes
event_subjects
events
events_archive
fact_sources
facts
inbox_items
inbox_links
jobs
leader_leases
links
memory_candidates
memory_embeddings
memory_items
memory_items_fts
(v)
memory_items_fts_config
memory_items_fts_data
memory_items_fts_idx
opportunity_memory
pending_interactions
proposal_sources
proposals
reminders
schedules
schema_migrations
signal_candidates
signal_fps
signals
sms_conversations
sms_messages
sms_reply_drafts
source_cursors
sources
sqlite_sequence
sqlite_stat1
stream_cursors
threads
watchers
Toggle helper tables
memory_items_fts_content
memory_items_fts_docsize
memory_items_fts_segdir
memory_items_fts_segments
memory_items_fts_stat
Structure
Content
Query
Insert
Drop
Import
Export
Update row 16525 in events
seq
Primary key.
INTEGER
id
evt_ffe6c2a0ae26
TEXT NOT NULL
kind
planner_plan_built
TEXT NOT NULL
ts
2026-04-04T20:37:31.909820+00:00
TEXT NOT NULL
actor
planner
TEXT
subject_entity_ids
[]
TEXT
payload
{"day":"2026-04-04","plan":{"day":"2026-04-04","do_now":[{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"Delivery failure for critical itinerary communication","id":"sig:c4e740bcf8fff398","kind":"inbox","links":{"dedupe_key":"delivery_failure:2026-04-03:attn:C0A8Q869CNL:8c7139f:send_failed","evidence_event_ids":["evt_5f8b90887564"],"reason_trace":{},"severity":"high","signal_id":"sig_b39a9af62680","signal_type":"delivery_failure","source":"slack_outbox","topic_key":"signal:delivery_failure:b86a98cc60d392ad","triage":{"action_hints":["needs reply","schedule review"],"confidence":0.18,"disposition":"escalate","entity_ids":[],"headline":"Delivery failure for critical itinerary communication","prior":{"family":"high_consequence_signal","importance_band":"critical","suggested_disposition":"escalate","suggested_route":"review","suggested_urgency":"high"},"priority_score":174.74,"rationale":"This delivery failure affects the user's trip planning and requires immediate attention to ensure timely communication.","review_in_days":1,"route":"task","urgency":"high"},"user_visible":false},"next_touch_at_iso":"2026-04-03T20:40:00Z","route":"task","score":81.0,"score_hint":0.0,"source_kind":"signal","tags":["family:high_consequence_signal","priority:high","route:task","severity:high","signal","signal:delivery_failure","source:slack_outbox","triage:escalate","urgency:high"],"ts":"2026-04-03T20:37:22.554897+00:00","urgency":"high","user_visible":true,"waiting_on":null,"why_it_matters":"This delivery failure affects the user's trip planning and requires immediate attention to ensure timely communication."},{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"Delivery failure detected for critical message","id":"sig:df760c2dea93d3f5","kind":"inbox","links":{"dedupe_key":"delivery_failure:2026-04-03:attn:C0A8Q869CNL:93a0a9d:send_failed","evidence_event_ids":["evt_17ad88fd7712"],"reason_trace":{},"severity":"high","signal_id":"sig_dd772239aa4f","signal_type":"delivery_failure","source":"slack_outbox","topic_key":"signal:delivery_failure:a6244d941dea59b1","triage":{"action_hints":["needs reply"],"confidence":0.9,"disposition":"escalate","entity_ids":[],"headline":"Delivery failure detected for critical message","prior":{"family":"high_consequence_signal","importance_band":"critical","suggested_disposition":"escalate","suggested_route":"review","suggested_urgency":"high"},"priority_score":189.14,"rationale":"This delivery failure could impact the user's trip planning and requires immediate attention.","review_in_days":1,"route":"review","urgency":"high"},"user_visible":false},"next_touch_at_iso":"2026-04-03T20:45:00Z","route":"review","score":81.0,"score_hint":0.0,"source_kind":"signal","tags":["family:high_consequence_signal","priority:high","route:review","severity:high","signal","signal:delivery_failure","source:slack_outbox","triage:escalate","urgency:high"],"ts":"2026-04-03T20:30:35.356880+00:00","urgency":"high","user_visible":true,"waiting_on":null,"why_it_matters":"This delivery failure could impact the user's trip planning and requires immediate attention."},{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"What should the subject and body of the email be?","id":"pend_d733ac1aa3","kind":"followup","links":{"action_id":null,"action_type":null,"approval_id":null,"choices":[],"event_id":"evt_de327c9699d4","pending_kind":"missing_detail","source":"proposal_materializer","thread_id":"slkthr_776445451af92b39e8"},"next_touch_at_iso":null,"route":"today","score":55.0,"score_hint":6.0,"source_kind":"pending","tags":["missing_detail"],"ts":"2026-04-03T11:49:25.005404+00:00","urgency":"high","user_visible":true,"waiting_on":null,"why_it_matters":"The workflow cannot continue until the missing message details are provided."},{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"Low priority internal notification","id":"sig:8af2b7fac031ec35","kind":"inbox","links":{"dedupe_key":"triage_llm_error:2026-04-03","evidence_event_ids":["evt_83cf7e837633"],"reason_trace":{"batch":0,"stage":"llm.complete"},"severity":"high","signal_id":"sig_7732c4c57212","signal_type":"triage_llm_error","source":"inbox_triage","topic_key":"signal:triage_llm_error:98fc170e8df25b45","triage":{"action_hints":[],"confidence":0.5,"disposition":"promote","entity_ids":[],"headline":"Low priority internal notification","prior":{"family":"high_consequence_signal","importance_band":"critical","suggested_disposition":"escalate","suggested_route":"review","suggested_urgency":"high"},"priority_score":151.14,"rationale":"This notification does not require immediate action and is considered low value.","review_in_days":30,"route":"review","urgency":"high"},"user_visible":false},"next_touch_at_iso":null,"route":"review","score":41.0,"score_hint":0.0,"source_kind":"signal","tags":["family:high_consequence_signal","priority:high","route:review","severity:high","signal","signal:triage_llm_error","source:inbox_triage","triage:promote","urgency:high"],"ts":"2026-04-03T20:35:28.190731+00:00","urgency":"high","user_visible":true,"waiting_on":null,"why_it_matters":"This notification does not require immediate action and is considered low value."},{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"Strong evidence supports the current trend, with minimal contradictions.","id":"sig:517845e18c81a278","kind":"inbox","links":{"dedupe_key":"opportunity_case:case_466d5d6b987ca4bf:2026-04-04","evidence_event_ids":["evt_ff2c94007f96","evt_08a193b0faea","evt_66284ddb94a3","evt_47988436838f","evt_d77f3fe4840a","evt_3e0840984fc3","evt_a6d8db03fb29","evt_3be7a158b203","evt_bf07ef74283a","evt_9d0be270ba85","evt_bf4891d4e0d5","evt_7b8214726ed9","evt_9efcd6576c9b","evt_20115c1475f4","evt_31eb5ad9d5fc","evt_e1dc93ece7c5"],"reason_trace":{"_evidence_event_ids":["evt_08a193b0faea","evt_66284ddb94a3","evt_47988436838f","evt_d77f3fe4840a","evt_3e0840984fc3","evt_a6d8db03fb29","evt_3be7a158b203","evt_bf07ef74283a","evt_9d0be270ba85","evt_bf4891d4e0d5","evt_7b8214726ed9","evt_9efcd6576c9b","evt_20115c1475f4","evt_31eb5ad9d5fc","evt_e1dc93ece7c5"],"case_id":"case_466d5d6b987ca4bf","decision":"surface","entity_key":"equity:XLE","theme_key":"entity_development"},"severity":"medium","signal_id":"sig_999c227afa4f","signal_type":"opportunity_signal","source":"opportunity_finder","topic_key":"signal:opportunity_signal:d87666cf651bb21c","triage":{"action_hints":["schedule review"],"confidence":0.12,"disposition":"park","entity_ids":[],"headline":"Strong evidence supports the current trend, with minimal contradictions.","prior":{"family":"opportunity","importance_band":"meaningful","suggested_disposition":"promote","suggested_route":"review","suggested_urgency":"medium"},"priority_score":58.96,"rationale":"This opportunity signal may be relevant for future planning, especially regarding the trip itinerary.","review_in_days":3,"route":"review","urgency":"medium"},"user_visible":false},"next_touch_at_iso":null,"route":"review","score":33.0,"score_hint":0.0,"source_kind":"signal","tags":["family:opportunity","priority:medium","route:review","severity:medium","signal","signal:opportunity_signal","source:opportunity_finder","triage:park","urgency:medium"],"ts":"2026-04-04T05:00:58.305201+00:00","urgency":"medium","user_visible":true,"waiting_on":null,"why_it_matters":"This opportunity signal may be relevant for future planning, especially regarding the trip itinerary."}],"do_today":[{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"Renewable energy sector growth signal","id":"sig:8b99b98705f4a870","kind":"inbox","links":{"dedupe_key":"opportunity_case_memory:case_6640d79fb2f20e94:digest:2026-04-04T19","evidence_event_ids":["evt_b744b8aa725b","evt_2d87b7bc3b55","evt_62ed08300906","evt_8e1a474d9b47","evt_2d790fe361f0","evt_aa3cf4bb2bd0","evt_bbb7a9cd2ef6","evt_891a0f95f82f","evt_eb398727cbc0","evt_776d983e6f50","evt_577a43020852","evt_05fd48ae1bda","evt_2fe937f5c8bf","evt_7844aa678bdb","evt_e99e2cd9d15e"],"reason_trace":{"_evidence_event_ids":["evt_2d87b7bc3b55","evt_62ed08300906","evt_8e1a474d9b47","evt_2d790fe361f0","evt_aa3cf4bb2bd0","evt_bbb7a9cd2ef6","evt_891a0f95f82f","evt_eb398727cbc0","evt_776d983e6f50","evt_577a43020852","evt_05fd48ae1bda","evt_2fe937f5c8bf","evt_7844aa678bdb","evt_e99e2cd9d15e"],"case_id":"case_6640d79fb2f20e94","decision":"digest","entity_key":"equity:AA","memory_only":true,"theme_key":"entity_development"},"severity":"low","signal_id":"sig_3f3379d75752","signal_type":"opportunity_case_memory","source":"opportunity_finder","topic_key":"signal:opportunity_case_memory:66ce0a426f274dbc","triage":{"action_hints":["schedule review"],"confidence":0.5,"disposition":"park","entity_ids":[],"headline":"Renewable energy sector growth signal","prior":{"family":"general","importance_band":"background","suggested_disposition":"park","suggested_route":"review","suggested_urgency":"low"},"priority_score":20.0,"rationale":"This signal indicates potential growth in the renewable energy sector, which may be relevant for future planning.","review_in_days":7,"route":"review","urgency":"low"},"user_visible":false},"next_touch_at_iso":null,"route":"review","score":28.0,"score_hint":0.0,"source_kind":"signal","tags":["family:general","priority:low","route:review","severity:low","signal","signal:opportunity_case_memory","source:opportunity_finder","triage:park","urgency:low"],"ts":"2026-04-04T19:47:30.186661+00:00","urgency":"low","user_visible":true,"waiting_on":null,"why_it_matters":"This signal indicates potential growth in the renewable energy sector, which may be relevant for future planning."},{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"Critical situation in the Strait of Hormuz impacting oil prices","id":"sig:ffae2b7bd52680d5","kind":"inbox","links":{"dedupe_key":"opportunity_case_memory:case_e0c704e494be08ae:digest:2026-04-04T20","evidence_event_ids":["evt_fa25cc390745","evt_137d90f8a2f6","evt_03c3c581fae0"],"reason_trace":{"_evidence_event_ids":["evt_137d90f8a2f6","evt_03c3c581fae0"],"case_id":"case_e0c704e494be08ae","decision":"digest","entity_key":"equity:JP","memory_only":true,"theme_key":"entity_development"},"severity":"low","signal_id":"sig_2f26d8562094","signal_type":"opportunity_case_memory","source":"opportunity_finder","topic_key":"signal:opportunity_case_memory:f4c6ea4f041e54f8","triage":{"action_hints":["schedule review"],"confidence":0.5,"disposition":"park","entity_ids":[],"headline":"Critical situation in the Strait of Hormuz impacting oil prices","prior":{"family":"general","importance_band":"background","suggested_disposition":"park","suggested_route":"review","suggested_urgency":"low"},"priority_score":20.0,"rationale":"This situation may have long-term implications for global markets, warranting future review.","review_in_days":30,"route":"review","urgency":"low"},"user_visible":false},"next_touch_at_iso":null,"route":"review","score":28.0,"score_hint":0.0,"source_kind":"signal","tags":["family:general","priority:low","route:review","severity:low","signal","signal:opportunity_case_memory","source:opportunity_finder","triage:park","urgency:low"],"ts":"2026-04-04T20:07:32.128475+00:00","urgency":"low","user_visible":true,"waiting_on":null,"why_it_matters":"This situation may have long-term implications for global markets, warranting future review."},{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"Potential shift in market dynamics noted.","id":"sig:9e7efb70e1d6f86c","kind":"inbox","links":{"dedupe_key":"opportunity_case_memory:case_0d7af82e1ccd735f:digest:2026-04-04T05","evidence_event_ids":["evt_f63f1c2e1439","evt_8d573117939e","evt_e2715fbb9b97","evt_9816b75b730c","evt_ae0bc79681c0","evt_ae90e6fdd026","evt_b0cfeeb101ac","evt_d1db8cdc01ce","evt_a4cb46e0aa96","evt_58cc883bb620","evt_3573181812db","evt_c50f8c8037ca","evt_e768a8359788","evt_63486a5dc462"],"reason_trace":{"_evidence_event_ids":["evt_8d573117939e","evt_e2715fbb9b97","evt_9816b75b730c","evt_ae0bc79681c0","evt_ae90e6fdd026","evt_b0cfeeb101ac","evt_d1db8cdc01ce","evt_a4cb46e0aa96","evt_58cc883bb620","evt_3573181812db","evt_c50f8c8037ca","evt_e768a8359788","evt_63486a5dc462"],"case_id":"case_0d7af82e1ccd735f","decision":"digest","entity_key":"commodity:gold","memory_only":true,"theme_key":"entity_development"},"severity":"low","signal_id":"sig_87a1654f9e5a","signal_type":"opportunity_case_memory","source":"opportunity_finder","topic_key":"signal:opportunity_case_memory:6ec0d831aeb01377","triage":{"action_hints":["schedule review"],"confidence":0.5,"disposition":"park","entity_ids":[],"headline":"Potential shift in market dynamics noted.","prior":{"family":"general","importance_band":"background","suggested_disposition":"park","suggested_route":"review","suggested_urgency":"low"},"priority_score":20.0,"rationale":"This signal indicates a potential shift that could affect investment strategies, warranting future review.","review_in_days":7,"route":"review","urgency":"low"},"user_visible":false},"next_touch_at_iso":null,"route":"review","score":25.0,"score_hint":0.0,"source_kind":"signal","tags":["family:general","priority:low","route:review","severity:low","signal","signal:opportunity_case_memory","source:opportunity_finder","triage:park","urgency:low"],"ts":"2026-04-04T05:36:02.928777+00:00","urgency":"low","user_visible":true,"waiting_on":null,"why_it_matters":"This signal indicates a potential shift that could affect investment strategies, warranting future review."}],"meta":{"built_at":"2026-04-04T20:37:31.909820+00:00","daily_synthesis_source":"fallback","day":"2026-04-04","filters":{"deduped":0,"internal_shadow":0,"noise_signal":2,"stale":17,"stale_question":0,"stale_workflow":0},"fingerprint":"0c800a4d4b6d63e35b1173a858c22bb854dd8e3b","intelligence_directives":[{"action_type":null,"confidence":0.55,"evidence_event_id":null,"headline":"Delivery failure for critical itinerary communication","implication":"This item is currently one of the highest-leverage moves for trajectory control.","recommended_action":"Do this next: Delivery failure for critical itinerary communication","source":"heuristic","urgency":"high"},{"action_type":null,"confidence":0.55,"evidence_event_id":null,"headline":"Delivery failure detected for critical message","implication":"This item is currently one of the highest-leverage moves for trajectory control.","recommended_action":"Do this next: Delivery failure detected for critical message","source":"heuristic","urgency":"high"},{"action_type":null,"confidence":0.55,"evidence_event_id":null,"headline":"What should the subject and body of the email be?","implication":"This item is currently one of the highest-leverage moves for trajectory control.","recommended_action":"Do this next: What should the subject and body of the email be?","source":"heuristic","urgency":"high"},{"action_type":null,"confidence":0.55,"evidence_event_id":null,"headline":"Low priority internal notification","implication":"This item is currently one of the highest-leverage moves for trajectory control.","recommended_action":"Do this next: Low priority internal notification","source":"heuristic","urgency":"high"}],"limits":{"limit_inbox":250,"limit_pending":50,"max_do_now":5,"max_do_today":7,"max_must_do":5,"max_park":25,"max_should_do":7,"max_waiting":5},"owner_context":{"active_projects":[],"commitments":[],"top_focus":null,"work_focus":null},"planner_model":"gpt-4o-mini","source":"planner","timezone":"America/New_York","week_start":"2026-03-30"},"must_do":[{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"Delivery failure for critical itinerary communication","id":"sig:c4e740bcf8fff398","kind":"inbox","links":{"dedupe_key":"delivery_failure:2026-04-03:attn:C0A8Q869CNL:8c7139f:send_failed","evidence_event_ids":["evt_5f8b90887564"],"reason_trace":{},"severity":"high","signal_id":"sig_b39a9af62680","signal_type":"delivery_failure","source":"slack_outbox","topic_key":"signal:delivery_failure:b86a98cc60d392ad","triage":{"action_hints":["needs reply","schedule review"],"confidence":0.18,"disposition":"escalate","entity_ids":[],"headline":"Delivery failure for critical itinerary communication","prior":{"family":"high_consequence_signal","importance_band":"critical","suggested_disposition":"escalate","suggested_route":"review","suggested_urgency":"high"},"priority_score":174.74,"rationale":"This delivery failure affects the user's trip planning and requires immediate attention to ensure timely communication.","review_in_days":1,"route":"task","urgency":"high"},"user_visible":false},"next_touch_at_iso":"2026-04-03T20:40:00Z","route":"task","score":81.0,"score_hint":0.0,"source_kind":"signal","tags":["family:high_consequence_signal","priority:high","route:task","severity:high","signal","signal:delivery_failure","source:slack_outbox","triage:escalate","urgency:high"],"ts":"2026-04-03T20:37:22.554897+00:00","urgency":"high","user_visible":true,"waiting_on":null,"why_it_matters":"This delivery failure affects the user's trip planning and requires immediate attention to ensure timely communication."},{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"Delivery failure detected for critical message","id":"sig:df760c2dea93d3f5","kind":"inbox","links":{"dedupe_key":"delivery_failure:2026-04-03:attn:C0A8Q869CNL:93a0a9d:send_failed","evidence_event_ids":["evt_17ad88fd7712"],"reason_trace":{},"severity":"high","signal_id":"sig_dd772239aa4f","signal_type":"delivery_failure","source":"slack_outbox","topic_key":"signal:delivery_failure:a6244d941dea59b1","triage":{"action_hints":["needs reply"],"confidence":0.9,"disposition":"escalate","entity_ids":[],"headline":"Delivery failure detected for critical message","prior":{"family":"high_consequence_signal","importance_band":"critical","suggested_disposition":"escalate","suggested_route":"review","suggested_urgency":"high"},"priority_score":189.14,"rationale":"This delivery failure could impact the user's trip planning and requires immediate attention.","review_in_days":1,"route":"review","urgency":"high"},"user_visible":false},"next_touch_at_iso":"2026-04-03T20:45:00Z","route":"review","score":81.0,"score_hint":0.0,"source_kind":"signal","tags":["family:high_consequence_signal","priority:high","route:review","severity:high","signal","signal:delivery_failure","source:slack_outbox","triage:escalate","urgency:high"],"ts":"2026-04-03T20:30:35.356880+00:00","urgency":"high","user_visible":true,"waiting_on":null,"why_it_matters":"This delivery failure could impact the user's trip planning and requires immediate attention."},{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"What should the subject and body of the email be?","id":"pend_d733ac1aa3","kind":"followup","links":{"action_id":null,"action_type":null,"approval_id":null,"choices":[],"event_id":"evt_de327c9699d4","pending_kind":"missing_detail","source":"proposal_materializer","thread_id":"slkthr_776445451af92b39e8"},"next_touch_at_iso":null,"route":"today","score":55.0,"score_hint":6.0,"source_kind":"pending","tags":["missing_detail"],"ts":"2026-04-03T11:49:25.005404+00:00","urgency":"high","user_visible":true,"waiting_on":null,"why_it_matters":"The workflow cannot continue until the missing message details are provided."},{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"Low priority internal notification","id":"sig:8af2b7fac031ec35","kind":"inbox","links":{"dedupe_key":"triage_llm_error:2026-04-03","evidence_event_ids":["evt_83cf7e837633"],"reason_trace":{"batch":0,"stage":"llm.complete"},"severity":"high","signal_id":"sig_7732c4c57212","signal_type":"triage_llm_error","source":"inbox_triage","topic_key":"signal:triage_llm_error:98fc170e8df25b45","triage":{"action_hints":[],"confidence":0.5,"disposition":"promote","entity_ids":[],"headline":"Low priority internal notification","prior":{"family":"high_consequence_signal","importance_band":"critical","suggested_disposition":"escalate","suggested_route":"review","suggested_urgency":"high"},"priority_score":151.14,"rationale":"This notification does not require immediate action and is considered low value.","review_in_days":30,"route":"review","urgency":"high"},"user_visible":false},"next_touch_at_iso":null,"route":"review","score":41.0,"score_hint":0.0,"source_kind":"signal","tags":["family:high_consequence_signal","priority:high","route:review","severity:high","signal","signal:triage_llm_error","source:inbox_triage","triage:promote","urgency:high"],"ts":"2026-04-03T20:35:28.190731+00:00","urgency":"high","user_visible":true,"waiting_on":null,"why_it_matters":"This notification does not require immediate action and is considered low value."},{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"Strong evidence supports the current trend, with minimal contradictions.","id":"sig:517845e18c81a278","kind":"inbox","links":{"dedupe_key":"opportunity_case:case_466d5d6b987ca4bf:2026-04-04","evidence_event_ids":["evt_ff2c94007f96","evt_08a193b0faea","evt_66284ddb94a3","evt_47988436838f","evt_d77f3fe4840a","evt_3e0840984fc3","evt_a6d8db03fb29","evt_3be7a158b203","evt_bf07ef74283a","evt_9d0be270ba85","evt_bf4891d4e0d5","evt_7b8214726ed9","evt_9efcd6576c9b","evt_20115c1475f4","evt_31eb5ad9d5fc","evt_e1dc93ece7c5"],"reason_trace":{"_evidence_event_ids":["evt_08a193b0faea","evt_66284ddb94a3","evt_47988436838f","evt_d77f3fe4840a","evt_3e0840984fc3","evt_a6d8db03fb29","evt_3be7a158b203","evt_bf07ef74283a","evt_9d0be270ba85","evt_bf4891d4e0d5","evt_7b8214726ed9","evt_9efcd6576c9b","evt_20115c1475f4","evt_31eb5ad9d5fc","evt_e1dc93ece7c5"],"case_id":"case_466d5d6b987ca4bf","decision":"surface","entity_key":"equity:XLE","theme_key":"entity_development"},"severity":"medium","signal_id":"sig_999c227afa4f","signal_type":"opportunity_signal","source":"opportunity_finder","topic_key":"signal:opportunity_signal:d87666cf651bb21c","triage":{"action_hints":["schedule review"],"confidence":0.12,"disposition":"park","entity_ids":[],"headline":"Strong evidence supports the current trend, with minimal contradictions.","prior":{"family":"opportunity","importance_band":"meaningful","suggested_disposition":"promote","suggested_route":"review","suggested_urgency":"medium"},"priority_score":58.96,"rationale":"This opportunity signal may be relevant for future planning, especially regarding the trip itinerary.","review_in_days":3,"route":"review","urgency":"medium"},"user_visible":false},"next_touch_at_iso":null,"route":"review","score":33.0,"score_hint":0.0,"source_kind":"signal","tags":["family:opportunity","priority:medium","route:review","severity:medium","signal","signal:opportunity_signal","source:opportunity_finder","triage:park","urgency:medium"],"ts":"2026-04-04T05:00:58.305201+00:00","urgency":"medium","user_visible":true,"waiting_on":null,"why_it_matters":"This opportunity signal may be relevant for future planning, especially regarding the trip itinerary."}],"notes":[],"one_thing":{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"Delivery failure for critical itinerary communication","id":"sig:c4e740bcf8fff398","kind":"inbox","links":{"dedupe_key":"delivery_failure:2026-04-03:attn:C0A8Q869CNL:8c7139f:send_failed","evidence_event_ids":["evt_5f8b90887564"],"reason_trace":{},"severity":"high","signal_id":"sig_b39a9af62680","signal_type":"delivery_failure","source":"slack_outbox","topic_key":"signal:delivery_failure:b86a98cc60d392ad","triage":{"action_hints":["needs reply","schedule review"],"confidence":0.18,"disposition":"escalate","entity_ids":[],"headline":"Delivery failure for critical itinerary communication","prior":{"family":"high_consequence_signal","importance_band":"critical","suggested_disposition":"escalate","suggested_route":"review","suggested_urgency":"high"},"priority_score":174.74,"rationale":"This delivery failure affects the user's trip planning and requires immediate attention to ensure timely communication.","review_in_days":1,"route":"task","urgency":"high"},"user_visible":false},"next_touch_at_iso":"2026-04-03T20:40:00Z","route":"task","score":81.0,"score_hint":0.0,"source_kind":"signal","tags":["family:high_consequence_signal","priority:high","route:task","severity:high","signal","signal:delivery_failure","source:slack_outbox","triage:escalate","urgency:high"],"ts":"2026-04-03T20:37:22.554897+00:00","urgency":"high","user_visible":true,"waiting_on":null,"why_it_matters":"This delivery failure affects the user's trip planning and requires immediate attention to ensure timely communication."},"parked":[],"should_do":[{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"Renewable energy sector growth signal","id":"sig:8b99b98705f4a870","kind":"inbox","links":{"dedupe_key":"opportunity_case_memory:case_6640d79fb2f20e94:digest:2026-04-04T19","evidence_event_ids":["evt_b744b8aa725b","evt_2d87b7bc3b55","evt_62ed08300906","evt_8e1a474d9b47","evt_2d790fe361f0","evt_aa3cf4bb2bd0","evt_bbb7a9cd2ef6","evt_891a0f95f82f","evt_eb398727cbc0","evt_776d983e6f50","evt_577a43020852","evt_05fd48ae1bda","evt_2fe937f5c8bf","evt_7844aa678bdb","evt_e99e2cd9d15e"],"reason_trace":{"_evidence_event_ids":["evt_2d87b7bc3b55","evt_62ed08300906","evt_8e1a474d9b47","evt_2d790fe361f0","evt_aa3cf4bb2bd0","evt_bbb7a9cd2ef6","evt_891a0f95f82f","evt_eb398727cbc0","evt_776d983e6f50","evt_577a43020852","evt_05fd48ae1bda","evt_2fe937f5c8bf","evt_7844aa678bdb","evt_e99e2cd9d15e"],"case_id":"case_6640d79fb2f20e94","decision":"digest","entity_key":"equity:AA","memory_only":true,"theme_key":"entity_development"},"severity":"low","signal_id":"sig_3f3379d75752","signal_type":"opportunity_case_memory","source":"opportunity_finder","topic_key":"signal:opportunity_case_memory:66ce0a426f274dbc","triage":{"action_hints":["schedule review"],"confidence":0.5,"disposition":"park","entity_ids":[],"headline":"Renewable energy sector growth signal","prior":{"family":"general","importance_band":"background","suggested_disposition":"park","suggested_route":"review","suggested_urgency":"low"},"priority_score":20.0,"rationale":"This signal indicates potential growth in the renewable energy sector, which may be relevant for future planning.","review_in_days":7,"route":"review","urgency":"low"},"user_visible":false},"next_touch_at_iso":null,"route":"review","score":28.0,"score_hint":0.0,"source_kind":"signal","tags":["family:general","priority:low","route:review","severity:low","signal","signal:opportunity_case_memory","source:opportunity_finder","triage:park","urgency:low"],"ts":"2026-04-04T19:47:30.186661+00:00","urgency":"low","user_visible":true,"waiting_on":null,"why_it_matters":"This signal indicates potential growth in the renewable energy sector, which may be relevant for future planning."},{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"Critical situation in the Strait of Hormuz impacting oil prices","id":"sig:ffae2b7bd52680d5","kind":"inbox","links":{"dedupe_key":"opportunity_case_memory:case_e0c704e494be08ae:digest:2026-04-04T20","evidence_event_ids":["evt_fa25cc390745","evt_137d90f8a2f6","evt_03c3c581fae0"],"reason_trace":{"_evidence_event_ids":["evt_137d90f8a2f6","evt_03c3c581fae0"],"case_id":"case_e0c704e494be08ae","decision":"digest","entity_key":"equity:JP","memory_only":true,"theme_key":"entity_development"},"severity":"low","signal_id":"sig_2f26d8562094","signal_type":"opportunity_case_memory","source":"opportunity_finder","topic_key":"signal:opportunity_case_memory:f4c6ea4f041e54f8","triage":{"action_hints":["schedule review"],"confidence":0.5,"disposition":"park","entity_ids":[],"headline":"Critical situation in the Strait of Hormuz impacting oil prices","prior":{"family":"general","importance_band":"background","suggested_disposition":"park","suggested_route":"review","suggested_urgency":"low"},"priority_score":20.0,"rationale":"This situation may have long-term implications for global markets, warranting future review.","review_in_days":30,"route":"review","urgency":"low"},"user_visible":false},"next_touch_at_iso":null,"route":"review","score":28.0,"score_hint":0.0,"source_kind":"signal","tags":["family:general","priority:low","route:review","severity:low","signal","signal:opportunity_case_memory","source:opportunity_finder","triage:park","urgency:low"],"ts":"2026-04-04T20:07:32.128475+00:00","urgency":"low","user_visible":true,"waiting_on":null,"why_it_matters":"This situation may have long-term implications for global markets, warranting future review."},{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"Potential shift in market dynamics noted.","id":"sig:9e7efb70e1d6f86c","kind":"inbox","links":{"dedupe_key":"opportunity_case_memory:case_0d7af82e1ccd735f:digest:2026-04-04T05","evidence_event_ids":["evt_f63f1c2e1439","evt_8d573117939e","evt_e2715fbb9b97","evt_9816b75b730c","evt_ae0bc79681c0","evt_ae90e6fdd026","evt_b0cfeeb101ac","evt_d1db8cdc01ce","evt_a4cb46e0aa96","evt_58cc883bb620","evt_3573181812db","evt_c50f8c8037ca","evt_e768a8359788","evt_63486a5dc462"],"reason_trace":{"_evidence_event_ids":["evt_8d573117939e","evt_e2715fbb9b97","evt_9816b75b730c","evt_ae0bc79681c0","evt_ae90e6fdd026","evt_b0cfeeb101ac","evt_d1db8cdc01ce","evt_a4cb46e0aa96","evt_58cc883bb620","evt_3573181812db","evt_c50f8c8037ca","evt_e768a8359788","evt_63486a5dc462"],"case_id":"case_0d7af82e1ccd735f","decision":"digest","entity_key":"commodity:gold","memory_only":true,"theme_key":"entity_development"},"severity":"low","signal_id":"sig_87a1654f9e5a","signal_type":"opportunity_case_memory","source":"opportunity_finder","topic_key":"signal:opportunity_case_memory:6ec0d831aeb01377","triage":{"action_hints":["schedule review"],"confidence":0.5,"disposition":"park","entity_ids":[],"headline":"Potential shift in market dynamics noted.","prior":{"family":"general","importance_band":"background","suggested_disposition":"park","suggested_route":"review","suggested_urgency":"low"},"priority_score":20.0,"rationale":"This signal indicates a potential shift that could affect investment strategies, warranting future review.","review_in_days":7,"route":"review","urgency":"low"},"user_visible":false},"next_touch_at_iso":null,"route":"review","score":25.0,"score_hint":0.0,"source_kind":"signal","tags":["family:general","priority:low","route:review","severity:low","signal","signal:opportunity_case_memory","source:opportunity_finder","triage:park","urgency:low"],"ts":"2026-04-04T05:36:02.928777+00:00","urgency":"low","user_visible":true,"waiting_on":null,"why_it_matters":"This signal indicates a potential shift that could affect investment strategies, warranting future review."}],"version":"planner_v3_hybrid","waiting":[]},"stats":{"builder":"deterministic_v2","counts":{"actionable":8,"do_now":5,"do_today":3,"inbox_in":7,"must_do":5,"parked":0,"pending_in":1,"should_do":3,"visible":8,"waiting":0},"daily_synthesis_source":"fallback","fingerprint":"0c800a4d4b6d63e35b1173a858c22bb854dd8e3b","planner_model":"gpt-4o-mini"}}
TEXT NOT NULL
source_ref
NULL
TEXT
confidence
REAL (default 0.0
dedupe_key
planner_plan_built:2026-04-04:774342135d83e6d7157a55f5829664f76a0c821a
TEXT
episode_id
NULL
TEXT
created_at
2026-04-04T20:37:32.010896+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel