1. Auditing Administration Including 21 CFR Part 11 Administration Guide
  2. Audit Table Setup

Audit Table Setup

You use the Configuration Application (P9500001) to select the table that you want to audit. After selecting a table, JD Edwards EnterpriseOne launches Table Design Aid (TDA). In TDA, you select the actual columns in the table that you want to audit.

When the auditing function in JD Edwards EnterpriseOne is turned on, the system records changes, additions, and deletions to the data in these columns in an audit table (shadow table) to provide a tracking history. An audit table contains the columns used as the primary key of the original table along with the columns that you define to trigger an audit. In addition, you can select columns for recording. Recorded columns do not trigger an audit, but appear in an audit table along with the other columns that trigger an audit.

Every time a change is made to an audited column in the original table (Fxxxx), the audit table (Axxxx) records this information:

  • The field that was changed.

  • The previous value in the field.

  • The new value in the field.

  • The date and time of the change.

  • Any other fields in the table that were selected for auditing.

  • Any other fields in the table that were selected for recording.

  • The form, application, and version name used to make the change.

  • The user ID and internet protocol (IP) address of the person who made the change.

The auditing function can be turned on or off for each specific table. Even the action of turning the auditing function on and off is recorded in a table to provide a history of the audit tables.