It makes sense to have multiple tables in each message's
table grammar, rather than having one monolithic table
for each message. This makes mapping easier since you can
re-use mappings from message to message.
Multiple IDs Per Patient
One question that comes up quite often is
how to deal with patients that have multiple IDs. This situation arises
frequently within the US health system because different independent hospitals that might have
treated the same patient are amalgamated into a larger group. The CDC also
has to deal with this problem since they collect patient data from a large
number of different organizations.
A good technique to deal with this problem is to create a Patient ID aliases
table in the VMD file. This maps alternate IDs to the specific patient in
your system. In this way Iguana can support many patient IDs for each
patient.