The report below identifies employees permanently separated effective January 1, 1999 or later. The final results are held to the PERMSML file in a lotus format for downloading.
To identify these employees, a comparison between social security numbers in the Separated Current Status (SP) file and the Active Current Status (AC) file is required. Using the NEW-NOT-OLD match option, employees are selected only if they have a record in the SP file and no records in the AC file.
Note: The AC file is updated weekly, while the SP file is updated monthly. Therefore, it is possible for an employee to separate and be eliminated from the AC file, but not yet have a record in the SP file. For maximum accuracy, run this report soon after the SP file is updated.
EX AC
EX SP
-*
MATCH FILE AC
BY AC:SSA AS 'SSA'
PRINT AC:WNAME
-* AC:WNAME IS only used for verification
RUN
-*
FILE SP
BY SP:SSA AS 'SSA'
PRINT SP:WNAME SP:PSNSEQ SP:EFFDATE SP:TRANCODE SP:POSIT16
IF SP:EFFDATE GE 01011999
AFTER MATCH HOLD AS PERMSML
NEW-NOT-OLD
END
-*
TABLE FILE PERMSML
PRINT SSA SP:WNAME SP:PSNSEQ SP:EFFDATE SP:TRANCODE SP:POSIT16
ON TABLE HOLD AS PERMSML FORMAT LOTUS
END