Assure DQ

 View Only
  • 1.  Insight ACRWV.AUDITEVENT column values

    Posted 02-08-2021 15:22

    Can you tell me where I can find a list of values for PRODUCT, ACTION and OBJECTTYPE columns in the ACRWV.AUDITEVENT table?  Assuming '1' = Insight, and action '3' =logoff or login.  trying to do some analysis on what reports are being accessed, etc...



  • 2.  RE: Insight ACRWV.AUDITEVENT column values

    Employee
    Posted 02-09-2021 07:25

    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.



  • 3.  RE: Insight ACRWV.AUDITEVENT column values

    Employee
    Posted 02-09-2021 07:50

    Tracy,

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

    Matthew Kennedy

     



  • 4.  RE: Insight ACRWV.AUDITEVENT column values

    Posted 02-26-2021 09:43

    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.



  • 5.  RE: Insight ACRWV.AUDITEVENT column values

    Employee
    Posted 02-26-2021 10:09

    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



  • 6.  RE: Insight ACRWV.AUDITEVENT column values

    Posted 02-26-2021 10:22

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