Target Design

Add Utility Field Defaults

Utility fields can be appended to all Target and/or Source tables automatically.

A Utility field does not exist in the Target system, but is referenced by rules and reports in Transform.

A Designer can add default values on the Utility Field Defaults page that can be selected for a column on the Append Utility Columns page.

NOTE: Some default values are added by the system at installation and cannot be edited or deleted. These values can be used to enable or disable a setting, display the current date and time, add a unique identifier, or use a static value.

The options added on this page are available to be selected in the DEFAULT VALUE list box and can be assigned to Utility columns on the Append Utility Columns page. Refer to Append Utility Columns to All Tables for more information.

To add a default value in Target Design:

  1. Select Configuration > Utility Field Defaults in the Navigation pane.

  2. Click Add.

    View the field descriptions for the Utility Field Defaults page

  3. Enter a name in the DEFAULT VALUE field.

    NOTE: This name displays in the DEFAULT VALUE list box on the Append Utility Column page.

  4. Enter a default value in the DEFAULT VALUE field.
  5. Enter a description of the default in the DESCRIPTION field.
  6. Click Save.