You can edit the mappings for each table in one of three ways:

• Selecting the Edit mappings option from table context menu;
• Clicking the Edit Mappings button in the Table Grammar panel; or
• Double-clicking the table in the Table Grammar panel.

Performing any of the three options above displays the Mapping window, as shown below:

Mapping Window

The left pane of the Mapping window contains columns of the table, otherwise known as the internal representation of the data as seen by the application. The right pane of the Mapping window contains the segments and segment fields under the table's grammar root.

To map a segment's sub-field to the column in the table:

• Locate a leaf data node by expanding a segment and a composite.
• Then drag the field from the right pane to the appropriate column.

There are 2 restrictions that apply:

• You cannot map a composite to a column in the table. You must map each sub-field of the composite types individually, or use Python scripting. For an example of using Python to map data, see Mapping Multiple Fields of an Incoming HL7 Message to a Single Table Column.
• You cannot map a sub-field to a column if they have different data types (e.g. you cannot map an integer sub-field to a string sub-field).

	If you need to map a sub-field to a column with a different data type, you need to edit the segment and/or composite definition of the applicable field and then change its data type to allow the mapping to occur.