Data dictionary
A data dictionary is a document that lists each data field in a system with its meaning, format, allowed values, owner and source.
What it means
Without one, "customer" may mean the buyer in one report and the bill-to party in another, and "date" may be order date or dispatch date. The dictionary fixes this by writing down what each field means, what values are valid and who maintains it. It is the reference that analysts, accountants and developers all share.
Example
An auto parts maker in Pune lists "lead time" as days from purchase order date to goods receipt date, in whole days, owned by purchase. Two reports that gave different averages now agree.
Records and checks
- Record field name, meaning, type, allowed values, owner and example.
- Verify that live data actually follows the stated rules.
- The data owner reviews it whenever a field is added or changed.
Common mistakes
- Writing it once for a project and never updating it.
- Describing fields in technical terms that business users cannot follow.
Did not find your answer?Message the lamp team on WhatsApp. Ask about setup, your records, or anything we have not covered here.Ask us on WhatsApp →