Primary source family
Collaboration data
Notes, action items, and decision logs stored in team collaboration schemas with cross-module tagging.
Amazon intelligence
Team notes, action items, and decision log for the Renuv account.
Primary source family
Collaboration data
Notes, action items, and decision logs stored in team collaboration schemas with cross-module tagging.
Trust posture
Internal team context
No customer-facing exposure. Purely internal coordination surface with module cross-references.
Operator focus
Action tracking
5 pending/in-progress actions with clear ownership, priorities, and due dates.
Active items
Source: reporting_amazon.next_actions
Recent activity
Source: reporting_amazon.team_notes
Decision log
Source: reporting_amazon.decision_log
Data sources
Each section is backed by a named reporting view for auditability and traceability.
Team notes
CREATE VIEW reporting_amazon.team_notes AS
SELECT
note_id,
created_at,
author_name,
note_category,
note_title,
note_detail,
tags,
related_module
FROM team_collaboration.notes
WHERE brand_id = ?
AND created_at >= ?
ORDER BY created_at DESC;Next actions
CREATE VIEW reporting_amazon.next_actions AS
SELECT
action_id,
action_title,
action_description,
priority,
status,
assigned_to,
due_date,
created_at,
related_module,
blocker_detail
FROM team_collaboration.action_items
WHERE brand_id = ?
AND status IN ('pending', 'in-progress', 'blocked')
ORDER BY
CASE priority
WHEN 'high' THEN 1
WHEN 'medium' THEN 2
WHEN 'low' THEN 3
END,
due_date ASC;Decision log
CREATE VIEW reporting_amazon.decision_log AS
SELECT
decision_id,
decision_date,
decision_summary,
context,
expected_outcome,
participants
FROM team_collaboration.decision_log
WHERE brand_id = ?
AND decision_date >= ?
ORDER BY decision_date DESC;