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.
MATCH FILE AC
sum ac:wname ac:cbid
by ph:ssa as 'ac:ssa'
if PH:dedcode eq 360
if ph:payperiod eq 200609
after match hold as permrpt old
Table file permrpt
"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'
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