University of Illinois System

Data Models

The logical data model shows a high-level business view of the data. It shows the actual tables and views that contain the information in the Data Warehouse database and how they are related to each other. Business names are used instead of the physical table names, for example "Person History" instead of "T_PERS_HIST". The logical model is very useful for determining what data is available.

The physical data model shows the actual representation of the physical tables and views and relationships in the database. Instead of business names, the actual physical table names are used, for example "T_PERS_HIST" instead of "Person History". Because it shows the actual table names, the physical model is a key reference when writing queries directly against the database.

Some data elements available in the Data Warehouse and shown on the models may not be available through the Business Objects universes, but all are available via the Data Warehouse. Please contact us if you discover a data element listed in the data model that you would like to see added to the Business Objects universes.

 


Finance Data Models

DATA UPDATED LOGICAL MODEL(S) PHYSICAL MODEL(S)
DM Expense Trends 8/20/10 Single-Page Format Single-Page Format
DM Finance Grants 8/20/10 Single-Page Format Single-Page Format
DM My UI Finance Reports 8/8/22 Multi-Page Format Multi-Page Format
EDW Archibus 1/3/24 Single-Page Format Single-Page Format
EDW Capital Programs 5/19/23 Single-Page Format Single-Page Format
EDW Finance 11/8/21 Multi-Page Format Multi-Page Format
myProposals (Kuali Coeus) 8/8/22 Multi-Page Format  Multi-Page Format
Purchasing 1/3/24 Single-Page Format Single-Page Format
University Contracts 1/21/22 Single-Page Format Single-Page Format 

Human Resources Data Models

DATA UPDATED LOGICAL MODEL(S) PHYSICAL MODEL(S)
DC HireTouch 6/19/20 Single-Page Format Single-Page Format
DC PRMS 9/18/23 Single-Page Format Single-Page Format
DM Headcount 5/19/23 Single-Page Format Single-Page Format
DM HR Payroll Reconciliation 7/17/15 Single-Page Format Single-Page Format
EDW Bio-Demo 5/19/23 Single-Page Format Single-Page Format
Multi-Page Format
EDW HR Front End/PARIS 10/22/19 Single-Page Format Single-Page Format
EDW HR/Payroll 1/3/24 Single-Page Format
Multi-Page Format
Single-Page Format
Multi-Page Format

Student Data Models

DATA UPDATED LOGICAL MODEL(S) PHYSICAL MODEL(S)
DC Prospect & Application UIC UG 1/3/24 Single-Page-Format Single-Page-Format
DM Application Census 8/20/10 Single-Page Format Single-Page Format
DM Financial Aid
     Award by Term
     Award by Year
10/17/11

Single-Page Format
Single-Page Format

Single-Page Format
Single-Page Format
 
DM Financial Aid Census 3/9/10 Single-Page Format Single-Page Format
DM Recruiting & Admissions 4/30/20 Single-Page Format Single-Page Format
DM Section Capacity 11/7/13 Single-Page Format Single-Page Format
DM Web Applications 9/17/09 Single-Page Format n/a
EDW Academic History 1/21/22 Single-Page Format Single-Page Format
Multi-Page Format
EDW Catalog & Schedule 9/18/23 Single-Page Format Single-Page Format
Multi-Page Format
EDW Codebook 5/21/19 Single-Page Format Single-Page Format
EDW Financial Aid 3/28/2 Single-Page Format Single-Page Format
Multi-Page Format
EDW Pre-Registration & Registration 1/3/24 Single-Page Format Single-Page Format
Multi-Page Format
EDW Recruiting & Admissions 1/21/22 Single-Page Format Single-Page Format
Multi-Page Format
EDW Registration Census 1/3/24 Single-Page Format Single-Page Format
Multi-Page Format
EDW Web Applications 11/21/11 Multi-Page Format Single-Page Format
Multi-Page Format

Other Data Models

DATA UPDATED LOGICAL MODEL(S) PHYSICAL MODEL(S)
Change Management & Configuration Management
   EDW - Change Management
   EDW - Configuration Management
06/19/20 Single-Page Format Single-Page Format
DC Helpdesk Reporting 11/15/17 Single-Page Format Single-Page Format
Service Desk Reporting (TDX) 9/18/23 Single-Page Format Single-Page Format

Instructions

How to Read a Data Model

For tips on how to interpret the information in Data Models, read our tutorial document, How to Read a Data Model.

How to Print a Data Model

The data models can be printed as full-scale plotter-sized or as multi-page versions. Instructions for printing data model can be found on the Printing Options page.