EN
Español
English
Português
    APMO_AUDIT_LOG

    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