U-M Data Warehouse Refresh Schedule

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.

BBDW table USR_DM_CNST_ALL_NM full refresh:
Weekly: Friday. No refresh on the Friday night after the second Tuesday of a month due to SQL Server patches.

Accounts Receivable and Billing tables:
Sunday, between 7–7:30 p.m.; Monday–Friday, 10–10:30 p.m.

Financial Chartfield tables:
Sunday–Thursday, 9 p.m.–6 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.

Unit_Defined_Commitments table:
Hourly, 7:30 a.m.–6:30 p.m., Monday–Saturday, except holidays.

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.

Revenue and Expense Activity tables:
Sunday–Thursday, 9 p.m.–6 a.m.

Procurement 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.

DART (Development) BBDW related tables:
After DART BBDW refresh completes Monday, 2–4 a.m.

Sunday-Friday, 8 p.m.–9 p.m.

See the Payroll data set main tables and the FIN data set refresh schedules.

Evening of the first workday of the month, 8:30–10 p.m.

See the HR and Payroll data sets refresh schedules.

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. 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.

See the HR and Payroll data sets refresh schedules.

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.

Pay_Summary table: 3rd work day of the month, 8–8:30 p.m.

Pay_Estmt table: Monday–Friday, 9–10 p.m. and Sunday, noon–2 p.m.

See the HR and FIN data sets refresh schedules.

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–7:30 p.m.

See the HR and Payroll data sets refresh schedules.

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 tables: Monday–Saturday, 1:30–2:30 a.m.

Utilities and Plant tables: 2nd work day of the month, 11–11:30 p.m.

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

Classroom Utilization Tables: Sunday–Friday, 7–7:30 p.m.

See the FIN, SR and TL data set schedules.

Nightly, Sunday–Friday, 11:59 p.m.–1 a.m.

See the External Org table refresh schedule.

Recruiting and Admissions (RA) tables: Nightly, Sunday–Friday, 10–11 p.m.

External Org tables: Nightly, Sunday–Friday, 7:30–7:45 p.m.

See the Academic Structure tables refresh schedule.

Main SR Tables: Nightly, Monday–Saturday, 4–5:30 a.m.

Academic Structure tables: Nightly, Sunday–Friday, 7–7:10 p.m.

Degree Audit Data tables are refreshed about fourteen times a year: 6–10:30 p.m. Refer to the Degree Audit Data tables schedule of exact dates.

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

Main FA/SF tables: Sunday, 10–10:30 a.m.

Student Financials Detail: Sunday, 8-8:30 a.m., and the first weekday of each month between midnight and 7:00 a.m. - starting times will vary.

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.

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

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.

Once per year on the night after the end of the third week of classes for Fall term only: 12:01–2 a.m.

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

Refer to the LARC schedule of exact dates.

Weekly: Sunday 1:30–5:30 p.m.

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–7:30 p.m.

See the HR and Payroll data sets refresh schedules.