Penn Computing

Penn Computing

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

  
  UPDATES
Current Load Status
Regular Availability
  
  INFORMATION
FAQs & Tips
Password Changer
Support services
Security
About the Data Warehouse
Data Administration
  
  DATA COLLECTIONS
Advancement
Assets
BRIM
Express Mail
Facilities
Faculty
GAR
General Ledger
Infrastructure
ISSS-iOffice
Learning Management
Position Inventory
Research-PennERA Proposals
Salary Management
Student
Travel Expense Management
Tuition Distribution
Cross-Collection

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:
top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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