SIP Brio-Hyperion Standard Reports
The HR Budget Data Mart (accessed through the Brio-Hyperion Portal) has two documents with four standard reports to help you during SIP processing. One report—the SIP Roster—will identify those employees eligible for SIP and the others are reports on entered SIP awards.
The SIP Roster report is available for all Budget HR data mart users—there is no SIP award data on this report. The SIP Awards reports can only be accessed by those users with access to enter SIP awards into CPBS.
Quick Reference for Brio-Hyperion usage (pdf)
The result sets for all the reports may be easily exported to Excel. Note that the result sets include more information than what is presented in the formatted report, you will find account, fund, function and source codes within some of these result sets.
SIP Roster Report
ALL USERS SECURED TO THE HR BUDGET DATA MARTS CAN RUN THIS REPORT. NOTE THAT NO SIP INFORMATION OR AWARDS ARE AVAILALBLE IN THIS REPORT.
S010 SIP Roster REPORT
THIS REPORT WILL NOT RETURN RESULTS UNTIL AFTER
SIP ELIGIBILITY IS SET IN EARLY MARCH.
Run this report to get a roster of all SIP eligible employees within a unit or a department. Only those records that are flagged as SIP eligible or as "W" (Not Evaluated) are in the report. You may remove the limit on the result set
to see all employees - including ineligibles which are blank - in the report).
SIP Eligiblity Codes - called "SIP" on the report:
| SIP | DESCRIPTION | SIP ELIGIBLE |
|---|---|---|
| A | Academic non-faculty | Yes |
| E | Exempt Staff, SIP eligible | Yes |
| F | Faculty, SIP eligible | Yes |
| W | Not evauated during eligibility process, these employees were not in PeopleSoft as of the eligiblity end date of February 28th | No* |
| Z | Executives whose SIP is managed centrally, users may not enter SIP awards | Yes |
| Null (Blank) | These employees were found to be ineligible during the eligiblity process and are not included in the report (can be seen if limit on Brio-Hyperion report "R SIP Roster" is removed) | No |
*Employees flagged as "W" can be changed to an eligible SIP code within CPBS
Result Set:
R SDU SIP Data Upload: Result set for those organizations using the Batch Load (SDU) process.
SIP Awards and Change Reports
THESE REPORTS WILL ONLY RETURN RESULTS FOR PRIOR YEARS UNTIL SIP
ELIGIBILITY IS SET IN EARLY MARCH AND SIP AWARDS ARE APPLIED.
DO NOT RUN THE REPORT 'SIP IMPACT ON COMMITMENT' AFTER JUNE 30TH AS THE CURRENT COMPRATE WILL BE UPDATED BY THE SIP AWARD IN THE BUDGET DATA MART.
This document contains standard reports that SIP secured users can process to check SIP awards and examine the impact of the awards on job commitments and distributions. There are also reports and result sets that can be run to check data integrity. Users cannot change the queries but may use limits within the results and/or table views.
S120 SIP Awards
This report lists the SIP awards within selected PeopleSoft Unit/College IDs or PeopleSoft Department IDs. This report details Merit, Increase to Minimum and Equity SIP Awards, Deferred SIP Awards, Percent Increase and calculates the new Comp Rate.
S130 SIP Impact on Commit
This report details the impact that the SIP awards and other factors (like the Commitment Override) will have on the Job Commitment.
Result Set:
R SIP Bdgt Dist: Result set of SIP awards by account distribution from the budgeted commitment. Account, Fund, Function and Source are included on the result set. Extract to Excel to review the affect of SIP awards on your accounts.
S140 Change in Records
This report details records flagged with a C (change in salary, standard hours or FTE) or M (missing in PeopleSoft and therefore terminated or transferred) that currently have SIP Awards. Limit this report by Unit ID and/or Department ID. Details on changes to, date of changes and extract date (Timekey) are included to better determine course of action.
Result Set:
R SIP Awards on M Records: Result set of all records in all departments with SIP awards on records missing from PeopleSoft (Employees who have terminated or transferred).
For More Information Contact:
Rose Wright
rfw1@cornell.edu