Module audit log (immutable log); it is written by the trigger TRG_APMO_PROJECT and is debugged according to APMO_CONFIG.audit_retention_days
Data model
Fields
| Field | Type | Description |
|---|---|---|
| action_type* | VARCHAR (30) | Audited Action: INSERT, UPDATE, or DELETE |
| audit_log_id* | UNIQUEIDENTIFIER | Unique Audit Event Identifier |
| entity_id* | UNIQUEIDENTIFIER | Audited record identifier |
| entity_name* | VARCHAR (100) | Name of the audited entity (e.g. APMO_PROJECT) |
| event_date* | DATETIME2 | Date of the audit event |
| ip_address | VARCHAR (45) | IP address of the source of the change |
| new_value | NVARCHAR (MAX) | New Record Value (JSON) |
| old_value | NVARCHAR (MAX) | Previous Record Value (JSON) |
| user_id* | INT | ASMS user responsible for the change (AFW_USERS.user_id, no physical FK to the core) |
| user_name | NVARCHAR (510) | User’s name at the time of the event (copy of AFW_USERS.user_name); retained even if the user is deleted |
Primary Key
| PK_APMO_AUDIT_LOG |
|---|
| audit_log_id |