Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

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 straighforward. 

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


  • No labels