iNTERFACEWARE Products Manual > Learning Center > Tutorials and Sample Scenarios > Working With a Database > HL7 to Database > Step 6 - One to Many Relationships > Setting Up the Table Grammar |
|
Looking for Iguana v.5 or v.6? Learn More or see the Help Center.
Since you will be mapping data out of the OBR segment, you will need to create a new table to map this data to. To create a new table:
Every row in this PatientObservation table will contain data from a single OBR segment. However, you will need to be able to relate each of these rows back to the patient specified in the single row of the Patient table. To do this, define the table as shown below. Be sure to include the PID column (the key of the Patient table). You will notice that the primary key for the PatientObservation table is a combination of the ID and PID fields. Finally, add the Patient and PatientObservation tables to the Table Grammar panel: The error icons, shown in the Table Grammar panel, indicate that the grammar roots have not been set. You will set the grammar roots in the next section.
|