The data sets in the U-M Data Warehouse are generally available noon Sunday–11 p.m. Saturday. Each data set has a specific refresh time, and the associated data set tables are unavailable while the refresh is occurring.
Refresh days and times for each data set by data area:
- College Resources Analysis System (CRAS)
- Development
- eResearch
- Financial
- Human Resource
- Payroll
- Physical Resources
- Student
- Student Life
- Teaching & Learning
- Time & Labor
College Resources Analysis System (CRAS)
| Data Sets | Refresh Schedule |
|---|---|
| CRAS |
Once during the middle of a term, 7:30–8:30 p.m. |
| Legacy CRAS | NO REFRESH |
Development
| Data Sets | Refresh Schedule |
|---|---|
| DART |
Sunday–Friday 11 p.m.–7:30 a.m. Notes:
|
eResearch
| Data Sets | Refresh Schedule |
|---|---|
| eResearch Human Subjects Research | Daily, Monday–Saturday, 1:30–4 a.m.
Last refresh: February 02, 2023, 4:07 a.m. |
| eResearch Proposal Management | Daily, Monday–Saturday, 12:30–4 a.m.
Last refresh: February 02, 2023, 3:12 a.m. |
Financial
| Data Sets | Refresh Schedule |
|---|---|
| Financial (FIN) | General Ledger tables: Sunday–Thursday, 9 p.m.–6 a.m. Accounts Receivable and Billing tables: Financial Chartfield tables: Estmt_Summary_Ledger table: Unit_Defined_Commitments table: Reporting_Ledger_Budget table and eReconciliation fields: Revenue and Expense Activity tables: Procurement, Cash Credit, Concur, and HSIP tables: DART (Development) BBDW related tables: |
| Legacy Financial | NO REFRESH |
Human Resource
| Data Sets | Refresh Schedule |
|---|---|
| Human Resource (HR) |
Sunday-Friday, 8 p.m.–9 p.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 p.m. See the HR and Payroll data sets refresh schedules. |
| Benefits |
Main Benefit tables: Saturday, 12:15–4 a.m. Benefits_Data, BAS_Partic and CBR_Partic tables: Begins 8:15 p.m. on the last day of the month and finishes at 1 a.m. the next day. If the last day of the month is Friday or Saturday, the refresh begins at 8:15 p.m. the first Sunday of the next month. Remittance_Data table: Evening of the last day of each month. The begin time is not fixed, because the refresh starts after the completion of the BN Monthly Remit run. |
| My LINC | The My LINC data set is updated in real time from My LINC. As a result there is no refresh schedule; however, the My LINC data set is still subject to periodic scheduled downtime for maintenance activities. |
| Human Resource Training and Education Unified |
LMS tables: Sunday, 3:30–4:30 a.m. Personal Data table: See the Human Resource (HR) data set refresh schedule. Current Financial Department View: See the FIN data set refresh schedule. |
| Legacy Human Resource | NO REFRESH |
Payroll
| Data Sets | Refresh Schedule |
|---|---|
| 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–5:30 p.m. See U-M Payroll Office for a schedule of the university pay dates. |
| 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. |
| Legacy Payroll | NO REFRESH |
Physical Resources
| Data Sets | Refresh Schedule |
|---|---|
| Asset Management |
Sunday, 7–9:30 p.m. 5th workday of the month for month-end, 7–10 p.m. See the FIN data set schedule. |
| Space Management |
Space tables: Monday–Saturday, 12:30–1:30 a.m. |
Student
| Data Sets | Refresh Schedule |
|---|---|
| Admissions Snapshot | Each term on the night after the end of the third week of classes and a Sunday close to November 1: 1–2:30 a.m. Refer to the Admissions Snapshot schedule of exact dates. Last refresh: January 25, 2023, 1:37 a.m. |
| Admissions Roster |
Nightly, Monday–Saturday, 12:20–1:20 a.m. See the External Org table refresh schedule. |
| Financial Aid/Student Financials (FA/SF) |
Main FA/SF tables: Sunday, 10–10:30 a.m. and after Financial Award Disbursement processing 2–6:30 a.m. Starting times will vary. See the Financial Aid Disbursement Calendar for specific dates. |
| Financial Aid/Student Financials Snapshot |
Snapshots are taken on demand. Official snapshots of an aid year are typically taken after the third week of the fall term, with an additional final snapshot taken a year later after the close of the aid year. Unofficial snapshots are taken on an ad-hoc basis. |
| National Student Clearinghouse (NSC) |
The university receives data from the National Student Clearinghouse three times a year on January 15, June 15, and October 15. Once data is validated by OBP it is loaded into the data warehouse. |
| Recruiting and Admissions (RA) tables |
Recruiting and Admissions (RA) tables: Nightly, Monday–Saturday, 12:20–2 a.m. See the Academic Structure tables refresh schedule. |
| Student Records (SR) |
Main SR Tables: Nightly, Monday–Saturday, 4–5:30 a.m. Academic Structure tables: Nightly, Sunday–Friday, 7–7:10 p.m. Degree Audit Report Results (SAA) tables: Monday, 5:30–6 a.m. See the RA data set and External Org table refresh schedules. |
| 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–2 a.m. |
| 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–1 a.m. Refer to the Third Week Count schedule of exact dates. See the SR data set refresh schedule. |
| Legacy Official Third Week Count | NO REFRESH |
| Legacy Student | NO REFRESH |
Student Life
| Data Sets | Refresh Schedule |
|---|---|
| Campus Living | Nightly, Sunday–Friday, 10 p.m.–6 a.m. Last refresh: February 02, 2023, 1:48 a.m. |
| Sessions @ Michigan | Daily, 5 a.m. Last refresh: Not currently available. |
| Student Life Attendance | Student Life Attendance tables: Sunday–Friday, 10 p.m.–11 p.m. Last refresh: February 01, 2023, 11:10 p.m. Current Building Table View: See the Space Management data set refresh schedule. Current Financial Department View: See the FIN data set refresh schedule. Personal Data table: See the M-Pathways Human Resource (HR) data set refresh schedule. Term View: See the M-Pathways Student Records data set refresh schedule. |
Teaching & Learning
| Data Sets | Refresh Schedule |
|---|---|
| Learning Analytics Data Architecture (LARC) | 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.
Refer to the LARC schedule of exact dates. |
| Student Explorer | Daily tables: Sunday–Friday including Holidays 11:30 p.m.–1 a.m. Weekly: Sunday 1:30–5:30 p.m. |
| Canvas Data/Unizin Data Warehouse (UDW) | UDW data is refreshed once daily at varying times. Because of the complexity of the extraction process, the Canvas data will not appear in the UDW data set until roughly 48 hours later. Last refresh: Not currently available. |
| Online Learning Data Warehouse (OLDW) | Monday–Saturday including Holidays 4–4:45 a.m. Last refresh: February 01, 2023, 4:31 a.m. |
| Coursera Phoenix Redshift | Daily including Holidays 5:30–10:30 p.m. Last refresh: Not currently available. |
| Coursera Spark | NO REFRESH |
| Unizin Data Platform (UDP) | The UDP ingests data at different intervals based on the type of data; events data are ingested in real time; currently SIS data is ingested daily. Canvas data is refreshed once daily at varying times. Because of the complexity of the extraction process, the Canvas data will not appear in the UDP data set until roughly 48 hours later. |
Time & Labor
| Data Sets | Refresh Schedule |
|---|---|
| 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. |