Penn Computing

Penn Computing

Computing Menu Computing A-Z
Computing Home Information Systems & Computing Penn

Current Load Status
Regular Availability
FAQs & Tips
Password Changer
Support services
About the Data Warehouse
Data Administration
Express Mail
General Ledger
Learning Management
Position Inventory
Research-PennERA Proposals
Salary Management
Travel Expense Management
Tuition Distribution

Salary Management Collection Refresh Schedule

Biographical, role and job data from PennWorks and the mainframe Payroll system 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, role, 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), 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 PennWorks system, as well as the mainframe Payroll and Salary Management systems. The data in this Universe includes biographical information about employees, information on their roles/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 salaries. 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.

PennWorks-specific data is available from November 2009 and onward.

  Collection Information:

Information Systems and Computing
University of Pennsylvania
Comments & Questions

Penn Computing University of Pennsylvania
Information Systems and Computing, University of Pennsylvania