Domains, Attributes and Glossary

Domains

Domains are a way of defining a data type, length and format for the same data item that can exists across different locations (Subject Areas / Entities). Even though these data items exist in different locations, they should adhere to the same format.

Example of a Domain would be a ‘Postcode’. A Postcode column/attribute may exist in both a Customer Table and a Suppliers table but the would always be in the same format.

Domains would be particularly useful in large data structures. If you have several instances of the Postcode within several tables in your data , they could all be attached to a single Domain. All the checks on the several instances of the postcode can be easily controlled by simply adjusting the Postcode Domain accordingly.

To attach all data items to a single Domain, you need to create a new Domain, then attach the Attribute associated that data item to the Domain.

To create a new Domain go to (Data Dictionary > Domains ).You will be presented with the window below that contains a list of all Domains already created.

Click on the ‘Create Domain’ button and the window below will appear

• Tags: Attach tag (to be used in Tag search).
• Name: Domain name
• Description: Domain description
• Data Type: Data type assigned to Domain.(Varchar, Int , Big Int etc.)
• Length: Maximum string length assigned to Domain.
• Format: Pattern of string set for Domain. Example the format of a Postcode Domain would be ‘aa99 9aa’.

To attach the Attribute to Domain. You need to go into the settings of that particular attribute via the Attributes screen (Data Dictionary > Attributes). Using the ‘Billing Post Code’ Attribute highlighted in the screen below for reference, you need to edit the settings of the Attribute.

In the Attribute settings window below, on the ‘Domain’ section highlighted , select the Domain that you would like to attach to the Attribute.

Attributes

Attributes are the lowest level of logical definitions within your data structures. They are the logical definition of data objects within an Entity. For example, a ‘Person’ entity may contain entries such as ‘Title’, 'First Name', ‘Surname’. These logical definitions can be linked to physical data columns, to allow all business users to find real data using non-technical language.

To create a new Attribute go to (Data Dictionary > Attributes ).You will be presented with the window below that contains a list of all Attributes already created.

When you click on a specific Attribute in the attributes window, 3 more windows will appear.

1. Columns Window (displays the columns linked to that Attribute)
   

2. Report Fields Window (Displays the report fields linked to the Attribute)
   

3. Rules window (Displays rules attached to the Attribute)
   

Click on the ‘Create Attribute’ button in the Attributes window and the window will appear.

• Tags: Attach tag (to be used in Tag search).
• Name: Attribute Name.
• Owner: Person/User assigned ownership of Attribute.
• Subject Area: The Subject Area the attribute belongs to.
• Entity: The Entity the attribute belongs to.
• Description: Attribute Description.
• Usage: How is the attribute used within the organization, who its used by and what business processes it is used in.
• Risk Level: (Low, Medium, High, Critical). This is based on implications of a data breach on the Attribute and driven out of a data risk assessment.
• Risk Assessment Status: (Not Started, In Progress, Completed, Halted, Not required ).Indicates whether a risk assessment has been undertaken (linked to the ‘Data Risk Level’)
• Security Rating: (Low, Medium, High) Based on the implications of a data breach on the Attribute, consider the level of security measures that should be applied when interacting with that particular Attribute. Example Attributes linked to columns that contain sensitive personal data, HR Data and Financial data will likely be set to ‘High’.
• Mandatory: Is the attribute linked to Mandatory field that always has to be populated.
• Key: Is the Attribute linked to a column that is identified as the Primary Key or Foreign Key.
• Derived: Is the value held by the attribute created/based on the values of other attributes. (Example Attributes created as a result of IF or Case statements).
• Domain: The Domain attached to the attribute.
• Data type: Data type assigned to attribute.
• Format: Data format of attribute.
• Length: Number of characters in attribute.

Glossary

A business Glossary is a key artifact that a data governance programme produces to demonstrate that the organization has an agreed upon understanding of key business concepts, business terms and the relationships between them.

Go to (Data Dictionary > Glossary) to access the list of Glossary items created so far.

Click on ‘Add Item’ to create a new Glossary Item in the window below.

• Name: Name of Glossary Item
• Description: Description of Glossary Item