Data Dictionary
University of Minnesota
Data Warehouse
Information About:   Data Dictionaries, FAQ, Listserv, Warehouse table loads     
Click to show hidden text... Data Warehouse Message Board
7/6/2021 1:21:10 PM DWTA - DWTA Summer Preliminary 1215 Tuition Attribution data is now available.
6/7/2021 2:14:25 PM DWSA - PS_DWSA_STIX_1215_INT is now available
1/8/2021 11:54:53 AM DWAD Yearly DWAD_RT and _HS are are currently unavailable.
12/15/2020 10:58:31 AM PSSNAP - Reports and processes that utilize copies of PeopleSoft data run between 8:00 PM and 2:00 AM may result in issues. The nightly clone process will begin at 8:00 PM instead of 12:00 AM until the data load issues are fully resolved. This issue continues to be worked on and closely monitored. (Updated December 15, 2020)"
11/18/2020 12:47:06 PM DWSA - PS_DWSA_RETNGRAD_2020 is now available.
1/10/2020 1:35:32 PM DWEO - The PS_DWEO_IR_HR_IPEDS table has been updated to correct NULL values in the IPEDS_CAT_CD column. This update was needed only on records with an ARCHIVE_DT = 10/23/2019
1/2/2020 1:20:12 PM DWTA DWAD_HS AND DWAD_RT tables are now available with 2020 data.
Click to show hidden text... The Web Query Tool is no longer available.
Learn about Oracle SQL Developer, a no-cost replacement tool.
Click to show hidden text... What is the Data Warehouse?
The Data Warehouse is a collection of data which can be used to support the University's operational and decision making processes. These data are organized by subject area, e.g. Financial, Payroll, and updated periodically from the U's operational information systems.
Click to show hidden text... What data are contained in this site?
The Data Warehouse is broken down into specific subjects areas. Some of the areas covered include financial, payroll, HR, space, equipment inventory and student information for the entire University. Student data is sub-divided further into Admissions, Enrollment, Graduate School and Course data.

2021 by IMS and the Regents of the University of Minnesota
The University of Minnesota is an equal opportunity educator and employer.
IMS User Support,
Read the IMS user Privacy Statement here.
Last updated 2019.