Active Contract Pay Summary - Dept Access

IUIE Path: Master Catalog: Departmental Reporting > Payroll Reports-Departmental

General Guidelines/Information:

  • Enter your selection criteria in the same format as the examples (dates, department codes).
  • Anytime a Valid Values button appears, you can click it to choose your criteria.
  • Be sure to use CAPS when you enter the selection criteria.
  • The HRMS IUIE information begins with 2003.
  • Your security access is the same as your payroll voucher profile – you should only be able to see employees in your department.
  • Information in the IUIE is one business day old. 
  • You have signed compliance forms agreeing that you will not share this information.  If you are unsure about a particular request, please contact the payroll office.

Active Contract Pay Summary – Dept Access

  1. Employee ID: Enter ID number.
  2. Employee Record Number: Enter job record number.
  3. Select Output Format: This will default to MS Excel (XLS).
  4. Select Output Destination: You should be able to “Wait for Output” as this report runs fairly quickly.
  5. Click the RUN button.

This query can be used to list all activity for contract employees including job, contract, additional pay, and paycheck data. This is very helpful when the contract amounts change in the middle of a contract period. Contract pay is used for student academic and part-time adjunct appointments.


Employee List of Postions

IUIE Path: Master Catalog: Departmental Reporting > Payroll Reports-Departmental

General Guidelines/Information:

  • Enter your selection criteria in the same format as the examples (dates, department codes).
  • Anytime a Valid Values button appears, you can click it to choose your criteria.
  • Be sure to use CAPS when you enter the selection criteria.
  • The HRMS IUIE information begins with 2003.
  • Your security access is the same as your payroll voucher profile – you should only be able to see employees in your department.
  • Information in the IUIE is one business day old. 
  • You have signed compliance forms agreeing that you will not share this information.  If you are unsure about a particular request, please contact the payroll office.

Employee List of Positions

  1. Report Option: Choose “Show Employees” if you want a list of employees or “Count Employees by Department” if you only need a high level count.
  2. Chart: Enter your chart code.
  3. Department code: Enter your 4-character department code (does NOT include the campus/chart prefix).
  4. Appointment Type: Leave blank for ALL or click on the Valid Values button to select from a list.
  5. Order By: Choose the sort order (alphabetic name, ID, or Chart).
  6. Employee Status: This will default to A,L,P (active, leave, partial leave) or click on the Valid Values button to select from a list.
  7. Salary Plan: Leave blank for ALL or click on the Valid Values button to select from a list.
  8. Salary Grade: Leave blank for ALL or click on the Valid Values button to select from a list.
  9. Employee ID: Leave blank for ALL or enter a specific employee id.
  10. Include Funding: This will default to blank. If you want funding information included, check the box.
  11. Select Output Format: This will default to MS Excel (XLS).
  12. Select Output Destination: You should be able to “Wait for Output” as this report runs fairly quick.
  13. Click the RUN button.

This query can be used to create a list of any combination of your employees or count them. Use the selection criteria to specify the exact group you want to select.


Fiscal Approvers/Officer Voucher Report Datagroup

IUIE Path: Master Catalog: Departmental Reporting > Payroll Reports-Departmental

General Guidelines/Information:

  • Enter your selection criteria in the same format as the examples (dates, department codes).
  • Anytime a Valid Values button appears, you can click it to choose your criteria.
  • Be sure to use CAPS when you enter the selection criteria.
  • The HRMS IUIE information begins with 2003.
  • Your security access is the same as your payroll voucher profile – you should only be able to see employees in your department.
  • Information in the IUIE is one business day old. 
  • You have signed compliance forms agreeing that you will not share this information.  If you are unsure about a particular request, please contact the payroll office.

Fiscal Approvers/Officer Voucher Report Datagroup

  1. Chart: not required if you specify account or Fiscal Approver Network ID
  2. Account Number: Not required if you specify Fiscal Approver Network ID
  3. Pay Run ID: Enter the specific run id for the payroll report needed (M001013111, etc)
  4. Fiscal Approver Network ID: Enter the specific userid of the fiscal approver if known
  5. Fin Object Code: leave blank for all or enter a specific object code
  6. Pay Period End Date: leave blank if you entered a specific Pay Run ID
  7. Department ID: Not required if you specify Account numbers or the Fiscal Approver Network ID
  8. Paygroup: leave blank for all or enter specific groups
  9. RC Code: Not required if you specify Fiscal Approver Network ID or Account numbers or Department IDs
  10. Select Columns to Include: If you choose ‘All Columns’, you don’t have to check any of the boxes. If you choose ‘Selected Columns’, you must check each column you want to appear on the output
  11. Maximum Number of Rows to Return: Click the ‘No Limit’ box or you will only get 100 rows returned
  12. Select the Output Format: Choose MS Excel (XLS)
  13. Select the Output Destination: You should be able to “Wait for Output” or you can select “Send Output to Completed Reports”.If the latter is chosen, the report will be in your Completed Reports folder in My Catalog when it’s done running.
  14. Click the RUN button

This datagroup will allow you to enter specific selection criteria to produce the same results as the Fiscal Approvers’ Voucher Audit Report.


HRMS Departmental Security

IUIE Path: Master Catalog: Departmental Reporting > Payroll Reports-Departmental

General Guidelines/Information:

  • Enter your selection criteria in the same format as the examples (dates, department codes).
  • Anytime a Valid Values button appears, you can click it to choose your criteria.
  • Be sure to use CAPS when you enter the selection criteria.
  • The HRMS IUIE information begins with 2003.
  • Your security access is the same as your payroll voucher profile – you should only be able to see employees in your department.
  • Information in the IUIE is one business day old. 
  • You have signed compliance forms agreeing that you will not share this information.  If you are unsure about a particular request, please contact the payroll office.

HRMS Departmental Security

  1. Campus:  Leave blank for click the Valid Values button to select from a list.
  2. Security Role:  Leave blank for ALL or click the Valid Values button to select from a list.
  3. USERID:  Leave blank for ALL or enter a specific value.
  4. Department Id:  Enter your department ID or click the Valid Values button to select from a list.
  5. Select Output Destination:  You should be able to “Wait for Output” or you can select “Send Output to Completed Reports”.  If the latter is chosen, the report will be in your Completed Reports folder in My Catalog when it’s done running.
  6. Click the RUN button.

You can run this query to monitor who has access to payroll information in your department.


HRMS Security Table: My Access

IUIE Path: Master Catalog: Departmental Reporting > Payroll Reports-Departmental

General Guidelines/Information:

  • Enter your selection criteria in the same format as the examples (dates, department codes).
  • Anytime a Valid Values button appears, you can click it to choose your criteria.
  • Be sure to use CAPS when you enter the selection criteria.
  • The HRMS IUIE information begins with 2003.
  • Your security access is the same as your payroll voucher profile – you should only be able to see employees in your department.
  • Information in the IUIE is one business day old. 
  • You have signed compliance forms agreeing that you will not share this information.  If you are unsure about a particular request, please contact the payroll office.

HRMS Security Table: My Access

  1. You don’t need to enter any selection criteria or change the default values shown.
  2. Click the RUN button.

You can run this query to review your access profile in the IUIE. This query can be used to solve security problems if your jobs are not returning any results.


Labor Ledger - Actuals Only

IUIE Path: Master Catalog: Departmental Reporting > Payroll Reports-Departmental

General Guidelines/Information:

  • Enter your selection criteria in the same format as the examples (dates, department codes).
  • Anytime a Valid Values button appears, you can click it to choose your criteria.
  • Be sure to use CAPS when you enter the selection criteria.
  • The HRMS IUIE information begins with 2003.
  • Your security access is the same as your payroll voucher profile – you should only be able to see employees in your department.
  • Information in the IUIE is one business day old. 
  • You have signed compliance forms agreeing that you will not share this information.  If you are unsure about a particular request, please contact the payroll office.

Labor Ledger – Actuals Only

  1. Fiscal Year:  Enter fiscal year(s).
  2. Pay Run ID:  Leave blank for ALL or enter valid payroll run ID.
  3. Pay Period End Date – Begin Range:  Leave blank for ALL or enter specific date in the format shown.
  4. Pay Period End Date – End Range:  Leave blank for ALL or enter specific date in the format shown.
  5. RC Code:  Leave blank for ALL or click on the Valid Values button to select from a list.
  6. Chart Code:  Leave blank or click on the Valid Values button to select from a list.
  7. *Org Code:  Enter your Org cd or click on the Valid Values button to select from a list.
  8. *Account Number:  Leave blank or enter account number(s).
  9. Sub Account:  Leave blank or enter sub account number(s).
  10. Object Code:  Leave blank for ALL or enter specific object codes.
  11. Paygroup:  Leave blank or click on the Valid Values button to select from a list.
  12. Earn Code:  Leave blank or click on the Valid Values button to select from a list.
  13. Employee ID:  Leave blank for ALL or enter specific ID number(s).
  14. Select Output Format:  This will default to MS Excel (XLS).
  15. Select Output Destination:  You should be able to “Wait for Output” or you can select “Send Output to Completed Reports”.  If the latter is chosen, the report will be in your Completed Reports folder in My Catalog when it’s done running.  You usually want to do this for long-running reports.
  16. Click the RUN button.

This query provides results from the Labor Ledger in the KFS. You must be a member of FIS_LD_ALL to have access to this report.


Labor Ledger Empl Summary w Fringes

IUIE Path: Master Catalog: Departmental Reporting > Payroll Reports-Departmental

General Guidelines/Information:

  • Enter your selection criteria in the same format as the examples (dates, department codes).
  • Anytime a Valid Values button appears, you can click it to choose your criteria.
  • Be sure to use CAPS when you enter the selection criteria.
  • The HRMS IUIE information begins with 2003.
  • Your security access is the same as your payroll voucher profile – you should only be able to see employees in your department.
  • Information in the IUIE is one business day old. 
  • You have signed compliance forms agreeing that you will not share this information.  If you are unsure about a particular request, please contact the payroll office.

Labor Ledger Empl Summary with Fringes

  1. Fiscal Year: Enter fiscal year(s).
  2. Campus Code: Leave blank or click on the Valid Values button to select from a list.
  3. RC Code: Leave blank for ALL or click on the Valid Values button to select from a list.
  4. Dept Id:  Enter your department code or click on the Valid Values button to select from a list.
  5. Employee ID:  Leave blank for ALL or enter specific ID number(s).
  6. Position Nbr:  Leave blank for ALL or enter specific position number(s).
  7. Paygroup:  Leave blank or click on the Valid Values button to select from a list.
  8. Salary Plan:  Leave blank for ALL or click on the Valid Values button to select from a list.
  9. Salary Grade:  Leave blank for ALL or click on the Valid Values button to select from a list.
  10. Select Output Format:  This will default to MS Excel (XLS).
  11. Select Output Destination:  You should select “Send Output to Completed Reports”.  The report will be in your Completed Reports folder in My Catalog when it’s done running.  You usually want to do this for long-running reports.
  12. Click the RUN button.

This query provides detailed wage and fringe per ID per earn code from the Labor Ledger file out of the payroll.


Labor Ledger Entry - Actual Data

IUIE Path: Master Catalog: Departmental Reporting > Payroll Reports-Departmental

  • Enter your selection criteria in the same format as the examples (dates, department codes).
  • Anytime a Valid Values button appears, you can click it to choose your criteria.
  • Be sure to use CAPS when you enter the selection criteria.
  • The HRMS IUIE information begins with 2003.
  • Your security access is the same as your payroll voucher profile – you should only be able to see employees in your department.
  • Information in the IUIE is one business day old. 
  • You have signed compliance forms agreeing that you will not share this information.  If you are unsure about a particular request, please contact the payroll office.

Labor Ledger – Actual Data

  1. Employee ID: Leave blank for ALL or enter specific ID number(s).
  2. Pay Run ID: Leave blank for ALL or enter specific Pay Run ID number(s).
  3. Object Code: Leave blank for ALL or enter specific object code(s).
  4. Chart Code: Enter your chart code or click on the Valid Values button to select from a list.
  5. *Org Code: Enter your org code or click on the Valid Values button to select from a list.
  6. *Account Number: Enter your account number or enter specific account number(s).
  7. Earn Code: Leave blank for ALL or enter specific earn code(s).
  8. Fiscal Year: Enter fiscal year(s) – this is a REQUIRED field.
  9. Report Type: Selection will determine the level of detail you will get in the output.
  10. Select Output Format: This will default to MS Excel (XLS).
  11. Select Output Destination: You must select “Send Output to Completed Reports” as this is a long-running report. The report will be in your Completed Reports folder in My Catalog when it’s done running.
  12. Click the RUN button.

This query provides results from the Labor Ledger in the KFS. You must be a member of FIS_LD_ALL to have access to this report.


Last Paycheck Data be Empl Rcd

IUIE Path: Master Catalog: Departmental Reporting > Payroll Reports-Departmental

  • Enter your selection criteria in the same format as the examples (dates, department codes).
  • Anytime a Valid Values button appears, you can click it to choose your criteria.
  • Be sure to use CAPS when you enter the selection criteria.
  • The HRMS IUIE information begins with 2003.
  • Your security access is the same as your payroll voucher profile – you should only be able to see employees in your department.
  • Information in the IUIE is one business day old. 
  • You have signed compliance forms agreeing that you will not share this information.  If you are unsure about a particular request, please contact the payroll office.

Last Paycheck Data by Empl Rcd

  1. Campus Code: Leave blank for ALL, enter your campus code or click on the Valid Values button to select from a list.
  2. RC Code: Leave blank for ALL, enter your RC code or click on the Valid Values button to select from a list.
  3. Department ID: Enter chart-org code or click on the Valid Values button to select from a list.
  4. Paygroup Code: Enter paygroup(s) or click on the Valid Values button to select from a list.
  5. Pay End Date Less Than: Enter date to limit your selection.
  6. Employee ID: Either leave blank and let other selection criteria drive the results, or enter ID number leaving all other selection criteria blank to retrieve info for specific employee.
  7. Select Output Format: This will default to MS Excel (XLS).
  8. Select Output Destination: You should be able to “Wait for Output” or you can select “Send Output to Completed Reports." If the latter is chosen, the report will be in your Completed Reports folder in My Catalog when it’s done running. You usually want to do this for long-running reports.
  9. Click the RUN button.

This query will produce a list of employees that have not been paid based on the date you enter. You can use this information to terminate employees that have not worked for a period of time in your department. It is useful for identifying hourly employees or staff on contract pay that are no longer receiving pay.


Leave Balances - Dept Access

IUIE Path: Master Catalog: Departmental Reporting > Payroll Reports-Departmental

  • Enter your selection criteria in the same format as the examples (dates, department codes).
  • Anytime a Valid Values button appears, you can click it to choose your criteria.
  • Be sure to use CAPS when you enter the selection criteria.
  • The HRMS IUIE information begins with 2003.
  • Your security access is the same as your payroll voucher profile – you should only be able to see employees in your department.
  • Information in the IUIE is one business day old. 
  • You have signed compliance forms agreeing that you will not share this information.  If you are unsure about a particular request, please contact the payroll office.

Leave Balances – Dept. Access

  1. Employee ID: Enter ID number(s).
  2. Processed Date (Less Than): Leave blank for ALL or enter pay period end date.
  3. Processed Date (Greater Than): Leave blank for ALL or enter pay period end date.
  4. Plan Type: Leave blank for ALL balances or select Valid Values.
  5. Select Output Format: This will default to MS Excel (XLS).
  6. Select Output Destination: You should be able to “Wait for Output” as this report runs fairly quick.
  7. Click the RUN button.

This query can be used to list an employee’s leave balances by period end date. This can be used to identify attendance balance problems. If you or one of your employees does not agree with their attendance balance, start with this report. It will list the earned, used, and balance for each pay end date within the date range you identify when running the report.


Paycheck Earn Code Detail - Dept Access

IUIE Path: Master Catalog: Departmental Reporting > Payroll Reports-Departmental

  • Enter your selection criteria in the same format as the examples (dates, department codes).
  • Anytime a Valid Values button appears, you can click it to choose your criteria.
  • Be sure to use CAPS when you enter the selection criteria.
  • The HRMS IUIE information begins with 2003.
  • Your security access is the same as your payroll voucher profile – you should only be able to see employees in your department.
  • Information in the IUIE is one business day old. 
  • You have signed compliance forms agreeing that you will not share this information.  If you are unsure about a particular request, please contact the payroll office.

Paycheck Earn Code Detail – Dept Access

  1. Campus Code: Leave blank for ALL, enter your campus code or click on the Valid Values button to select from a list.
  2. RC Code: Leave blank for ALL, enter your RC code or click on the Valid Values button to select from a list.
  3. Department: Enter chart-org code or click on the Valid Values button to select from a list.
  4. Earn Code: Leave blank for ALL or click on the Valid Values button to select from a list.
  5. Additional Pay Reason Code: Leave blank for ALL or click on the Valid Values button to select from a list.
  6. Paycheck Run ID: Leave blank for ALL or enter payroll run ID(s).
  7. Paycheck Calendar Year: Leave blank if selecting specific Pay Run ID or enter specific year(s).
  8. Paycheck Date Begin Range: Leave blank if selecting specific Pay Run ID or enter specific date in the format shown.
  9. Paycheck Date End Range: Leave blank if selecting specific Pay Run ID or enter specific date in the format shown.
  10. Employee ID: Leave blank for ALL or enter specific ID number(s).
  11. Report Type: Selection will determine the level of detail you will get in the output.
  12. Select Output Format: This will default to MS Excel (XLS).
  13. Select Output Destination: You should select “Send Output to Completed Reports” as this is a long-running report. The report will be in your Completed Reports folder in My Catalog when it’s done running.
  14. Click the RUN button.

This query will return information from paycheck data for your employees based on the selection criteria you enter. You can select specific payrolls, earn codes, or calendar years.


Paycheck Employee Hours - Dept Access

IUIE Path: Master Catalog: Departmental Reporting > Payroll Reports-Departmental

  • Enter your selection criteria in the same format as the examples (dates, department codes).
  • Anytime a Valid Values button appears, you can click it to choose your criteria.
  • Be sure to use CAPS when you enter the selection criteria.
  • The HRMS IUIE information begins with 2003.
  • Your security access is the same as your payroll voucher profile – you should only be able to see employees in your department.
  • Information in the IUIE is one business day old. 
  • You have signed compliance forms agreeing that you will not share this information.  If you are unsure about a particular request, please contact the payroll office.

Paycheck Employee Hours – Dept Access

  1. Employee ID: Enter ID number(s) or leave blank if you want to include ALL employees.
  2. Look at records for the last 12 months: Leave blank for ALL or check the box to limit the results.
  3. Or Range Beginning Date: Leave blank for ALL or enter specific check date in the format shown.
  4. Run ID: Leave blank for ALL or enter specific Payroll Run ID.
  5. Paygroup: Leave blank for ALL or click on the Valid Values button to select from a list.
  6. Chart: Leave blank for ALL or click on the Valid Values button to select from a list.
  7. Department: Leave blank for ALL or click on the Valid Values button to select from a list.
  8. Summary by Earn Code: Leave blank or check the box if you want totals after each earn code (unusual).
  9. Select Output Format: This will default to MS Excel (XLS).
  10. Select Output Destination: You should be able to “Wait for Output” as this report runs fairly quick.
  11. Click the RUN button.

You can use this query to create a detailed spreadsheet of paycheck information for a specific ID or your department based on the selection criteria you enter. It can provide an employee a detailed payroll record report or to determine eligibility for FMLA based on hours worked.


Paycheck No Pay Earn Code Detail

IUIE Path: Master Catalog: Departmental Reporting > Payroll Reports-Departmental

  • Enter your selection criteria in the same format as the examples (dates, department codes).
  • Anytime a Valid Values button appears, you can click it to choose your criteria.
  • Be sure to use CAPS when you enter the selection criteria.
  • The HRMS IUIE information begins with 2003.
  • Your security access is the same as your payroll voucher profile – you should only be able to see employees in your department.
  • Information in the IUIE is one business day old. 
  • You have signed compliance forms agreeing that you will not share this information.  If you are unsure about a particular request, please contact the payroll office.

Paycheck No Pay Earn Code Detail

  1. Campus Code(s): Leave blank for ALL, enter your campus code or click on the Valid Values button to select from a list.
  2. RC Code(s):  Leave blank for ALL, enter your RC code or click on the Valid Values button to select from a list.
  3. Dept Id(s):   Enter your Department code or click on the Valid Values button to select from a list.
  4. Chart Code(s):  Leave blank or click on the Valid Values button to select from a list.
  5. Org Code(s):  Leave blank or click on the Valid Values button to select from a list.
  6. Account Number(s):  Leave blank for all accounts or enter specific accounts
  7. Run ID(s):  Enter a valid Pay Run ID
  8. Earn Codes(s):  Default no-pay earn codes are already entered for you.
  9. Select Output Format: This will default to MS Excel (XLS)
  10. Select Output Destination:  You should select “Send Output to Completed Reports” as this is a long-running report. The report will be in your Completed Reports folder in My Catalog when it’s done running.
  11. Click the RUN button.

This query will produce a list of employees with earn codes that do not pay. This information is only available in paycheck data since ‘no pay’ earn codes do not move to the labor ledger (KFS data).


Payroll Hours Balance BW1 Summary

IUIE Path: Master Catalog: Departmental Reporting > Payroll Reports-Departmental

General Guidelines/Information:

  • Enter your selection criteria in the same format as the examples (dates, department codes).
  • Anytime a Valid Values button appears, you can click it to choose your criteria.
  • Be sure to use CAPS when you enter the selection criteria.
  • The HRMS IUIE information begins with 2003.
  • Your security access is the same as your payroll voucher profile – you should only be able to see employees in your department.
  • Information in the IUIE is one business day old. 
  • You have signed compliance forms agreeing that you will not share this information.  If you are unsure about a particular request, please contact the payroll office.

Payroll Hours Balance BW1 Summary

  1. Pay Period End Date: Enter the ‘Pay Period End Date’ of last BW payroll. If you leave blank, the system will select the last pay period end date.
  2. Campus Code: Leave blank for ALL, enter your campus code or click on the Valid Values button to select from a list.
  3. Department: Enter your chart and 4-character department code or click on the Valid Values button to select from a list.
  4. Negative Balances Only: Leave blank for ALL or click the box to find only the employees that have exceeded their balances.
  5. Break on Voucher Code (Word Only): Unclick the box if you want an alpha listing with no page break on voucher code.
  6. Select Output Format: This will default to MS Excel (XLS), but you can change it to Word-RTF, which will produce a Word document that will have page breaks by department code (unless you unclick the previous box).
  7. Select Output Destination:  You should select “Send Output to Completed Reports” as this is a long-running report. The report will be in your Completed Reports folder in My Catalog when it’s done running..
  8. Click the RUN button.

This query produces a list of biweekly staff employees and their attendance balances for specific pay period end dates. You can also produce a list of employees with negative balances to find where they have exceeded their balance.


Payroll Hours Balance BWP Summary

IUIE Path: Master Catalog: Departmental Reporting > Payroll Reports-Departmental

General Guidelines/Information:

  • Enter your selection criteria in the same format as the examples (dates, department codes).
  • Anytime a Valid Values button appears, you can click it to choose your criteria.
  • Be sure to use CAPS when you enter the selection criteria.
  • The HRMS IUIE information begins with 2003.
  • Your security access is the same as your payroll voucher profile – you should only be able to see employees in your department.
  • Information in the IUIE is one business day old. 
  • You have signed compliance forms agreeing that you will not share this information.  If you are unsure about a particular request, please contact the payroll office.

Payroll Hours Balance BWP Summary

  1. Pay Period End Date: Enter the ‘Pay Period End Date’ of last BW payroll.  If you leave blank, the system will select the last pay period end date.
  2. Campus Code: Leave blank for ALL, enter your campus code or click on the Valid Values button to select from a list.
  3. Department: Enter your chart and 4-character department code or click on the Valid Values button to select from a list.
  4. Negative Balances Only: Leave blank for ALL or click the box to find only the employees that have exceeded their balances.
  5. Break on Voucher Code (Word Only): Unclick the box if you want an alpha listing with no page break on voucher code.
  6. Include Email Address? (Excel Only):  Click on the box if you would like the employee email address included in the excel spreadsheet.
  7. Select Output Format: This will default to MS Excel (XLS), but you can change it to Word-RTF, which will produce a Word document that will have page breaks by department code (unless you unclick the previous box).
  8. Select Output Destination:  You should select “Send Output to Completed Reports” as this is a long-running report. The report will be in your Completed Reports folder in My Catalog when it’s done running.
  9. Click the RUN button.

This query produces a list of biweekly professional (PAO/PAU) staff employees and their attendance balances for specific pay period end dates. You can also produce a list of employees with negative balances to find where they have exceeded their balance.


Work Study Limit of Earnings

IUIE Path: Master Catalog: Departmental Reporting > Payroll Reports-Departmental

General Guidelines/Information:

  • Enter your selection criteria in the same format as the examples (dates, department codes).
  • Anytime a Valid Values button appears, you can click it to choose your criteria.
  • Be sure to use CAPS when you enter the selection criteria.
  • The HRMS IUIE information begins with 2003.
  • Your security access is the same as your payroll voucher profile – you should only be able to see employees in your department.
  • Information in the IUIE is one business day old. 
  • You have signed compliance forms agreeing that you will not share this information.  If you are unsure about a particular request, please contact the payroll office.

Work Study Limit of Earnings

  1. Pay Period End Date: Enter the ‘Pay Period End Date’ of last BW payroll.
  2. Chart of Accounts: Enter campus code (CAPS).
  3. Department: Leave blank to print all departments.
  4. Semester Begin Date: Enter the begin date for current WS period (example: Summer = 05/04/2008, Fall 2008 = 08/17/2008).
  5. Semester End Date: Enter the session end date (example: 08/16/2008 for Summer ), or leave blank for Fall.
  6. Work Study Group: Choose Undergrad.
  7. Select Output Format: This will default to MS Excel (XLS), but you can change it to Word-RTF, which will produce a Word document that will have page breaks by department code.
  8. Select Output Destination: You should select “Send Output to Completed Reports” as this is a long-running report. The report will be in your Completed Reports folder in My Catalog when it’s done running.
  9. Click the RUN button.

This query produces a list of work study employees and the limit information. It should be used to monitor their earnings so they do not exceed their limit for the current work study period (academic year or summer).