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.

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).

Last Updated: March 1, 2024