The next step is to set up the mappings from the table columns to the message fields.

To map the data:

• In the Workspace, in the PatientRegister message definition, double-click Message Grammar. The Message Grammar window appears.
• In the Table Grammar panel, double-click PatientRegistration. An Information dialog window appears, reminding you that you need to select a grammar root.
• Click OK. The Grammar Root Selection window appears.

Grammar Root Selection Window

• Select Message as the grammar root of the message, and click OK. Selecting Message as the grammar root ensures that you can map from the table to any fields in the HL7 message.

In the Table Mapping window that appears, the left pane displays the table you defined earlier plus a new column called Mapping. The right pane displays the segments that you have included in the message's segment grammar. The next step is to map fields in the HL7 segments to entries in your table. To do this, drag fields from the segments to the Mapping column of the table:

• In the right pane of the Table Mapping window, expand the PID segment, and expand field 3 (Patient Identifier List).
• Drag the 1 - ID Number field to the PatientId row of the table.
• Expand field 5 (Patient Name) of the PID segment, and drag 2 - Given Name to the FirstName row of the table.
• Expand subfield 1 of field 5 (Family Name), and drag its first subfield, 1 - Surname, to the Surname row of the table.
• Drag field 7 (Date/Time of Birth) of the PID segment to the DOB row of the table. Note that this field is of type DateTime.
• Drag field 19 of the PID segment, 19 - SSN Number - Patient, to the SSN row of the table.

When you have finished the table mappings, the Table Mapping window should look like this:

Completed Table Mappings

• Save the VMD file when you are finished making the changes.

This definition file is now ready to translate data in the PatientRegistration database table into ADT^A04 HL7 messages.

	Generate Other Kinds of Messages If you want to generate other kinds of messages using your channel's From Database component, you can add other message definitions, segments and tables to this VMD file. Did You Know? Chameleon's Transformation Window is useful for testing mappings and other areas of your message generation VMD file. For more information, see Using the Transformation Window For Testing Mappings, Outbound Messages and Outbound Python Scripts.