Sample Request: R11 Employees Paid 07/2005 To 12/2005

The sample request below identifies current and separated R11 employees who received payments for the July 2005 through December 2005 pay periods and may be useful in tracking their one-time lump sum bonus payment. For more information regarding the bonus, refer to technical letter HR/Salary 2005-13 on the Systemwide HR web site.

PAY HISTORY FOR R11 EMPLOYEES

FOR PAY PERIODS 07/2005 THROUGH 12/2005

pay pay

ssa name period type gross issued

--- ----- ------ ---- ----- ------

111-11-1111 gorilla, jim 2005/07 0 $683.73 2005/08/04

222-22-2222 mARMOT, ron 2005/07 0 $1,288.00 2005/08/01

2005/07 g $54.00 2005/07/26

333-33-3333 Ferret, Pam 2005/07 0 $527.00 2005/08/02

The report is generated using the Payment Extract (PY) file and displays each payment issued for those pay periods along with the payment issue date. Since the new fiscal year just started, the sample report has data only for the prior pay period. The steps for creating the PY extract file and producing the final report are described below. Both of the report requests needed to create the report are located in the CIRS common library as FOC5007A and FOC5007B.

Step 1:

Write a report request using the Transaction Data (TR) file to identify the SSN's of your active and/or separated employees in R11. Include the command ON TABLE HOLD AS PERMSML so the list of SSN's is routed to your PERMSML file. The data must be held specifically to your PERMSML file so that it can be used for the extract in Step 3 below. The report below is available in the CIRS common library as FOC5007A.

EX TR

TABLE FILE TR

PRINT TR:SSA

IF TR:CBID EQ R11

on table hold as permsml

END

Step 2:

Execute the report in either the online or batch environment to populate your PERMSML file with the selected SSN's. Note the number of records held and confirm that's the approximate number expected. If desired, you can browse the list of SSN's in your PERMSML hold file by returning to your main ad hoc reporting screen and pressing the F11 key.

Step 3:

Create a Payment History Extract (PY) file for the SSN's held in your PERMSML file by pressing the F12 key from the main ad hoc reporting screen. At the Payment History Extract process screen, make the following selections and press enter to submit your extract job. Make a note of the job number so you can check the status of your job.

SSN OPTION: (3) SSN'S IN HOLD FILE: PERMSML

DATE TYPE AND RANGE: (2) PAY PERIODS FROM 0507 TO 0512

FILE SOURCE: (2) CURRENT & PRIOR 36 BUSINESS MONTHS

OUTPUT FILE: (1) PY

Step 4:

Write a report using the PY file to select all pay records for CBID R11 for the specified timeframe. The report will include payments for employees who are currently active or separated. The report below is available in the CIRS common library as FOC5007B and can be used as-is or copied to your personal library and modified.

ex py

table file py

HEADING CENTER

"PAY HISTORY FOR R11 EMPLOYEES"

"FOR PAY PERIODS 07/2005 THROUGH 12/2005"

" "

print py:payperiod as 'pay,period'

py:paymetyp as 'pay,type'

py:grosspay as 'gross'

py:issuedte as 'issued'

by py:ssa as 'ssa'

by py:wname as 'name'

by py:payperiod noprint

by highest py:paymetyp noprint

if py:payperiod from 200507 to 200512

if py:cbid eq r11

end

For additional information on writing and executing report requests, generating hold files and creating extract files, please refer to the CIRS User Manual or the Basic Reporting Agenda & Modules.