iNTERFACEWARE Products Manual > Learning Center > Tutorials and Sample Scenarios > Working With a Database > HL7 to Database > Step 6 - One to Many Relationships > Setting the Grammar Root and Mapping the Data |
![]() ![]() |
Looking for Iguana v.5 or v.6? Learn More or see the Help Center.
The next step is to specify the grammar root and the table mappings for the two tables that you have just added to the table grammar. To set up the grammar root and mappings for the Patient table:
![]() PatientTable Already Mapped To set the grammar root for the PatientObservation table:
Next, define the mappings for the PatientObservation table:
When you have finished the mappings, the PatientObservation table looks like this: ![]() Mapping the PatientObservation Table Note that the PID field is unmapped. This field will contain the patient ID, which is contained in the PID segment. In the next section, you will see how to use Python to copy this patient ID from the PID segment to this field. |