Modeling considerations for lookup values

Edit online

Lookup values are a set of predetermined valid values or a rule-based list of valid values for a particular attribute.

Lookup values can be shown as values list in the UI. For example, lookup values might provide a the list of valid countries, suppliers, or brands. Use the following scenarios to determine the correct approach to modelling lookup values:
Scenario Data modeling main points

Scenario 1:
< 20 values

No search by primary key

Single attribute value selection

 Use a string enumeration or a string enumeration rule.


Scenario 2:
> 20 values

Search by primary key

Before you make a selection,
refer to other attribute values.

  • Use a lookup table.
  • Create multiple attributes in a lookup spec.
  • Use an NPA attribute to show lookup value descriptions on UI