Regent Award Data Model Entity Relationship Diagram (ERD)

Owned by Katie Macpherson (Deactivated)
Last updated: Apr 23, 2019Version comment

Data Model

The entities in the Regent Award Data View Data Model share a similar naming convention to the entities in the actual Regent Award Data Model. 

We have used the actual entity names in the ERD Diagram below. Understanding which data view the entity corresponds too should be straightforward. 

For example

  • The entity 'AcademicPlan' describes the type of attributes and relationships you will see in the [dbo].[dataExtract_AcademicPlan_View_v001] table
  • The entity 'AcademicYear' describes the type of attributes and relationships you will see in the [dbo].[dataExtract_AcademicYear_View_v001] table

ERD Diagram

This is a version 001 Conceptual Overview of core Academic Structure and Awarding entities. 

You can view directly here or download and use the Microsoft Visio 2016 viewer - https://www.microsoft.com/en-us/download/details.aspx?id=51188


* The diagram intentionally does not include most of the columns so as not to distract from the high level relationships and concepts being presented. Customers may use the Regent Award Data View Data Dictionary to determine the columns available in the various data views.