Lookup table records typically have a one-to-one relationship with external system codes. That is, each lookup table record maps to one external system code. However, sometimes multiple records map to one external system code. In the following example from the ACARA language code list, multiple English dialects map to one external system code (1201 - English).
...