Mapping Table Descriptors Manually

If you want to map a Table Descriptor to a Table instance that has a different name, you must map it manually. You can also use this method to remap a Table Descriptor that is already mapped.

To map a Table Descriptor to a Table instance manually, go to the main Program screen, Table Descriptors subtab, and do the following:

1. Click the icon in the Table Descriptor's Mapping column. The system opens the Mapping screen with the Table Descriptor's name already entered in either the From or To column, depending on whether it is a target or a source Table Descriptor, respectively.
2. Click Update. Several fields become modifiable.
3. Click the Search icon next to the Map to Table Instance field. The system opens the Search screen.
4. Select the Domain, Application Area, and Work Area of the Table instance to which you want to map.
   • Select the Table instance's Domain from the Domain drop-down list.
   • Select the Table instance's Application Area from the Application Area drop-down list. The choices are limited to Application Areas contained in the Domain you selected.
   • If you know the exact name or version label of the Table instance you want, select either Name or Version Label from the Search By drop-down list and enter the name or version label in the blank field.
5. Click Go. The system displays all the Table instances that meet the criteria, and for which you have View privileges.
   You cannot map to a Table instance while its source Table definition is checked out. The system displays Table instances whose source Table definition is currently checked out as grayed out. You can look at the Table definition to see who has it checked out.
6. Click the Quick Select icon for the Table instance you want to map.
   The system enters the name of the Table instance you selected and automatically tries to map it to the Table Descriptor. The system displays any Columns it finds that match a Column in the Table Descriptor across from the matching Column.

   If the system does not find a match, it populates a drop-down list for each Table instance Column that contains the names of all the Table instance Columns.

7. For each Column of the Table instance, choose the Column from the drop-down list that you want to map to the Table Descriptor Column displayed on the same row.
   Alternatively, you can map to a constant (see Mapping Columns to Constants) or convert to a different data type (see Mapping Columns of Different Data Types and Lengths) you can enter that information in the Default Value or Format String field, respectively.
8. Click Apply. The system saves the mapping and returns you to the Program screen.