Target Design

Append Utility Columns

To access this page:

  1. Select Advanced Data Migration in the Navigation pane.
  2. Select Design in the Context bar.
  3. Select Configuration > Append Utility Columns in the Navigation pane.

Field

Description

COLUMN

Displays the name of the column to append to the table.

DESCRIPTION

Displays a user-friendly description of the column. When the Append Utility columns are added to the target table, the description is added in the column Display Name.

PRIORITY

Displays the order the field should be appended to the table.

ACTIVE

If checked, the column is active and will be appended to the Target and or Source table as configured by the TARGET APPEND and SOURCE APPEND fields.

This check box is checked by default.

KEY

If checked, the column is appended to the table as a key field.

This check box is unchecked by default.

DATA TYPE

Displays the column’s data type, such as NVARCHAR or DECIMAL.

LENGTH

Displays the maximum number of characters that can be stored in the field.

DECIMALS

Displays the number of decimal places allowed in the column.

NOTE: This field is required if the column’s data type is DECIMAL.

DEFAULT VALUE

Displays the default value added on the Utility Field Defaults page.

Refer to Add Utility Field Defaults for more information.

VISIBILITY

Displays how the appended utility field is used in mapping and whether it displays on the Field Mappings page in Map.

Values are:

  • Both—mapping for source and target
  • None—no mapping required for the field
  • NOTE: Natural fields cannot have a visibility set to None.

  • Source—source only mapping
  • Target—target only mapping

TARGET APPEND

If checked, the column will be appended to all target tables.

This check box is checked by default.

NOTE: In addition, the ACTIVE field must be enabled in order for the column to be appended.

SOURCE APPEND

If checked, the column will be appended to all source tables.

This check box is checked by default.

NOTE: In addition, the ACTIVE field must be enabled in order for the column to be appended.

SYSTEM SUPPLIED

If checked, this content is installed with the Stewardship Tier and cannot be edited. If unchecked, the content was added by a user or process. NOTE: This is a display-only check box. It cannot be updated.