Salary Management Collection Refresh Schedule

Biographical and job data is refreshed daily, as well as Change Log data and the Primary Appointment calculation, on Monday through Friday evenings. Note that there is period each night during which Primary Academic Appointment information may be null, due to job scheduling dependencies. Employee, job and distibution data snapshots are created at the end of the accounting period.

Payment data, including the PAR tables, is refreshed weekly, on Monday evenings, after the computation of payroll and encumbrances for weekly employees on the mainframe system. Monthly payments are loaded on the last Friday before the last weekly Payroll run for the month. Since payments are loaded to the Data Warehouse before BEN Financials, the best time to compare payroll and General Ledger balances is after the payments are loaded to BEN Financials, but before new payments are loaded to the Warehouse. To pull matching data from BEN Financials, Salary Management and the Data Warehouse at the end of a period you'll need to run your system reports and Warehouse queries between the Tuesday after payroll runs, producing the last weekly check for the month, and before the Monday of the following week. By that last Tuesday, monthly payroll has already been run, so those actuals and updated encumbrances will be correct. This limits the risk of retrieving data from Salary Management or the Warehouse for the last weekly pay of the month which may, in fact, be posted to the next BEN Financials Accounting Period. (For example, for AUG-99, reports would have to have been run between August 27 and August 30th.)

Social Security Number changes are loaded weekly, on Tuesday evenings.

Budget data, (extracted from the Pillar system), is stored in the BUDGET_BASE and BUDGET_DISTRIBUTION tables, is not currently refreshed, and contains data for fiscal year 1997 only.

Source of the Data
The data in the data warehouse that is accessible via the Business Objects RSALMGT universe comes from the Payroll and Salary Management systems. The data in this Universe includes biographical information about employees, information on their jobs, and financial data on their salaries (encumbrances, distributions and payments).

Time Span Covered
The Data Warehouse stores current information on employees, and current and historical information on their jobs and salries. The data goes as far back as July 1, 1996 (the JUL-96 accounting period, in fiscal year 1997), and continues from that point, through the current open period.

Payroll Audit Record (PAR) data is available from fiscal year 2005 and onward.