# Reference Data

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

**Field:** Data Engineering  
**Category:** Governance & Quality  
**Also known as:** Lookup Data, Code List, Reference Data Management

## Think of it like

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

## 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.

## 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.

## 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.

## Three principles

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

## Related terms

- [Master Data Management (MDM)](https://learn.benibix.com/term/data/master-data-management)
- [Data Consistency](https://learn.benibix.com/term/data/data-consistency)
- [Data Steward](https://learn.benibix.com/term/data/data-steward)
- [Data Dictionary](https://learn.benibix.com/term/data/data-dictionary)
- [Foreign Key](https://learn.benibix.com/term/development/foreign-key)
- [Data Enrichment](https://learn.benibix.com/term/data/data-enrichment)

## Told apart from

- [Reference Data vs Master Data](https://learn.benibix.com/compare/reference-data-vs-master-data): People think reference data and master data are the same thing. Reference data is a short list of allowed codes, like country codes. It changes a few times a year. Master data is the records of the things a business deals with, like customers and products. It changes every day, and it uses the codes from the reference list.

![On the left, a highlighted list of country codes: DE Germany, JP Japan, US United States. Arrows from three boxes, customers, orders and suppliers, point at it. On the right, a master data box holds one record per customer, each with a country code.](https://learn.benibix.com/diagrams/dat2-reference-data.svg)

---

Source: https://learn.benibix.com/term/data/reference-data
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-18
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
