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
-* 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'
-* the lines below identify all employees with a 505 trans
-* from the tr file
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
-* the lines below create a comma delimited (lotus format)
-* file from the matched data
TABLE FILE PERMLRG
ON TABLE HOLD AS 'PERMRPT' FORMAT LOTUS
For additional information on matching, refer to your FOCUS documentation or call the CIRS Hotline.
Last Updated: December 2, 2003