Audit Trail¶
The audit trail logs all changes to records in the system. It ensures complete traceability of all editing operations and is a central requirement for compliance with quality standards such as ISO 17025.
Overview¶
The audit trail automatically captures every creation, modification, and deletion of records. The timestamp, the executing user, as well as the old and new values are stored.
Monitored Areas¶
Each area is maintained in a separate audit table. The column display is loaded dynamically based on roles.
| Area | Table | Description |
|---|---|---|
| Inventory | inventory_audit |
Changes to inventory records. |
| Bookings | booking_audit |
Changes to booking records. |
| Customers | customers_audit |
Changes to customer master data. |
| Maintenance / Repair | repair_audit |
Changes to maintenance and repair orders. |
Columns¶
| Column | Description |
|---|---|
| Timestamp | Date and time of the change. |
| User | Name of the user who made the change. |
| Type | Type of change (INSERT, UPDATE, DELETE). |
| Field Name | Name of the changed field. |
| Old Value | Value before the change. |
| New Value | Value after the change. |
| Table | Affected data area (e.g., inventory, calibration). |
| Record ID | Unique identifier of the affected record. |
Access¶
The audit trail is accessible in various areas of the system:
- Inventory details: Under the Status History tab, all changes to the respective inventory are displayed.
- Customer details: Changes to the customer record and associated contacts.
- Booking details: Changes to individual booking processes.
Typical Usage Scenarios¶
- Change tracking: Checking who made which changes to a device record and when.
- Quality audit: Proof of complete documentation for external audits and certifications.
- Error analysis: Identification of erroneous changes and tracing back to the originator.
- Status history: Tracking the status changes of an inventory item over its entire lifecycle.
Technical Notes¶
Automatic Capture
The audit trail is automatically populated with every data change. No manual action is required. System-internal changes are logged with the user "SYSTEM".
Immutability
Audit trail entries are part of the revision-proof documentation. Changes to the audit trail itself should only be made by authorized personnel.
- Status fields are automatically translated into readable labels (e.g., inventory status, booking status).
- The view supports filtering by user, time period, change type, and field name.
- The displayed column configuration is role-dependent and loaded dynamically via AJAX.
- Access requires the permission
inventory_details_statushistory_view.