Reports and the audit log
Report on training across every client, export the records as CSV or one client's evidence pack, withdraw a certificate, and check an audit log's hash chain.
Reports holds the training records for every client. The Audit log holds every recorded action, per organisation. Between them they answer who was trained on what, and who changed what.
Overview
Section titled “Overview”The agency Overview comes first. It flags overdue assignments across all clients and any pool that’s 80% used or more, then shows the key numbers: active client organisations, active learners, published courses, open assignments and certificates issued. Under those, a table gives each active client’s people, assignments, completions, overdue assignments and progress as a percentage.
Reports
Section titled “Reports”Reports has one row per assignment of every person who isn’t deactivated, 50 to a page:
| Column | What it shows |
|---|---|
| Organisation | The client |
| Learner | Their name |
| Course | Title and version |
| Due | The due date |
| Status | Open, Overdue, Passed, Failed, Expired or Withdrawn |
| Completed | The date of the latest completion |
| Score | Its score |
| Certificate | The certificate number |
An open assignment past its due date counts as Overdue. Pick an Organisation and a Status and select Apply to filter.
Export for an auditor
Section titled “Export for an auditor”Export CSV downloads every row the filters leave, not only the page on screen, as training-records-<date>.csv. The button shows how many rows it holds.
The columns are: Organisation, Given name, Family name, Email, Job title, Department, Person status, Course, Version, Assigned, Due, Status, Completed, Score, Certificate, Certificate link.
A client admin downloads the same file for their own organisation from their Overview, so a client doesn’t need to ask you for it. Theirs also keeps the people they’ve deactivated, marked deactivated. The record export is the client’s side of it.
The export is safe to open in a spreadsheet. A cell that starts like a formula is written so the spreadsheet shows it as text.
Pick one client under Organisation and select Apply, and two more downloads appear beside Export CSV:
- Download evidence pack: the PDF the client’s admins download from their Overview, a summary of their AI literacy training with their training records CSV attached and its SHA-256 printed. The evidence pack describes what it holds.
- Download training records: that client’s own CSV,
training-records-<client>-<date>.csv, every record with the people they’ve deactivated, the file their admins download. The pack’s SHA-256 matches this file. It doesn’t match Export CSV, which applies your filters and leaves deactivated people out.
Neither follows the status filter. Both are written to the client’s audit log, as evidence_pack.generated and training_records.exported, so the client sees them.
A pack holds up to 10,000 training records and 50,000 audit events. Past either, Reports shows why in place of the button. To produce one on request, download the client’s training records, run Verify the chain on their audit log, and send both with a note of the chain’s result.
Withdraw a certificate
Section titled “Withdraw a certificate”When the record behind a certificate is wrong, for example a course recorded against the wrong person, withdraw the certificate. Open it at /certificate/ followed by its number, select Withdraw certificate, write the reason and select Withdraw. Only agency admins see the button.
A withdrawal can’t be undone. The certificate keeps its number and its row; the withdrawal is recorded next to it with your reason and as certificate.revoked in the client’s audit log. From then on the certificate page says when it was withdrawn and why, its PDF can’t be downloaded, and anyone who checks it is told it was withdrawn, without the reason. The training record stays in the reports and the export as it was.
The audit log
Section titled “The audit log”Audit log shows one organisation’s actions, newest first, 50 to a page: the time, who did it, the action, and a line of detail. It opens on Aigentcy’s own log, where the catalog and the pools are recorded. Pick a client under Organisation and select Show for theirs. Search the page, or filter it by action.
Entries can’t be edited or deleted, by the app or in the database. Each one carries the hash of the one before it in the same organisation. Verify the chain recomputes every hash in the organisation’s log and either confirms they all hold or names the first entry that doesn’t, which means it, or an entry before it, was changed or added outside the app.
The app records these actions:
| Action | When |
|---|---|
organisation.created |
You create a client organisation with its first admin |
organisation.renamed, organisation.archived, organisation.restored |
You rename, archive or restore one |
person.created |
A client admin adds a person |
people.imported, people.onboarded |
A client admin imports people from CSV or BambooHR |
invitation.issued, invitation.accepted |
Someone is invited, or accepts |
person.deactivated |
Someone is deactivated |
training_records.exported |
A client admin or you download the client’s training records, with the number of rows |
evidence_pack.generated |
A client admin or you download the client’s evidence pack, with the number of rows and the CSV’s SHA-256 |
integration.connected, integration.disconnected |
A client connects or disconnects BambooHR |
assignment.created |
A course is assigned |
assignment.started, assignment.retaken |
A learner opens a course for the first time, or again after failing it |
completion.recorded |
A learner passes or fails a course, and with a pass its certificate is issued |
certificate.revoked |
You withdraw a certificate, with your reason |
allocation.set |
You change a client’s seats from a pool |
course.created, course.updated |
You create or edit a course |
version.created, version.updated, version.published, version.retired |
You create, edit, publish or retire a version |
package.uploaded, package.rejected, package.discarded |
A package becomes a module, is turned away, or is discarded |
module.removed |
You remove a module from a draft |
pool.created, pool.resized |
You add or resize a licence pool |