CL-PM Integration Contract: Group Sessions

-- CL-14 adds this column to cl_group_sessions
schedule_id UUID  -- References pm_group_schedule.id via Platform Integration Layer
                  -- NOT a direct FK (would violate core independence)
                  -- Validated at application layer

interface ClGroupSessionDocumented {
  event: 'cl_group_session_documented';
  publisher: 'CL';
  subscriber: ['PM'];
  payload: {
    session_id: uuid;
    schedule_id: uuid;       // Links to pm_group_schedule
    session_date: string;
    actual_start_time: string;
    actual_end_time: string;
    duration_minutes: number;
    facilitator_id: uuid;
    attendees: Array<{
      chart_id: uuid;
      patient_id: uuid;
      attendance_status: string;
      participation_level: string;
    }>;
    participant_count: number;  // Count of 'present' attendees
  };
  metadata: {
    organization_id: uuid;
    user_id: uuid;
    timestamp: string;
    correlation_id: uuid;
  };
}

-- Platform Integration Layer view for IOP/PHP compliance
CREATE VIEW platform_iop_php_compliance AS
SELECT
  ga.organization_id,
  c.patient_id,
  date_trunc('week', gs.session_date) AS week_start,
  COUNT(DISTINCT gs.session_date) AS days_attended,
  SUM(gs.duration_minutes) / 60.0 AS hours_attended
FROM cl_group_attendance ga
JOIN cl_group_sessions gs ON ga.session_id = gs.id
JOIN cl_patient_charts c ON ga.chart_id = c.id
WHERE ga.attendance_status = 'present'
GROUP BY ga.organization_id, c.patient_id, date_trunc('week', gs.session_date);