Data Warehouse

Home Page Information About:   Data Dictionaries, FAQ, Listserv, Warehouse table loads To query using Point and Click or Free Form Log out screen     


Refresh Schedule

DWAD

DLY tables run mid-morning daily
All other tables run weekly Saturday afternoon

DWEF

Daily by 8:30 am.

DWFA

The Financial Aid tables are updated each evening at 6:30 or so
ps_dwfa_fdn_chartfield1 and ps_dwfa_st_assistance run each morning at 8:30 or so

DWFS

The Data is static. Last loaded in 2008.

DWGR

Tables are updated each morning at 8:30 or so.

DWHR

1. Nightly, Monday through Saturday between 3:00 and 4:30AM

     Regular tables

2. Nightly, Sunday through Friday between 3:00 and 4:30AM

      Training tables

DWNC

Monday - Friday by 7:00 am

DWPY

1. Daily at 6:30AM or so

     ps_dwpy_dist
     ps_dwpy_hsa_xx

2. Sunday night before payday

     ps_dwpy_pay_frng_xx
     ps_dwpy_vac_sick

3. Daily for the first three business days of the month then not until the next month.

     ps_dwpy_monthly_sum_xx

DWSA

1. Monday through Saturday between 9:00 and 10:00PM

     Current tables

2. Mid November each year

      Retention tables

3. Per Semester

      Stix

DWSF

Daily, Tuesday through Sunday between 7:30 and 8:00AM

DWSP

Monday through Friday in mornings

DWSR

NIghtly, Monday Friday between 3:00 and 5:00AM

DWTA

For Fall and Spring Semesters, the second week and final week of classes based on Twin Cities Calendar.
For Summer Semester, fourth week and final week of classes based on Twin Cities Calendar.

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 April 20th, 2016.