auditors_log.
Lifecycle
Supported status values arepending, approved, and closed.
Auditors can withdraw pending requests they created when they have cases:withdraw_pending_request. Application administrators can approve or close pending requests when they have cases:approve_creation.
Data model
Tables
| Table | Purpose |
|---|---|
disclosure_requests | Parent request with org, application, requester, reason, status, type, approvals required |
request_decisions | Administrator approve/reject decisions and reasons |
case_requests | Case period, access duration, disclosure flags, future case id, optional contract filters |
case_request_auditor_assignments | Auditor assignments proposed at request time |
cases | Approved investigation case |
case_auditor_assignments | Active case auditor assignments; removed assignments are soft-deleted |
reports | Generated report files and metadata |
auditors_log | Activity trail for request, decision, case, report, team, and application actions |
Main endpoints
| Endpoint | Purpose | Main permission |
|---|---|---|
GET /api/applications/:foreignId/disclosure-registry | Administrator disclosure request registry | cases:approve_creation |
GET /api/applications/:foreignId/cases | Case list and auditor worklist | reports:view_transactions or case/admin-specific checks |
POST /api/applications/:foreignId/cases | Create disclosure case request | cases:create |
POST /api/applications/:foreignId/cases/requests/:id/withdraw | Withdraw own pending request | cases:withdraw_pending_request |
POST /api/applications/:foreignId/case-requests/:id/approve | Approve request | cases:approve_creation |
POST /api/applications/:foreignId/case-requests/:id/close | Close request | cases:approve_creation |
POST /api/applications/:foreignId/case-reports | Generate transaction summary report | reports:create |
GET /api/applications/:foreignId/reports | List application reports | reports:list |
GET /api/applications/:foreignId/reports/:reportId/download | Download application report | reports:download |
GET /api/applications/:foreignId/auditors-log | Application activity log | logs:view_activity |
GET /api/applications/:foreignId/cases/:caseId/auditors-log | Case activity log | reports:view_transactions |
Transaction review scope
Case transaction review reads interpreted records after these filters:| Filter | Source |
|---|---|
| Organization | Authenticated session orgId |
| Application | :foreignId resolved to application_id |
| Case | cases.id |
| Period | case_requests.period_from, case_requests.period_to |
| Contract address | case_requests.investigation_contract_addresses or cases.contract_addresses |
| Assignment | case_auditor_assignments |
| Access window | cases.created_at + access_days |
| Field scope | full_tx_ids, sender_information, withdrawal_details |
Reports
Report rows contain:idorg_idapplication_idfile_blobmetadatatypecreated_by_user_idcreated_by_emailcreated_by_namecreated_at
| Boundary | Endpoint |
|---|---|
| Organization | GET /api/reports, GET /api/reports/:reportId/download |
| Application | GET /api/applications/:foreignId/reports, GET /api/applications/:foreignId/reports/:reportId/download |
| Case transaction summary | POST /api/applications/:foreignId/case-reports |
| Activity log report | POST /api/auditors-log/reports, POST /api/applications/:foreignId/auditors-log/reports, POST /api/applications/:foreignId/cases/:caseId/auditors-log/reports |
Activity log
auditors_log records:
| Column | Meaning |
|---|---|
event_type | Action type |
user | Actor display field |
org_id | Organization scope |
user_id | Internal actor user id |
workos_user_id | External identity user id |
object | Typed target object JSON |
details | Typed event details JSON |
application_foreign_id | Optional application route segment |
case_id | Optional case id |
created_at | Event timestamp |