Managing Mapping Function

Mapping functions include two types:

• Range – allows you to translate a value (e.g., revenue) into a coded field that represents ranges of values. For example, if the source file quotes revenue in dollars, then you can map this to a coded field that represents a range of revenue.
• Value – allows a mapping of a specific value into another specific value. For example, the source data file may use the code “H” for home address type whereas the system uses “HOME.”

The value mapping provides the following options:

• For delimited source files, you can map the field sequence in the source file to a specific column in the Marketing Prospect database table.
• For a fixed length record format, you can map the start and end position in the source record to a specific column in the Prospect table.
• For a specific source field value, you can map this value to another specific value.
• For any column in the Prospect table, you map it to a fixed value.

If no Mapping Functions exist, you can create one from the Manage Mapping Function page:

1. From the left navigation, select Manage Mapping Function.
   The Manage Mapping Function page displays, as shown below.
   
2. Select +New Mapping Function.
   The Add Mapping Function page displays. 
   
3. Enter the Mapping Function ID.
4. Select the Mapping Function Type from the drop-down.
5. If necessary, set the Active toggle to NO.
6. Select the Subsystem and Type of codes that will be mapped.
7. Enter the Description.
8. Select Save.
9. Within the Mapping Values section, perform the following:
   1. Select +New Mapping Value.
      The Add Mapping Value section displays.
      
   2. If you selected “Range” for the Mapping Function Type, then enter values in the Source Low Value and Source High Value fields.
   3. If you selected “Value” for the Mapping Function Type, then enter the specific value in the Source Data Value field.
   4. Select the appropriate value from the Mapped to this Value drop-down.
   5. Select Save.
      The mapping value is added to the grid. Continue with the steps above to add additional mapping values as necessary.

Screen Element	Description
Mapping Function ID	Text box. Mapping Function ID is user-defined and can be reused across multiple lists. Enter the Map Function code in the first text box and the long name in the second text box. Mapping helps determine what should be done with a specific field in the source file when it is mapped to target column.
Active	Toggle. When set to YES, indicates this mapping function is active.
Mapping Function Type	Drop-down. This controls the behavior of the mapping function. The table options differ depending on the Function Type selected. Mapping functions include two types: Range – allows you to translate a value (e.g., revenue) into a coded field that represents ranges of values. Value – allows a mapping of a specific value into another specific value. For example, the source data file may use the code “H” for home address type whereas the system uses “HOME.” Values in the drop-down are populated based on the fixed codes defined for the MKT "MAP_FUNCTION_TYPE" system type.
Subsystem	Drop-down. The subsystem of the code being mapped.
Type	Drop-down. The code type defined under the subsystem for a mapping function.
Description.	Text box. The description of the mapping function.
Source Low Value	Field. Only displays when “Range” is selected as the Mapping Function Type. The data value in the source data file is evaluated against this low value and a code is substituted.
Source High Value	Field. Only displays when “Range” is selected as the Mapping Function Type. The data value in the source data file is evaluated against this high value and a code is substituted.
Source Data Value	Field. The specific source value. Only displays when "Value" is selected as the Mapping Function Type.
Mapped to this Value	Drop-down. Search for the appropriate field value to which the source should be linked.