University of Minnesota
Data Warehouse
Home Page Information About:   Data Dictionaries, FAQ, Listserv, Warehouse table loads To query using Point and Click or Free Form     
Subject Area Contacts

The Access Request Form, can be found at: http://www1.umn.edu/datasec/security/Requestingaccess.html

If you have questions about prerequisites for receiving access, contact the appropriate person listed below:



Subject Area

Database

Contact Name

Admissions/Prospective Students DWAD John Kellogg (OIR), (612) 625-3387
Financial Aid DWFA Richard Toetschinger, (612) 626-9076
Financial DWFS EFS Customer Support, (612) 624-1617
Graduate Students DWGR Bard Bostrom (612) 625-9839
Human Resources DWHR OHR Call Center (612) 624-8647 ohr@umn.edu
Non-Credit DWNC Heather Mathewson, (612) 624-8206
Program and Curriculum DWPC Margo Mueller, (612) 626-7867 /td>
Payroll DWPY OHR Call Center (612) 624-8647 ohr@umn.edu
Student Enrollment DWSA John Kellogg (OIR), (612) 625-3387
Student Financial DWSF Student Financials System Control Unit, sfhelp@umn.edu
Facilities DWSP Space Management, Anne Facente, (612) 626-7996

University Services, Michael Seberg,(612) 625-2904

Course DWSR Linda Miza (Office of the Registrar), (612) 626-7214
Student Selector DWSS Dianne Danov, (612) 624-2057
Tuition DWTA Linda Lorenz (OIR), (612) 625-6726



Click to show hidden text ... ADMISSIONS/PROSPECTIVE STUDENTS (DWAD)

Data Custodian: George Hudachek

Data Contact: John Kellogg, OIR (612) 625-3387

Email: GEORGE - g-huda@umn.edu

JOHN - j-kell@umn.edu

The DWAD contains information about Admissions/Prospective Students from the Peoplesoft Student Administration system. The tables are specifically designed for reporting information about recent applicants and prospective students at the University of Minnesota (UM). The tables contain information about prospective students who have applied for a term within one year prior to the current term or for any future term.

DWAD is refreshed every weekend.

More information about this data can be found in the online data dictionary at https://dw.umn.edu/DataDic/dictionary.asp.

The DWAD also contains applicant and prospective student information extracted from the legacy IMS Admissions/Prospective Students database. Data are included for applicants in the five years prior to Fall ’99 and prospective students whose files were updated in the same five years. Examples of the types of data carried are: applicant address, high school courses, high school grades, prospective Major, and admit decision code.

More information about this data can be found in the online data dictionary at https://dw.umn.edu/DataDic/staticDic.asp. Please note that this data dictionary was written for earlier versions of this database. While the information is mainly correct, some table names and column names have changed. Please contact John Kellogg for more information on using this data.

Click to show hidden text ... FINANCIAL AID (DWFA)

Data Custodian: Richard Toetschinger

Office of Student Financial Aid (612) 625-1370

Email: Richard - toet001@umn.edu

The financial aid (DWFA) tables contain ISIR, demographic, and award data for students and applicants of the University of Minnesota. ISIR data is generated from the Free Application for Student Financial Aid (FAFSA). Award data includes information on estimated family contribution (EFC), cost of attendance (COA), student need and award packaging. Data is also available on Minnesota State Grants awarded.

The DWFA tables are refreshed Sundays.

More information about this data can be found in the online data dictionary at https://dw.umn.edu/DataDic/staticDic.asp.

Click to show hidden text ... FINANCIALS SYSTEMS-CUFS (DWFS)

Data Contact: EFS customer support (612) 624-1617

Email: fsshelp@tc.umn.edu

The CUFSRDB/DWFS contains financial and sponsored accounts data. Its data sources are the CUFS and Sponsored Projects Administration operational systems. The type of information included in the database are Chart of Accounts descriptions (COA), Endowments, Grants, Transaction level detail, and two levels of Summary data (at the subobject/subrevenue level and at the object/revenue/balance sheet level).

The data is static.

More information about this data can be found in the online data dictionary at https://dw.umn.edu/DataDic/staticDic.asp.

CUFSRDB and SQL training is encouraged and available through Training Services.

Click to show hidden text ... GRADUATE SCHOOL (DWGR)

Data Custodian: Graduate School (612) 625-9839

Email: GENNY - rosing@umn.edu

The DWGR contains information from the Peoplesoft system concerning Graduate School students enrolled or receiving a degree since January 1981. The tables contain data such as, student name, ID, address and other demographic data, plans/sub_plans, program approvals, committees, exams taken, graduate GPA, graduate credits, advisor name and degree awards. There are also two tables related to Graduate Faculty, with demographic and appointment data.

The DWGR is refreshed weekly on Saturdays with Friday data and Wednesdays with Tuesday data.

More information about this data can be found in the online data dictionary at https://dw.umn.edu/DataDic/staticDic.asp.

Click to show hidden text ... HUMAN RESOURCES (DWHR)

Data Custodian: Phil Klein, OHR (612) 625-4547

OHR Call Center
(612) 624-8647
ohr@umn.edu

More information about this data can be found in the online data dictionary at https://dw.umn.edu/DataDic/dictionary.asp.

Click to show hidden text ... NON-CREDIT (DWNC)

Data Custodian: Heather Mathewson, (612) 624-8206

Email: HEATHER - mathe011@umn.edu

The Non-Credit (DWNC) tables contain data related to courses and students taking non-credit courses through CCE.

The DWNC tables are refreshed each morning Monday through Friday.

More information about this data can be found in the online data dictionary at
https://dw.umn.edu/DataDic/dictionary.asp.

Click to show hidden text ... PROGRAM AND CURRICULUM (DWPC)

Data Custodian: Susan Van Voorhis

Data Contacts: Margo Mueller (612) 626-7867

Travis Trautman (612) 626-7195

Emails: MARGO m-muel@umn.edu

TRAVIS trau0001@umn.edu

DWPC is a 'Program and Curriculum' data base designed to provide easy access to effective dates, graduation requirements, entrance requirements, sub plans and college information related to programs and curricula. The data is extracted from the operational system PCAS (Program and Curriculum Approval System). DWPC is completely refreshed each weekday morning.

More information about this data can be found in the online data dictionary at https://dw.umn.edu/DataDic/dictionary.asp. Please contact Margo Mueller or Travis Trautman for more information on using this data.

Click to show hidden text ... PAYROLL (DWPY)

Data Custodian: Phil Klein, OHR (612) 625-4547

OHR Call Center
(612) 624-8647
ohr@umn.edu

For more detail on the data contained in DWPY, please see the data dictionary at: https://dw.umn.edu/DataDic/dictionary.asp.

Click to show hidden text ... STUDENT ENROLLMENT (DWSA)

Data Custodian: Sue Van Voorhis

Data Contacts: Sue Van Voorhis, Office of the Registrar (612) 625-8098 or

John Kellogg, OIR (612) 625-3387

Email: SUE- vanvo002@umn.edu

JOHN - j-kell@umn.edu

STUDENT ENROLLMENT (DWSA) tables are specifically designed for reporting information about student enrollments at University of Minnesota (UM) starting with Fall semester 1999. The tables contain demographic, academic plan, service indicators, student groups and class enrollment data for students, extracted from the Peoplesoft system.

The current DWSA tables are refreshed nightly. The historical DWSA tables are refreshed on Saturdays.

More information about this data can be found in the online data dictionary at https://dw.umn.edu/DataDic/staticDic.asp.

In addition to enrollment data from Peoplesoft, the DWSA contains registered student information and copies of some DLI tables extracted from the legacy IMS Student database. It also holds the official registration statistics (STIX) tables. The legacy registration data includes information on students who have been enrolled and/or received an UM degree any time during the ten years prior to Fall ' 99. Examples of the types of data carried are address, ethnic background, GPA, Major, courses registered for each term and grades received. The STIX tables are available by term going back to 1987.

More information about this data can be found in the online data dictionary at https://dw.umn.edu/DataDic/staticDic.asp. Please note that this data dictionary was written for earlier versions of this database. While the information is mainly correct, some table names and column names have changed. Please contact John Kellogg for more information on using this data.

Click to show hidden text ... STUDENT FINANCIALS (DWSF)

Data Custodian: Carolee Cohen

Data Contact: Student Financials System Control Unit

Email: CAROLEE - c-cohe@umn.edu

STUDENT FINANCIALS SYSTEM CONTROL UNIT: sfhelp@umn.edu

The data for student financials transactions is stored in the following tables by fiscal year.

For FY 1998 - 1999, the table name is PS_DWSF_SF_ACCTG_LN_99
For FY 1999 - 2000, the table name is PS_DWSF_SF_ACCTG_LN_00
For FY 2000 - 2001, the table name is PS_DWSF_SF_ACCTG_LN_01
and so on.

All data in these tables are from PeopleSoft.

The tables are refreshed weekly on Monday night.

More information about this data can be found in the online data dictionary at https://dw.umn.edu/DataDic/dictionary.asp.

Click to show hidden text ... STUDENT SELECTOR (DWSS)

Data Custodian: Sue Van Voorhis

Data Contact: Sue Van Voorhis, Office of the Registrar (612) 625-8098 or
John Kellogg, OIR (612) 625-3387

Email: SUE - vanvo002@umn.edu
JOHN - j-kell@umn.edu

The student selector (DWSS) table and four(4) views based on institution contains student data (demographics, test scores, financial aid info, enrollment information, etc.) and contains all current students, (PS_ACAD_PROG.prog_status='AC')—not just currently enrolled students. There are also future students (PS_ACAD_PROG.prog_status='AC' and PS_ACAD_PROG.effdt > sysdate), and future admits-not matriculated, (ps_adm_appl_prog.prog_status in('AD','PM') and ps_adm_appl_prog.admit_term > current term). The field, source, has values of SC, SF, and AD (Student - Current, Student - Future, and Admits). Deceased students have been removed from the table and views.

The table name and views are:

PS_DWSA_STDNT_SELECTOR – This is the base table.

PS_DWSA_SS_MO_VW – Morris students
PS_DWSA_SS_CR_VW – Crookston students
PS_DWSA_SS_DL_VW – Duluth students
PS_DWSA_SS_TC_VW – Twin Cities students

The data is as of the prior evening and is available for use by 2 a.m. Monday – Saturday.

More information about this data can be found in the online data dictionary at https://dw.umn.edu/DataDic/dictionary.asp.

Click to show hidden text ... SPACE MANAGEMENT (DWSP)

Data Contact: Tina Kive - Space Management Office (612) 625-2846

Data Contact: Anne Facente – Space Management Office (612) 626-7996

Data Contact: Michael Seberg – University Services Information Systems (612) 625-2904

The Space (DWSP) tables contain data from the operational system maintained by Office of Space Management. The 13 tables contain space related information about campuses, buildings, floors, and rooms. Each table has a view that provides information to ArcView (a graphical navigational system for the space system) about images and their location. ArcView uses these views to provide graphical navigation of the space system.

The tables are refreshed weekly on Sunday nights

More information about this data can be found in the online data dictionary at https://dw.umn.edu/DataDic/dictionary.asp.

Click to show hidden text ... COURSES (DWSR)

Data Custodian: Sue Van Voorhis

Data Contacts: Linda Miza, OTR (612) 626-7214 or

John Kellogg, OIR (612) 625-3387

Email: SUE - vanvo002@umn.edu

LINDA - l-miza@umn.edu

JOHN - j-kell@umn.edu

Course (DWSR) tables are specifically designed for reporting information about courses offered at University of Minnesota (UM) starting with fall semester 1999. The course information in these tables relates to information published in Course Catalogs and Class Schedules.

The DWSR is refreshed every morning Monday thru Friday.

More information about this data can be found in the online data dictionary at https://dw.umn.edu/DataDic/staticDic.asp.

Click to show hidden text ... TUITION ATTRIBUTION (DWTA)

Data Contact: John Kellogg, OIR, (612) 625-3387

Email: John - j-kell@umn.edu

The DWTA contains tuition data extracted from the Peoplesoft beginning with the Fall ' 99 semester. The tables contain tuition and other data summarized at the student-course, course, student, and academic program levels.

The tables are refreshed at the end of the second and the final weeks of Fall and Spring semesters. For Summer semester, the tables are updated the fourth week and the final week of Summer semester.

More information about this data can be found in the online data dictionary at https://dw.umn.edu/DataDic/dictionary.asp.

In addition to tuition data from Peoplesoft, the DWTA contains historical tuition data extracted from legacy systems. This data is available for terms going back to Fall ' 96.

More information about this data can be found in the online data dictionary at https://dw.umn.edu/DataDic/staticDic.asp. Please note that this data dictionary was written for earlier versions of this database. While the information is mainly correct, some table names and column names have changed. Please contact the Sarah Delaney for more information on using this data.

© 2017 by IMS and the Regents of the University of Minnesota
The University of Minnesota is an equal opportunity educator and employer.
IMS User Support, reports@umn.edu
Read the IMS user Privacy Statement here.
Last updated 2014.