We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Insight ACRWV.AUDITEVENT column values

Comments

5 comments

  • Avatar
    Gerard Cafaro

    The data in the AUDITEVENT table gets translated into the actual values in the Audit Trail report in the UI. You can access this report under Reports -> Audit Trail:

    For your report analysis, a filter on Object Type for Control Report, Freeform Report or User Report would show the activity associated with each of them.

    0
    Comment actions Permalink
  • Avatar
    Matthew Kennedy

    Tracy,

    Navigating to the "Help Documentation" within the UI, there is a section detailing information that may be helpful on this topic :

    Matthew Kennedy

     

    0
    Comment actions Permalink
  • Avatar
    Stephanie Brockway

    We are doing our own reporting and controls off of the table directly and were hoping to save some time by getting the key to the info directly from Infogix, versus having to do trial and error and cross referencing the Audit Trail Report.  While we will undoubtedly manage, if you have the mapping of the flag values to the activities, that would add a ton of value and save us a good amount of time.

    0
    Comment actions Permalink
  • Avatar
    Matthew Kennedy

    Stephanie, are you looking for something similar to the following :

    Action Type :

    -1 : "Unknown"
    0 : "Generated PDF"
    1 : "Exported"
    2 : "Accessed"
    3 : "Removed"
    4 : "Assigned"
    5 : "Rolled Off"
    6 : "Created"
    7 : "Edited"
    8 : "Deleted"
    9 : "Imported"
    10 : "Manual Start"
    11 : "Loaded"
    12 : "Reloaded"
    13 : "Taken"
    14 : "Released"
    15 : "Submitted"
    16 : "Rejected"
    17 : "Escelated"
    18 : "Approved"
    19 : "Opened"
    20 : "Closed"
    21 : "Approve Requsted"
    22 : "Reopened"
    23 : "Batch Updated"
    24 : "Logged In"
    25 : "Logged Off"
    26 : "Timeoff"

    Object Type :

    -1 : "Unknown"
    0 : "Control Report"
    1 : "User Report"
    2 : "Result Catalog"
    3 : "Key History"
    4 : "Freeform Report"
    5 : "Job History"
    6 : "Control"
    7 : "Control Execution"
    8 : "Contact"
    9 : "Control Group"
    10 : "Control View"
    11 : "Compliance Program"
    12 : "Info Source"
    13 : "Insight Rules"
    14 : "Note"
    15 : "Auto Assignment"
    16 : "System Opts"
    17 : "History Extract"
    18 : "Autoload Status"
    19 : "Dashboard"
    20 : "Dashboard Component"
    21 : "Case Queue"
    22 : "Case Routing Rule"
    23 : "Case"
    24 : "Report"
    25 : "Process Model"
    26 : "Basic Job Info"
    27 : "User Report Info"
    28 : "Basic File Info"
    29 : "History Analysis Report"
    30 : "History Analysis Process"
    31 : "History Analysis"
    32 : "Internal Translation Table Info"
    33 : "Cycle Table Info"
    34 : "External Translation Info"
    35 : "Login Info"
    36 : "Logoff Info"
    37 : "Custom View"
    38 : "Custom Component"
    39 : "User Prefs"

    Matthew Kennedy

    0
    Comment actions Permalink
  • Avatar
    Stephanie Brockway

    Yes, this is exactly what we were hoping for. Thank you so much!

    0
    Comment actions Permalink

Please sign in to leave a comment.