Sample Request: Employees With & Without A Parking Deduction

The sample report below identifies all your current employees and identifies employees who do and do not have a parking deduction. In order to generate the data, a match is needed between the Active Current Status (AC) file and the Payment History (PH) file for the prior business month. Only a portion of the actual report is shown below. The complete report request is available in the CIRS common library as FOC6010.

CURRENT EMPLOYEES WITH AND WITHOUT A PARKING DEDUCTION

DATA FOR THE PRIOR BUSINESS MONTH

CBID EMPLOYEE SSA DED AMT DED CODE

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

M80 FROG, NANCY 001-00-0000 42.50 360999

R03 Bear, paul 005-00-0000

chetah, jane 000-00-0003 18.00 360999

newt, kathy 001-11-1111

There are 3 parts to this match report request: identifying current employees in the AC file, identifying employees with a parking deduction for the prior business month in the PH file, and generating a report from the matched data.

EX AC

EX PH

MATCH FILE AC

sum ac:wname ac:cbid

by ac:ssa

run

file ph

sum ph:dedamt

by ph:ssa as 'ac:ssa'

by ph:dedid

if PH:dedcode eq 360

if ph:payperiod eq 200609

after match hold as permrpt old

end

Table file permrpt

heading center

"CURRENT EMPLOYEES WITH AND WITHOUT A PARKING DEDUCTION"

"DATA FOR THE PRIOR BUSINESS MONTH"

" "

print ph:dedamt/p8.2s as 'ded amt'

ph:dedid as 'ded code'

by ac:cbid as 'cbid'

by ac:wname as 'employee'

by ac:ssa as 'ssa'

end

Things to note:

The verb SUM is used in the old (AC) portion of the request to get only one record per SSA. If an employee has more than one active position, the CBID retrieved will be the CBID from the latest position sequence.
The verb SUM is used in the new (PH) portion of the request to get only one amount per SSA and deduction code. If an employee has parking fees deducted for more than one organization, both amounts will display on the report.
The match option OLD is used to keep all information from the AC file (current employees) and include any matching information from the PH file (parking deduction data).

For more information about matching files, refer to the Advanced CIRS Workbook, your FOCUS documentation, or call the CIRS Hotline.