SIP Batch Load Process
For most units, the distributed CPBS Web SIP interface will serve as the primary environment for assignment of SIP awards.
The batch load process is being made available to units that have a specific need to manage SIP award processing external to the CPBS Web interface. Units that choose the batch load process will be required to meet specific time and technical process requirements. The batch load timeline, requirements and procedures are described below.
SIP Batch Load Timeline
| DATE | DESCRIPTION |
|---|---|
| TBA | SIP Roster report available from the HR Budget datamart (HR>HR Budget Workforce>SIP Roster REPORTS>S010 SIP Roster). Use the results set "R SDU SIP Data Upload" as a starter file for managing your SIP process. |
| TBA | Confirm arrangements with Rose Wright (rfw1@cornell.edu) to participate in the batch load process. |
| TBA | SIP batch load files to registrar's drop box. |
| TBA | Final date for delivery of SIP batch load files. |
| TBA | Last day to review and change individual SIP awards on-line in CPBS |
| TBA | Load SIP awards from CPBS to PeopleSoft (awards effective 7/1/08) |
| TBA | Run HR-OnLine Report (Financial Management > PAY0002 "Salary Improvement Plan") to verify awards |
| TBA | Submission of SIP overrides within HR-Online begins |
Batch Load Procedure
- Indicate your intention to make use of the batch load process to Rose Wright (rfw1@cornell.edu) as soon as possible or by March 28 at the latest.
- Run the SIP Roster report from the HR Budget Brio-Hyperion datamart (HR>HR Budget Workforce>SIP Roster REPORTS>S010 SIP Roster). Use the results set "R SDU SIP Data Upload" as a starter file for managing your SIP process. (All units should have access to SIP reporting in the Budget Data Marts to run this report and to review upload accuracy.)
- Review the "SIP File Format" (pdf) information. Load files must be in the correct format (TXT) when delivered. Files must be named using the following convention, e.g. "EN_L1_UPDATEOFF.TXT":
"EN" - Engineering (Unit identification: AG, EN. HE, VM, AS)
"L1" - Load sequence number. If you need more than one, "L2", etc.
"UPDATEOFF" - Test load for errors. "UPDATEON" is the load file to CPBS/SIP.
- Files must be zipped and password protected before being transferred to the registrar's drop box. The registrar's drop box and instructions for use are available at https://dropbox.cornell.edu/.
The TurboZip utility is available for a nominal fee from CIT. http://www.cit.cornell.edu/software/licenses/turbozip.html
- Upload SIP files to the drop box (dates TBA) and notify Rose Wright (rfw1@cornell.edu).
- Download error reports from the drop box site (error reports will be zipped, password protected and returned to the drop box for all loads). Review the results of the final upload in the budget data mart (Brio-Hyperion Portal -> HR -> HR Budget Workforce -> SIP Awards & Change Reports -> SIP Awards).
- Make any additional required changes to SIP awards using the CPBS Web SIP interface before midnight on the SIP closing date.
The Office of Human Resources has asked that all eligible employees who are not receiving a salary increase have an explanatory note in the "job_pip_note" field, a text field limited to 50 characters. These notations are transmitted to the workforce planning budget data mart for reporting purposes. Please remember that central users and others with security for your department are able to see the notations in CPBS and the budget data mart. Therefore, notations should be brief and appropriate, and pertain to the calculation of the SIP award.
Common Errors
- Final file should be a tab delimited text file (.txt)
- Remove header line before saving and sending
- Deferred awards must be in whole dollar amounts, including hourly paid (non-exempt) employees.
- Make sure that you have awards in the correct numerical format: ######.## for both exempt and non-exempt employees.
For More Information Contact:
Rose Wright
rfw1@cornell.edu
(607) 255-0890