Kinetic Edge Health

Description:

Implement system-wide audit logging to track data changes across the application for security, compliance, and troubleshooting.

Requirements:

• Capture audit logs for all Insert, Update, and Delete operations on critical entities.
• For each audited action, store:
• Action type (Insert, Update, Delete)
• Affected entity/table name
• Previous data snapshot (for Update and Delete)
• New data snapshot (for Insert and Update)
• List of modified fields (for Update actions)
• Reference to the affected record
• User who performed the action
• Tenant context
• Date and time of the action (UTC)
• Audit logs must be generated automatically and should not affect normal transaction flow.
• Audit logs must be read-only and not editable by any role.
• Audit logs should be accessible only to Admin role.
• Provide basic filtering options such as date range, entity name, and action type.

Acceptance Criteria:

• All configured data changes generate audit log entries.
• Old and new data are captured accurately.
• Updated fields are tracked correctly.
• Audit logs are immutable.
• Only Admin users can view audit logs with filters.