Map Workbook

This workbook maps the column names used in the configuration data worksheets to the column names in the database tables. It can be thought of as the glue between the database table and the configuration worksheet.

Changing a map workbook most often requires that corresponding changes be made in the associated configuration data workbook.

Modifying the map workbooks that do not pertain to Business Rules is not recommended. The preferred approach is to create a new map to facilitate the change. If a non-Business Rules map workbook must be changed, consult IBM® Support. The map workbooks for Business Rules are expected to be updated to accommodate customer specific tables.

Worksheets

A map workbook contains a worksheet for each of the database tables for which column names are mapped. The names of the map worksheets are specified in the worksheets in the cross reference workbook. For more information, see Cross Reference Workbook.

The following section describes the format of the worksheets contained in the map workbook.

Worksheet Format

Each map worksheet typically contains the columns for one database table. The worksheet has a column for each of the database table columns for which configuration data can be imported, exported, or validated.

Table 1 shows all of the rows that can be in a map worksheet for each spreadsheet column and the types of data contained within. Most map worksheets contain only the first two rows.

Table 1. Map Worksheet Row Definitions

Row	Description
1	The attribute name. It is a more descriptive name for the database column. For example, a database column called "PID" can be associated to the attribute name "Partner Id".
2	The database column name, alias column name, or complex field select. For a description, see Complex Field Select.
3 (optional)	When performing data import, this row is used to identify a secondary table to be loaded. When performing data validation, this row lists the names of the classes associated with the Control Center forms.
4 (optional)	When performing data validation, this row lists the names of the fields on the Control Center forms.