Skip to content
BENIBIX Learn

Data Dictionary

Also known as Column Dictionary, Field Dictionary

A list of each column in a table and what it means.

Think of it like

It is like the key on a map. It tells you what each little sign means.

Example

The dictionary says amount is in cents, not euros. Emma reads it and divides by 100 before building her chart.

Why it matters

One misread unit or code can make a report off by 100 times. The dictionary prevents that.

Definition

A data dictionary lists every column in a set of tables, so people know what each one holds. For each one, it gives the name, the type and what it means. It also lists the values that are allowed, the units and whether a blank is fine. Analysts read it before they use a table they do not know. A business glossary defines words. A data dictionary defines columns.
The column list on the card is the data dictionary. It gives each column with its type and meaning.

Common mistake

Writing it once in a spreadsheet and never again. Keep it next to the code, so it changes when the table does.

Key takeaways

  1. 1
    Every column. Name, type and meaning.
  2. 2
    Rules and units. Allowed values and units.
  3. 3
    Kept current. Updated when the table changes.

Compare