View the Delegation Audit Trail for Proxy and Bulk Submitted Activities
The Delegation Repository provides read access to the delegation_grants table, which records the acting coordinator's user_id, the subject peer mentor's user_id, the activity ID, the submission timestamp, and whether the submission was bulk or individual proxy. A coordinator can query this data filtered by date range, mentor, or submission type. The results show a chronological list of delegated submissions with enough detail to identify what was registered, when, and by whom.
User Story
Acceptance Criteria
- Given the coordinator queries the delegation audit trail, when results are returned, then each record shows the acting coordinator, the subject peer mentor, the activity ID, and the submission timestamp
- Given the coordinator filters by a specific peer mentor, when the filter is applied, then only delegation records for that mentor are displayed
- Given the coordinator filters by date range, when the filter is applied, then only records within that range are shown
- Given a bulk submission created 25 delegation records, when the coordinator queries by that batch's submission date, then all 25 records are present and each is attributed to the correct mentor
- Given a proxy submission was made, when the coordinator views the delegation record, then the acting coordinator's identity is clearly shown separately from the peer mentor's user_id
Business Value
Bufdir grant reporting requires that registered activities be verifiable and attributable. The delegation audit trail is the mechanism that distinguishes legitimate coordinator-on-behalf submissions from data entry errors or potential misuse. Without it, organizations cannot demonstrate proper governance of proxy submissions to auditors, grant administrators, or their own internal compliance processes.