Refresh Information:
U-M Data Warehouse Data Sets
The data sets in the U-M Data Warehouse are generally available Sunday, noon - Saturday, 11:00 p.m. Each data set has a specific refresh time, and the associated data set tables are unavailable while the refresh is occurring.
On this page, refresh days and times for each data set by data area:
| CRAS |
|
Data Sets
|
Refresh Schedule
|
Other Tables Used
|
| CRAS |
Once during the middle of a term, 7:30 - 8:30 p.m.
Note: Extracts occur once a term, but loads may occur more than once to load data corrections.
|
See the HR and SR data sets refresh
schedules.
|
| Legacy CRAS |
NO REFRESH |
|
| Development |
|
Data Sets
|
Refresh Schedule
|
Other Tables Used
|
DAC |
Monday through Friday, 9:45 p.m. - 1:00 a.m., except the first business day of each month.
|
|
| eResearch |
|
Data Sets
|
Refresh Schedule
|
Other Tables Used
|
eResearch Human Subjects Research |
Monday, 5:00 - 5:30 a.m. |
|
eResearch Proposal Management |
Daily, Monday - Saturday, 1:00 - 1:30 a.m. |
|
| Financial |
|
Data Sets
|
Refresh Schedule
|
Other Tables Used
|
| Financial (FIN) |
Sunday, 7:00 p.m. - Monday, 2:00 a.m.;
5th workday of the month for monthend, 9:00 p.m. - 6:00 a.m.;
Monday - Friday for two weeks in July for yearend, 9:00 p.m. - 6:00 a.m.
Accounts Receivable and Billing tables: Sunday, between 7:00 - 7:15 p.m.; 5th workday of the month for monthend, 7:00 - 7:15 p.m.
Financial Chartfield tables:
Sunday, between 5:00 - 7:30 p.m.; usually takes 5 minutes.
Estmt_Summary_Ledger table:
Sunday, between 4:00 - 6:00 p.m.; usually takes 5 minutes.
Monday - Friday: The start time is not fixed, because the refresh starts after the GL Estimates Summary Ledger process completes.
Unit_Defined_Commitments table: Hourly, from 7:30 a.m. to 6:30 p.m., Monday through Saturday, except holidays.
Reporting_Ledger_Budget table and eReconciliation fields: Three times a day at 10 a.m., 2 p.m. and 9 p.m., Monday through Friday, except holidays. |
|
| Legacy Financial |
NO REFRESH |
|
| Human Resource |
|
Data Sets
|
Refresh Schedule
|
Other Tables Used
|
| Human Resource (HR) |
Thursday, 8:00 p.m. – Friday, 12:30 a.m. |
See the Payroll data set main tables and the FIN data set refresh schedules. |
| Human Resource Snapshot |
Evening of the first workday of the month, 8:30 - 10:00 p.m. |
See the HR and Payroll data sets refresh schedules. |
| Benefits |
Main Benefit tables: Saturday, 12:15 - 3:00 a.m.
Benefits_Data table: Begins 7:15 p.m. on the last day of the month and finishes at 1:00 a.m. the next day. If the last day of the month is Friday or Saturday, the refresh begins at 7:15 p.m. the first Sunday of the next month.
Remittance_Data table: Evening of the last day of each month. If the last day of the month is Friday or Saturday, the refresh begins on the first Sunday of the next month. The begin time is not fixed, because the refresh starts after the completion of the BN Monthly Remit run.
BAS_Partic and CBR_Partic tables: After each biweekly and monthly payroll is complete; the time for the refresh is not fixed. See U-M Payroll Office for a schedule of the University pay dates. |
See the HR and Payroll data sets refresh schedules. |
| Legacy Human Resource |
NO REFRESH |
|
| Payroll |
|
Data Sets
|
Refresh Schedule
|
Other Tables Used
|
| Payroll |
Main Payroll tables: After each off-cycle, biweekly, and monthly payroll is complete; the time for this refresh is not fixed. For regular Thursday off-cycles the refresh usually begins between 5:00 and 5:30 p.m. See U-M Payroll Office for a schedule of the University pay dates.
Pay_Summary table: 3rd work day of the month, 8:00 - 9:30 p.m.
Pay_Estmt table: Sunday, 5:00 - 8:00 p.m.; Monday - Friday; 10:00 p.m. - midnight
|
See the HR and FIN data sets refresh schedules.
|
| Time & Labor |
Main Time & Labor tables: After each biweekly and monthly payroll is complete; the time for this refresh is not fixed.
See U-M Payroll Office for a schedule of the University pay dates.
Leave data tables: After each biweekly payroll and accruals are complete, after monthly payroll is complete, and the 1st day of the month after monthly leave accruals are complete.
Calendar table: Sunday, 7:30 – 8:00 pm |
See the HR and Payroll data sets refresh schedules.
|
| Legacy Payroll |
NO REFRESH |
|
| Physical Resources |
|
Data Sets
|
Refresh Schedule
|
Other Tables Used
|
| Asset Management |
Sunday, 7:00 - 9:00 p.m. 5th workday of the month for month-end, 9:00 -11:00 p.m.
|
See the FIN data set schedule. |
| Space Management |
Space tables: Monday, 12:30 - 2:30 a.m.
Utilities and Plant tables: 2nd work day of the month, 11:00 - 11:30 p.m.
DepartmentPercentSummary table: Last day of each month, 11 am – midnight
Classroom Utilization Tables: Sunday, 7:30 – 8:00 pm |
See the FIN, SR and TL data set schedules.
|
| Student |
|
Data Sets
|
Refresh Schedule
|
Other Tables Used
|
| Admissions Snapshot |
Sunday night following the third week of classes and a Sunday close to November 1: 10:00 p.m. - 3:00 a.m. Refer to the Admissions Snapshot
schedule of exact dates. |
|
| Admissions Roster |
Nightly, Sunday - Friday, 11:59 p.m. – 2:00 a.m.
|
See the External Org table refresh schedule. |
| Recruiting and Admissions (RA) |
Main RA tables: Sunday, 5:00 p.m. – Monday, 3:00 a.m.
External Org tables: Nightly, Monday - Saturday, 12:30 - 12:40 a.m. when the SR data set is refreshed.
|
See the Academic Structure tables refresh schedule.
|
| Student Records (SR) |
Main SR Tables: Nightly, Sunday - Friday, 11:59 p.m. - 6:00 a.m. except during Financial month end and fiscal year end close. Refer to the Student Records' schedule of exact dates for exceptions.
Academic Structure tables: Nightly, Sunday - Friday, 7:00 - 7:10 p.m. when the Student Records data set is refreshed.
Degree Audit Data tables are refreshed about eight times a year: Saturday mornings, 7:00 a.m. - 3:00 p.m. Refer to the Degree Audit Data tables schedule of exact dates.
|
See the RA data set and External Org table refresh schedules.
|
| Financial Aid/Student Financials (FA/SF) |
Main FA/SF tables: Friday, midnight - 6:00 a.m.
Student Financials Detail: Friday, 11:00 p.m. - 4:30 a.m., and the 1st work day of each month, 11:00 p.m. - 4:30 a.m. Tuesdays; 7:00 - 8:00pm.
FA_Award_Estmt table: Tuesdays, 7:00 - 8:00 p.m.
|
See the RA, SR, and FIN data sets refresh schedules. |
| Third Week Count |
Each term on the night after the end of the third week of classes,
and is based on students who are registered for that term at that time: 12:01 a.m. - 1:00 a.m. Refer to the Third Week
schedule of exact dates.
|
See the SR data set refresh schedule. |
| Student Retention and Completion |
Once per year on the night after the end of the third week of classes for Fall term only: 12:01 - 1:00 a.m.
|
See the SR and FA/SF data sets refresh schedules. |
| Legacy Official Third Week Count |
NO REFRESH |
|
| Legacy Student |
NO REFRESH |
|
|
