Master Data Management
Audit Table Column Registration
To access this page:
- Click Master Data Management > Design in the Navigation pane.
- Click Vertical View for a category.
- Click the Rules and Actions tab.
- Click the Table Registration icon.
- Click the Columns icon for a table.
Field |
Description |
COLUMN NAME |
Displays the technical field name of the column to be audited. NOTE: If the table to which the column belongs is not enabled for auditing (i.e., the ENABLED check box is not selected for the table on the Audit Table Registration page) no data displays on this page. |
ENABLED |
If enabled, data in that column is audited. If disabled, data is not audited. |
DISPLAY COLUMN NAME |
Displays the column description. |
PRIMARY KEY |
If checked, the column is the key field on the table, or is part of the multi-part key. This column displays by default in the Key to Record field on the Review Role Audit Details page when the check box is checked. If unchecked, the Key to Record field does not display on the Review Role Audit Detail page. |
INCLUDE IN RECORD KEY |
If enabled, the column name is included, along with the key field(s), in the Key to Record field on the Review Role Audit Details page. If disabled the column name does not display. NOTE: Key fields are not affected by this setting, with the exception of the RequestID. Key fields display in the Key to Record field, even if this check box is disabled. However, the display of the RequestID column can be controlled using this option. For example, the user disables this option for the key fields DATE_FROM and RequestID. In the Key to Record field, the DATE_FROM field still displays. The RequestID field does not. |