University of Wisconsin–Milwaukee


Student Data Warehouse Load Information


Load Sequence


These are the starting times for each load.


These loads are run nightly:
12 a.m. Admissions
12:30 a.m. Campus Commmunity
1:30 a.m. Records
2:45 a.m. Second Pass for Vu_CC_Personal_Dim (including refresh of MV_DES_CC_Personal_Dim),
Vu_CC_Personal_Dim_Secure,
Vu_CC_Athletes_Dim,
Vu_PREG_UWM_Am_Dir_Data,
Vu_UWM_Ethnicity_History,
Vu_UWM_Person_Earliest_App,
Vu_UWM_Registered_Student_Demo,
Vu_UWM_Term_Tbl
and more
3:15 a.m. Financial Aid
4:15 a.m. Student Financials

ODS tables are loaded at the same time as their RDS counterparts.


Sunday Server Maintenance
Sunday 8 a.m.- noon This time is reserved for server maintenance.
Check Student DW Alerts for notice of scheduled work.
While not always scheduled, maintenance activities have priority during this time frame and therefore, unannounced outages may also occur.

Weekly Data Warehouse Backup (starting 04/01/05)
Friday 9:30 p.m.- midnight The data warehouse will be offline for weekly backup.
Currently the backup is taking about 130 minutes, so the data warehouse may be available before midnight.

These loads are run weekly:
Application Statistics (Vu_AppStat) Monday a.m.; after successful RDS load
Enrollment Statistics (All views in the Enrollment Statistics module) Monday a.m.; after successful run of Peoplesoft job to select data.
RDS Records History Last Saturday of the month at 8 p.m. (3/1/2014 - changed from monthly)
UWM Tables
Click here for a complete list
Monday 3:45 a.m.

These loads are run monthly:
UWM Credit History First day of the month.
Vu_UWM_Sr_Gradsrvy First day of the month.
Prospective Student Statistics (Prostat) Used to be run the first day of the month. After implementation of the Talisma CRM system, the last run was Feb 1, 2012. Data is retained in the Warehouse for historical purposes.

These loads are run per semester:
Statistical Master (StatMaster) To reflect 10th day of classes; run upon Resource Analysis request, usually the 6th week for fall and spring terms, end of August for summer.

These loads are run yearly on July 1:
Vu_REC_Enrollment_Fact_Py
Vu_REC_Student_Term_Dim_Py
Vu_SF_Item_Fact_Dim_Py
Vu_SF_Item_Line_Fact_Py
Vu_SF_Item_Xref_Dim_Py
Vu_SF_Payment_Dim_Py
Vu_SF_UW_GL_Int_Py
End-of-year tables requested by FAA.

These are loaded upon request (contact imt-datadmin):
Test RDS Data Warehouse and Test ODS  

Load Selection Criteria


Campus Community All people are selected; only the current effective dated information is selected. This is refreshed nightly. 3Cs Date = 1900-01-01.
Admissions Prospect and Applicants are selected if their admit term is equal or greater than 1082 (Summer 09). Only the current effective dated information is selected. This is refreshed nightly.
Records Students are selected if they have a term activation row within the last 5 years, currently where the term is greater than or equal to 1082 (Summer 09). Once the students are chosen, all data in the Records module for those students are selected. PAWS data starts Spring 1984. Generally, term activation occurs when the student is active in an academic program for that term. Only the current effective dated information is selected. This is refreshed nightly.
History Records Students are selected for all terms in production PAWS (which starts with Spring 1984). Only the current effective dated information is selected. This is refreshed on the last Saturday of each month.
Student Financials All current effective dated Student Financial information is selected. This is refreshed nightly.
Financial Aid Aidyears 2013, 2014 and 2015 are selected. Aid year selection is changed approximately Jan/Feb per FinAid direction. Only the current effective dated information is selected. This is refreshed nightly.

Last revision date: 2/24/2014