Reference data are data that define the set of permissible values to be used by other data fields. Reference data gain in value when they are widely re-used and widely referenced. Typically, they do not change overly much in terms of definition, apart from occasional revisions. Reference data are often defined by standards organizations, such as country codes as defined in ISO 3166-1.
Examples of reference data include:
- Units of measurement
- Country codes
- Corporate codes
- Fixed conversion rates e.g., weight, temperature, and length
- Calendar structure and constraints
Reference data management
As any other data, if it is not managed, it can lead to poor quality data. Here are some best practices to follow:
- Formalize the reference data management
- Use external reference data as much as possible
- Govern the reference data specific to your enterprise
- Manage reference data at enterprise level
- Version control your reference data
Differences with master data
Reference data should be distinguished from master data, which represent key business entities such as customers and materials in all their necessary detail (e.g., for customers: number, name, address, and date of account creation). In contrast, reference data usually consist only of a list of permissible values and attached textual descriptions. A further difference between reference data and master data is that a change to the reference data values may require an associated change in business process to support the change; a change in master data will always be managed as part of existing business processes. For example, adding a new customer or sales product is part of the standard business process. However, adding a new product classification (e.g. restricted sales item) or a new customer type (e.g. gold level customer) will result in a modification to the business processes to manage those items.
- ^“IBM Redbooks | Reference Data Management”. www.redbooks.ibm.com. 2013-05-16. Retrieved 2015-12-09.
- ^“Reference Data Management and Master Data: Are they Related ? (Oracle Master Data Management)”. blogs.oracle.com. Archived from the original on 2015-10-11. Retrieved 2015-12-09.
- ^“5 best practices for managing reference data – LightsOnData”. LightsOnData. 2018-07-25. Retrieved 2018-08-17.
Ofer Abarbanel is a 25 year securities lending broker and expert who has advised many Israeli regulators, among them the Israel Tax Authority, with respect to stock loans, repurchase agreements and credit derivatives. Founder TBIL.co STATX Fund.