Skip to content
BENIBIX Learn

Reference Data

Data🛡️ Governance & QualityData Governance

Also known as Lookup Data, Code List, Reference Data Management

A short shared list of allowed codes, like country codes. It rarely changes.

Think of it like

It is like the colours in a crayon box. Everyone picks from the same short set.

Example

A shop keeps one list of order states: placed, paid, shipped and returned. Every system uses it. So one report can count shipped orders across all of them.

Why it matters

If two systems spell a code two ways, their numbers will not add up. One shared list stops that.

Definition

Reference data is a short, fixed list of allowed values that other data points to. Country codes, currency codes and order status values are all reference data. It changes rarely, a few times a year at most. Many tables share one list, so they all use the same codes. Master data, like customers and products, uses these codes in its own records.
Three tables point at one short list. The customer records on the right are master data, and they use the codes.

Common mistake

Letting each app keep its own copy of the list. The copies drift, and soon UK and GB both mean the same country.

Key takeaways

  1. 1
    Short list. A few to a few hundred values.
  2. 2
    Shared. Many tables point at one copy.
  3. 3
    Slow to change. Updated rarely, and on purpose.

Compare