Student Data Warehouse Load Information
These are the starting times for each load.
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)|
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:|
|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