UC0004 - Check Full Member Meeting Attendance

Initiating actor: Board Member

A Board Member opens a Full Member Meeting attendance list and records attendance statuses for full members. In this scenario, the Board Member is acting as the Secretary.

Scenario

1. The Board Member opens the attendance page for the Full Member Meeting on 12 March 2026.

2. The application lists full members with their RSVP, attendance status, and announced absence if one exists.

SELECT
    s.student_index,
    s.first_name,
    s.last_name,
    p.rsvp_status,
    p.attendance_status,
    aa.reason
FROM full_members fm
JOIN students s
    ON s.student_index = fm.student_index
LEFT JOIN participation p
    ON p.student_index = fm.student_index
   AND p.as_id = 8
LEFT JOIN announces_absence aa
    ON aa.student_index = fm.student_index
   AND aa.as_id = 8
ORDER BY s.last_name, s.first_name;

3. The Board Member marks member 230005 as excused.

4. The application updates the attendance status.

UPDATE participation
SET attendance_status = 'excused'
WHERE student_index = 230005
  AND as_id = 8;

5. The application shows the updated attendance row.

SELECT
    p.student_index,
    s.first_name,
    s.last_name,
    p.rsvp_status,
    p.attendance_status,
    aa.reason
FROM participation p
JOIN students s
    ON s.student_index = p.student_index
LEFT JOIN announces_absence aa
    ON aa.student_index = p.student_index
   AND aa.as_id = p.as_id
WHERE p.student_index = 230005
  AND p.as_id = 8;