U-M Data Warehouse Refresh Schedule

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)

Data Sets Refresh Schedule
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.
Last refresh: December 15, 2022, 7:39 p.m.

See the HR and SR data sets refresh schedules.

Legacy CRAS NO REFRESH

Development

Data Sets Refresh Schedule
DART

Sunday–Friday 11 p.m.–7:30 a.m.
Saturday 3 p.m.–11 p.m.
Last refresh:

Notes:

  • Included every Friday is a full refresh of Constituent Name Format table.
  • On the Friday night after the third Tuesday of a given month, there will be no refresh due to SQL Server patches.

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:
Monday–Saturday, between 5–5:30 a.m.
Last refresh: February 02, 2023, 1:39 a.m.

Financial Chartfield tables:
Sunday–Thursday, 9 p.m.–6 a.m.
Last refresh: February 02, 2023, 4:09 a.m.

Estmt_Summary_Ledger table:
Sunday, between 4–6 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.
Last refresh: Not currently available.

Unit_Defined_Commitments table:
Hourly, 7:30 a.m.–6:30 p.m., Monday–Saturday, except holidays.
Last refresh: February 01, 2023, 6:30 p.m.

Reporting_Ledger_Budget table and eReconciliation fields:
Three times daily at 10 a.m., 2 p.m. and 9 p.m.,
Monday–Friday, except holidays and Sundays at 6 p.m.
Last refresh: February 01, 2023, 9:05 p.m.

Revenue and Expense Activity tables:
Sunday–Thursday, 9 p.m.–6 a.m.
Last refresh: Not currently available.

Procurement, Cash Credit, Concur, and HSIP tables:
Sunday, 6 p.m.–Monday, 1 a.m.;
4th workday of the month for month-end close, 9 p.m.–6 a.m.;
Monday–Friday for two weeks in July for year-end close, 9 p.m.–6 a.m.
Procurement last refresh: January 29, 2023, 7:51 p.m.
Cash Credit last refresh: January 29, 2023, 7:23 p.m.
Concur last refresh: January 29, 2023, 7:32 p.m.
HSIP tables last refresh: January 29, 2023, 8:02 p.m.

DART (Development) BBDW related tables:
After DART BBDW refresh completes Monday, 2–4 a.m.
Last refresh: January 30, 2023, 8:18 a.m.

Legacy Financial NO REFRESH

Human Resource

Data Sets Refresh Schedule
Human Resource (HR)

Sunday-Friday, 8 p.m.–9 p.m.
Last refresh: February 01, 2023, 8:51 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.
Last refresh: February 01, 2023, 7:45 p.m.

See the HR and Payroll data sets refresh schedules.

Benefits

Main Benefit tables: Saturday, 12:15–4 a.m.
Last refresh: January 28, 2023, 12:56 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.
Last refresh: February 01, 2023, 12:04 a.m.

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.
Last refresh: February 01, 2023, 1:14 a.m.

See the HR and Payroll data sets refresh schedules.

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.
Last refresh: January 29, 2023, 3:51 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.
Last refresh: January 26, 2023, 6:03 p.m.

Pay_Summary table: 3rd work day of the month, 8–8:30 p.m.
Last refresh: January 05, 2023, 8:01 p.m.

Pay_Estmt table: Monday–Friday, 9–10 p.m. and Sunday, noon–2 p.m.
Last refresh: February 01, 2023, 7:52 p.m.

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.
Last refresh: January 26, 2023, 6:43 p.m.

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.
Last refresh: February 01, 2023, 1:11 a.m.

Calendar table: Sunday, 7–7:30 p.m.
Last refresh: Not currently available.

See the HR and Payroll data sets refresh schedules.

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.
Last refresh: January 29, 2023, 7:45 p.m.

See the FIN data set schedule.

Space Management

Space tables: Monday–Saturday, 12:30–1:30 a.m.
Last refresh: February 02, 2023, 3:22 a.m.

Utilities and Plant tables: 2nd work day of the month, 11–11:30 p.m.
Last refresh: January 04, 2023, 11:00 p.m.

DepartmentPercentSummary table: Last day of each month, 10:45–11 p.m.
Last refresh: Not currently available.

Classroom Utilization Tables: Sunday–Friday, 7–7:30 p.m.
Last refresh: February 01, 2023, 7:05 p.m.

See the FIN, SR and TL data set schedules.

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.
Last refresh: February 02, 2023, 1:01 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.
Last refresh: January 29, 2023, 10:26 a.m.

Student Financials Detail: Sunday, 8-8:30 a.m., and the first weekday of each month between midnight and 7 a.m. Starting times will vary.
Last refresh: January 29, 2023, 8:26 a.m.

FA_Award_Estmt table: Tuesdays, and the first workday of the month if it is not a Monday, and the last workday of the month if it is a Friday, between midnight and 7 a.m. Starting times will vary.
Last refresh: February 01, 2023, 5:26 a.m.

See the RA, SR, and FIN data sets refresh schedules.

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.
Last refresh: February 02, 2023, 1:19 a.m.

External Org tables: Nightly, Sunday–Friday, 7:30–7:45 p.m.
Last refresh: February 01, 2023, 7:30 p.m.

See the Academic Structure tables refresh schedule.

Student Records (SR)

Main SR Tables: Nightly, Monday–Saturday, 4–5:30 a.m.
Last refresh: February 01, 2023, 4:53 a.m.

Academic Structure tables: Nightly, Sunday–Friday, 7–7:10 p.m.
Last refresh: February 01, 2023, 7:03 p.m.

Degree Audit Report Results (SAA) tables: Monday, 5:30–6 a.m.
Last refresh: January 30, 2023, 5:45 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.
Last refresh: January 25, 2023, 1:14 a.m.

See the SR and FA/SF 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–1 a.m. Refer to the Third Week Count schedule of exact dates.
Last refresh: January 25, 2023, 1:02 a.m.

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.
Last refresh: January 25, 2023, 7:37 a.m.

Student Explorer

Daily tables: Sunday–Friday including Holidays 11:30 p.m.–1 a.m.
Last refresh: February 01, 2023, 11:49 p.m.

Weekly: Sunday 1:30–5:30 p.m.
Last refresh: January 29, 2023, 3:53 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.
Last refresh: January 26, 2023, 6:43 p.m.

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.
Last refresh: February 01, 2023, 1:11 a.m.

Calendar table: Sunday, 7–7:30 p.m.
Last refresh: Not currently available.

See the HR and Payroll data sets refresh schedules.