Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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


View file
nameRegent Conceptual ERD - Academic Plan - V1.vsdx
height250