Table - Table Field

Select Admin Menu > Table and navigate to the Table Field tab to define the fields whose changes should be audited and to override a field's label on a specific table (note, you can also maintain a subset of this information in the grid on the Main tab).

Description of Page

Many fields on this page are protected as only the product development group may change them. The following describes fields you may change for records that are part of the base product. Fields containing information that may be of interest are also described.

Turn on Audit Delete if an audit record should be stored for this field when a row is deleted. Refer to How To Enable Auditing for more information.

Turn on Audit Insert if an audit record should be stored for this field when a row is added. Refer to How To Enable Auditing for more information.

Turn on Audit Update if an audit record should be stored for this field when it is changed. Refer to How To Enable Auditing for more information.

The Label column only contains a value if the base-product indicates a value other than the field's label should be shown on the various pages in the system. The field's label is shown above, adjacent to the field's code.

The Override Label is provided in case you want to override the base-package's label. If specified, it will be displayed throughout the application.

Note: Note. If you want the Override Label to be shown in the data dictionary, you must regenerate the data dictionary.

Special Notes contains any notes or special information about the table.

Field Usage defines how the field is used in the application. In the current release, only tables that are part of Oracle Utilities Business Intelligence make use of this field.