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: September 22, 2022, 7:21 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.–6:30 a.m.
Saturday 3 p.m.–11 p.m.
Last refresh: October 01, 2022, 11:44 p.m.

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: October 01, 2022, 2:21 a.m.

eResearch Proposal Management Daily, Monday–Saturday, 12:30–4 a.m.

Last refresh: October 01, 2022, 1:07 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: September 30, 2022, 11:50 p.m.

Financial Chartfield tables:
Sunday–Thursday, 9 p.m.–6 a.m.
Last refresh: September 30, 2022, 4:07 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: October 01, 2022, 5: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: September 30, 2022, 9:03 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: September 25, 2022, 7:48 p.m.
Cash Credit last refresh: September 25, 2022, 7:25 p.m.
Concur last refresh: September 25, 2022, 7:32 p.m.
HSIP tables last refresh: September 25, 2022, 8:02 p.m.

DART (Development) BBDW related tables:
After DART BBDW refresh completes Monday, 2–4 a.m.
Last refresh: September 26, 2022, 7:59 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: September 30, 2022, 8:49 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: September 01, 2022, 8:32 p.m.

See the HR and Payroll data sets refresh schedules.

Benefits

Main Benefit tables: Saturday, 12:15–4 a.m.
Last refresh: October 01, 2022, 12:53 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: September 01, 2022, 12:03 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: October 01, 2022, 1:23 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: October 02, 2022, 3:49 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: September 29, 2022, 4:11 p.m.

Pay_Summary table: 3rd work day of the month, 8–8:30 p.m.
Last refresh: September 06, 2022, 8:02 p.m.

Pay_Estmt table: Monday–Friday, 9–10 p.m. and Sunday, noon–2 p.m.
Last refresh: September 30, 2022, 7:54 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: September 27, 2022, 6:41 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: October 01, 2022, 1:12 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: September 25, 2022, 7:51 p.m.

See the FIN data set schedule.

Space Management

Space tables: Monday–Saturday, 12:30–1:30 a.m.
Last refresh: October 01, 2022, 1:11 a.m.

Utilities and Plant tables: 2nd work day of the month, 11–11:30 p.m.
Last refresh: September 02, 2022, 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: September 30, 2022, 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: September 20, 2022, 1:34 a.m.
Admissions Roster

Nightly, Monday–Saturday, 12:20–1:20 a.m.
Last refresh: October 01, 2022, 1:00 a.m.

See the External Org table refresh schedule.

Recruiting and Admissions (RA) tables

Recruiting and Admissions (RA) tables: Nightly, Monday–Saturday, 12:20–2 a.m.
Last refresh: October 01, 2022, 1:10 a.m.

External Org tables: Nightly, Sunday–Friday, 7:30–7:45 p.m.
Last refresh: September 30, 2022, 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: October 01, 2022, 4:54 a.m.

Academic Structure tables: Nightly, Sunday–Friday, 7–7:10 p.m.
Last refresh: September 30, 2022, 7:01 p.m.

Degree Audit Report Results (SAA) tables: Monday, 5:30–6 a.m.
Last refresh: June 25, 2020, 7:56 p.m.

See the RA data set and External Org table refresh schedules.

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: October 02, 2022, 10:25 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: October 02, 2022, 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:00 a.m. Starting times will vary.
Last refresh: October 01, 2022, 5:40 a.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–1 a.m. Refer to the Third Week Count schedule of exact dates.
Last refresh: September 20, 2022, 12:51 a.m.

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–2 a.m.
Last refresh: September 20, 2022, 2:07 a.m.

See the SR and FA/SF data sets refresh schedules.

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: October 01, 2022, 1:42 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: September 30, 2022, 10: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: September 20, 2022, 7:38 a.m.

Student Explorer Daily tables: Sunday–Friday including Holidays 11:30 p.m.–1 a.m.
Last refresh: September 30, 2022, 11:52 p.m.

Weekly: Sunday 1:30–5:30 p.m.
Last refresh: September 25, 2022, 11:16 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.

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: September 27, 2022, 6:41 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: October 01, 2022, 1:12 a.m.

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

See the HR and Payroll data sets refresh schedules.