ADVANCED MAPPING DEFINITION

Use this subtask to specify more options for defining the key fields that map from Cobra to Costpoint. This subtask changes to match the Cobra key fields in the Define Mapping table window. For example, if WBS is specified in Cobra Key Fields field, the Advanced Definition for WBS will appear on the selection button.

Advanced Mapping Definition

Use the field and options in this block to specify prefix or literal preferences for the results data.

Prefix/Literal

Enter a prefix or literal. The value in this field is added to the fields concatenated below. If no fields are expressed, then this effectively becomes the charge that is assigned to all records that fit the rule.

Use Part of the Above Result

Select this check box to choose a substring from the result of the advanced mapping definitions.

Starting From Position

Enter a starting point for a substring of the result.

Ending Position

Enter an ending point for the substring within the result.

Length of Final Result

This field displays the possible to tal length of the result. If the Use Part of the Above Result check box is cleared, you can enter a value in this field. The data values are truncated at this length.

Advanced Mapping Definition Details

Use this table window to specify more detailed options for defining key fields.

Order

Enter the order in which this row's information is placed into the result.

Field

Enter, or click to select, a column name.

Description

This field displays the descriptive name of the selected Field.

Table

This field displays the table related to the selected Field.

Starting Character Position

Enter a value that designates the starting point you want to use when selecting a potential subset of the selected field's data.

Ending Character Position

Enter a value that designates the ending point you want to use when selecting a potential subset of the selected field's data.

Characters Added to the End

Enter up to four characters that is added at the end of the filed. The primary use of this field is to be a one character delimiter between field data values.

Subtask