Master Data Tables are those data tables that are the core focus of a entitiy’s Master Data Management Strategy. Master Data Tables are labelled as such and are the opposite of Transactional Data Tables. And where Transactional tables contain content that describes the characteristics of events and transactions, Master Data Tables describe the characteristics of parties to the transactions. Where Transactional Tables tend to have a large number of records, Master Data Tables tend to have far fewer records. This makes sense as one employee will earn multiple paychecks, one vendor will sell us multiple goods and a single customer may make multiple purchases from us.
In most enterprises, there are five key Master Tables as represented in the image below.
In each of these Master Tables, there is a key field which is the unique identifier of the party that is the object/subject/focus of all of the other content in that table. In each of the five stacks – or data families in the image above – we also see samples of children, grand-children and great-grand-children of the parents of the family.