Release 10.1A: OpenEdge Getting Started:
Core Business Services

> ## Audit data schema overview

> Figure 14–1 shows an entity relationship diagram for the audit data and supporting tables and provides a brief description of each from a reporting perspective.

> Figure 14–1: Audit tables schema

> In Figure 14–1:

> - The primary table is `_aud-audit-data`, which`` holds the details of the event that was audited, such as who did it and when, for example. It may also contain a delimited list of modified field values depending on the audit policy level settings.

> - The `_aud-audit-data-value` table optionally stores additional details for modified fields showing the new and, optionally, the old values. The level of detail recorded (for example, simply the fact that something happened, the new value of modified fields, both old and new values, or a stream of an audited stream’s values) is driven by the table policy. Records are created in this child table only if the policy is set to record one record per field.

> - The `_client-session` table optionally records additional session information such as the authentication domain and client name.

> - The `_db-detail` table provides a description of the database for which the audit data exists, as well as the passkey used to optionally seal the audit data records.

> - The `_aud-event` table provides additional audit event information that is useful for reporting, rather than simply showing the integer event ID. The event definition itself determines the structure of the information in the other tables.

> - A Foreign Key is denoted by the abbreviation FK.

> - The fields above the line are the Primary Key fields, in order.

> - IEx.y denotes an Inversion Entry (nonunique alternate index) key with the first number (x) being the index number and the second number (y) being the position of the field within the index.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095