Topics Map > Human Resource System (HRS) > Payroll

Managing Workstudy Awards in HRS

Overview

Campus Financial Aid Offices are responsible for inputting federal work study award information into HRS. The awards may be entered into HRS by either direct entry into the Award Table or via the Inbound File Upload batch process. This user procedure will describe how federal work study student award information is set up, maintained, and processed in HRS.

You may click on the links below to navigate directly to a section:

Instructions for Direct Entry into the Award Table

Navigate to Payroll for North America > Payroll Processing USA > UW Work Study > Work Study Award Table
Click on Add a New Value.
Enter an Empl ID, Business Unit, Year, and Session.
Click on the Add button.
The new Award Table will be displayed.
Enter the Award Amount and Select Save.
- The Begin Date and End Date are not editable fields. They are system derived based on the Business Unit, Year, and Session selected.
- The Award Balance will refresh once you select Save.

To the top

Instructions for Inbound File Upload Batch Process

Navigate to: Inbound File Upload > Inbound File Uploads/Errors
The Inbound File Uploads page will display.
Click on the Add/Plus button to insert a new row.
In the File Type column in the new row, select Work study from the drop-down list.
Enter a File Description and Business Unit
Click on the paper clip.
The file search page will display.
Press the Browse button to locate the file to be uploaded. Note: the file must be saved with a .csv extension
Press the Upload button. You will be returned to the Inbound File Uploads page.
- Financial Aid Administrators should check the Approved for Processing checkbox.
- The file upload process runs nightly Sunday through Thursday.
Select Save.

To the top

Checking for Error files

Awards which cannot be processed will result in an error file. It will be the responsibility of Financial Aid to log back into HRS to check to see if an Error file was created as part of the Inbound Interface process. No automated notification will be generated.

Navigate to Inbound File Upload > Inbound File Uploads/Errors
The Inbound File Uploads page will display. Select the Upload Errors tab.
Look for an Attached Error file. If one exists, it will be named the same as the Inbound File originally uploaded with _err added to the end. To make it easier to find a file, click on any of the headings to resort.
Double click on a file to open.
- Financial Aid Administrators will need to determine the error. If necessary, Awards can then be updated online on the Award Table or saved with a different file name and re-processed through the Inbound File Upload page.

Types of Errors:

The social security number in the file matches more than one employee in HRS.

Data elements are missing or invalid: Award Year, Award Session, etc.

Requested change to award amount is forcing the balance negative.

To the top

Deleting an Award

Navigate to Payroll for North America > Payroll Processing USA > UW Work Study > Work Study Award Table
Enter an Empl ID and hit Search. The Award will be displayed.
Click on the (-) button.
An Alert message will display. This is a check to make sure you really want to delete the Award. Click OK.

NOTE: An award cannot be deleted if there has been any activity against it. You will receive an error message.
The Begin Date and End Date are removed. The Award Amount and Award Balance become $0.00.
Click on Save.

To the top

Job Extension

In addition to the existence of a Award, there are two more pieces of information which must be set up at an employee level: the Funded Indicator (Yes/No) and Job Type. This information will be maintained by HR/Payroll Coordinators and Financial Aid at the time of hire. HRS will default a row into the Job Extension from values selected by the Campus Financial Aid Office. The default is added ONLY on the first Job row when the employee class is SH-Student Hourly.

To enter a new value:

Navigate to Payroll for North America > Payroll Processing USA > UW Work Study > Work Study Job Extension Table
The Search Page will display.
Enter an Empl ID and hit Search.
The Job Extension Table will display.
Verify the Funded Indicator (Checkbox equals Yes, payments on empl record will liquidate work study award) and Job Type.

If one or both values need to be changed:

Click on the Plus Sign

Select a new Effective Date

Status will be Active

Select correct values

Click Save

To the top

Funding Distribution Process

The program to update awards and distribute work study funding will normally occur as part of the post-confirmation job stream for every bi-weekly payroll.

Outbound File Creation Process

Award balance and payment information is made available to Financial Aid Administrators through an Outbound Interface file after each bi-weekly payroll. This file can be uploaded back into the Financial Aid systems to keep them in sync with HRS. The Outbound Interface is not part of any batch processes. Financial Aid Administrators will need to run on an ad hoc basis by following these steps:

Navigate to Payroll for North America > Payroll Processing USA > UW Work Study > Work Study Outbound Interface
The Search page will display.
Enter a Run Control or press the Search button and the Outbound Interface run control page will display.
Enter all of the required parameters: Business Unit, Year, Session, and Pay Run ID
Press the Run button.
Use the Process Monitor and View Log/Trace, see KB Viewing the Process Monitor in HRS
Click on .stdout to open the file.
- This file contains information on the number of rows in the file or if there were any errors. You can close this page after viewing.
Click on the .dat file. This contains the award balance and payment output.