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.

 

Last Updated: October 2, 2006