Contains the information of the actions that are performed on the directory
Data model

Fields
Field |
Type |
Description |
action_date |
DATETIME |
Date on which the operation was performed in the directory |
action_id |
INT |
Unique identifier of the action that was performed in the directory |
auxiliary |
VARCHAR (50) |
Additional Transaction Information |
domain_id* |
INT |
LDAP Unique Identifier |
id* |
INT |
Unique audit identifier |
ip |
VARCHAR (255) |
IP from which the operation was performed |
type |
INT |
Type of audit |
user_id* |
INT |
Unique user identifier |
Primary Key
References
Column |
Referenced Table |
Referenced column |
Name |
domain_id* |
Bod. AFW_LDAP |
id |
FK02_APR_AUDIT |
user_id* |
dbo.AFW_USERS |
user_id |
FK01_APR_AUDIT |