The report below is an example of matching the Active Current Status (AC) file and the Transaction (TR) file. It identifies the name and address of current employees with a 505 (Retirement Status) transaction effective on a specific date. The hold file generated from the match (PERMLRG) is then 'dumped' into another hold file (PERMRPT) and formatted for downloading to Excel for use with a mail merge document. Refer to the comment lines in the report below for additional information.
-* the lines below execute the standard defines for ac & tr
EX AC
EX TR
-* the lines below gather address data for current employees
-* from the ac file
MATCH FILE AC
PRINT AC:FRSTNAME AC:LASTNAME AC:street ac:ctyst ac:zip
BY AC:SSA AS 'SSA'
RUN
-* the lines below identify all employees with a 505 trans
-* from the tr file
file TR
print Tr:wname
BY TR:SSA AS 'SSA'
IF TR:TRANCODE EQ 505
if tr:effdate EQ 10/01/2003
AFTER MATCH HOLD AS 'PERMLRG' OLD-AND-NEW
END
-* the lines below create a comma delimited (lotus format)
-* file from the matched data
TABLE FILE PERMLRG
PRINT *
ON TABLE HOLD AS 'PERMRPT' FORMAT LOTUS
END
For additional information on matching, refer to your FOCUS documentation or call the CIRS Hotline.