Advanced Mapping Definition for Employee Labor Subtask
Use this subtask to create more options for defining the key fields that map employee labor from Cobra to Costpoint.
Advanced Mapping Definition
Use the fields in this block to specify advanced mapping definitions for employee labor accounts.
Field | Description |
---|---|
For |
This field always displays Employee Labor. |
Prefix/Literal |
Enter the text you want added to the beginning of the fields concatenated below. If no fields are expressed, then this effectively becomes the BE 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. Enter the substrings in the Starting From Position and Ending Position fields. |
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 you did not select the Use Part of the Above Result check box, you can modify this field. The data values are truncated at this length. |
Advanced Mapping Definition Details
Use this table window to set more detailed specifications.
Field | Description |
---|---|
Order Number |
This field displays the order in which the row's information is placed into the result. |
Field |
Enter, or click to select, a field. |
Description |
This field displays the descriptive name for the selected Field. |
Table |
This field displays the table related to the selected Field. |
Starting Character Position |
Enter the starting point for use when selecting a potential subset of the selected field's data. |
Ending Character Position |
Enter the ending point for use when selecting a potential subset of the selected field's data. |
Characters Added to the End |
Enter characters that are added to the end of the field. The primary use for this field is to be a one character delimiter between the 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. |
- Related Topics:
- Result Test Subtask
Use this subtask to view sample data result that satisfy the criteria specified in the Advanced Mapping Definition Details table window.