Defining types of messages for the Audit Log

Use the Audit Log Types form to create types of messages to include in the audit log. By default, the system generates messages when users log on (type 1) and when users open a form (type 2). Developers can create other types of messages that are generated by event handlers of the Add Entry to Audit Log response type.

The Audit Log Types form displays this information:

  • Message Type indicates the type of message in the audit log. By default, messages about users logging on are 1, messages about users opening forms are 2, and messages about users modifying forms or objects are 3. Custom messages are numbered 10,000 and greater.
  • Category identifies the type of auditing. Three values can appear in this field:
    • System: Types of events are User Login and Open Form. You cannot select a category of System.
    • Custom Form Event: This allows programmers to add audit logging to any event handler; for example, when a user selects a tab on a form.
    • Database: Database displays when records are added, updated, and deleted, and the message displays Database: Add, Database: Update, or Database: Delete, depending on the action performed.
  • Table or Description. For System and Custom Form Events, this field describes the event being logged. You can change the contents of this field at any time. The value in this field appears in the Audit Log.

    For an entry where Category is set to Database, this field indicates the table that will have an audit log.

  • Fields is used only if the Category is Database. This can be a specific database field (cust_num, for example) or an asterisk (*). Entry of an asterisk indicates that all fields in the table should be entered in the audit log.