Advanced Mapping Definition Subtask

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 the Cobra Key Fields field, the Advanced Definition for WBS will display on the selection button.

Advanced Mapping Definition

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

Field Description
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 total 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.

Field Description
Order Number

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

Field

Enter, or click binoculars.gif 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 to be 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

Subtask Description
Result Test Click this link to open the Result Test subtask and view sample data that satisfy the specified criteria in the Advanced Mapping Definition Details table window.