Blog

What is Reference Data?

  • 18 January 2022
  • 1 reply
  • 78 views

Userlevel 5
Badge +9

Simply explained, reference data is data that serves as the model for all other data throughout an organization. It is contained within tables and databases, which help bridge one source system to another, and provides the foundation for the entire data architecture. Together with the initiative set forth by the overall data governance program, reference data maintains consistent data across all departments and allows for source system inter-communication.

 

Reference Data tables are entities that compose the framework of the reference data architecture, providing lists of values for each department and the company as a whole. They contain either the backbone data in its base form (central authority) or data that is a derivative of the base-form data (tables used in the various branch systems throughout the enterprise).

Each department within a company works with table data fields in a particular format that suits their processes. Although department A might deal with the same product as department B, the alphanumeric codes or text that represents that product may differ between the two departments. To allow these two separate systems to operate according to their own lists of data, both systems are also connected to the central authority, which drives the same authenticating information to both departments and confirms the same product is being referenced.


1 reply

Badge

Very well explained @DannyRyan ! Another simpler version could be: 

 

Reference Data: A special type of master data used to categorize other data or used to relate data to information beyond the boundaries of the enterprise. Reference data can be shared across master or transactional data objects (e.g. countries, currencies, time zones, payment terms, etc.)

Reply