Target Design
Append Utility Columns
Use this
To access this page:
- Select Advanced Data Migration in the Navigation pane.
- Select Design in the Context bar.
- 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:
NOTE: Natural fields cannot have a visibility set to None. |
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. |