🛡️Reference Data
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
Common mistake
Key takeaways
- 1Short list. A few to a few hundred values.
- 2Shared. Many tables point at one copy.
- 3Slow to change. Updated rarely, and on purpose.