Sample Request: Department Chair Lump Sum Pay

This report can be used to identify faculty employees who received a Department Chair Lump Sum payment of $6,000 as part of a recent settlement agreement. For additional information, refer to Technical Letter HR/Salary 2006-04 on the Systemwide HR website. Only a portion of the actual report is shown below. The complete report request is available in the CIRS common library as FOC6003.

social employee name pay period cls gross pay

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

123-45-6789 penguin, jm 2006/02 2360 $6,000.00

234-56-7890 monkey, ma 2006/02 2482 $6,000.00

The processing instructions in HR/Salary 2006-04 indicate the lump sum payment must be paid to eligible employees as earnings id 'SB', for the February or March 2006 pay periods. In the CIRS payment files, earnings id translates to Payment Type 'S' and Payment Type Suffix 'B' . To identify the payment, you must screen on both those fields, along with the specified pay periods and amount. Also, be sure to include a screening statement for your campus (e.g., WHERE PH:CAMPX EQ X) since the PH file contains payments issued to your employee by other campuses.

EX ph

table file ph

print ph:grosspay

by ph:ssa

by ph:wname

by ph:payperiod

by ph:class

where ph:paymetyp eq 's'

where ph:PAYTYPSF eq 'b'

Where ph:payperiod eq 200602 or 200603

Where ph:grosspay eq 6000

where ph:cbid eq r03

Where PH:CAMPx eq X ( FOR EXAMPLE ONLY - USE YOUR SPECIFIC CAMPUS CODE)

end