The sample report below can be used to identify and audit employees at your campus whose position is active/onleave, but who have not had any transactions effective in the last 5 years. The Active Current Status (AC) file is used to generate the report since it contains only active/onleave positions. The report request is available in the CIRS common library as FOC5005 and can be easily modified to include additional fields, if needed.
Sample Report:
ACTIVE/ONLEAVE employees with no activity since 01/01/2000
Data as of 06/24/2005
EFFECTIVE EMPLOYEE Social CODE TYPE position
--------- -------- ------ ---- ---- --------
07/01/1995 BEAR, CINDY 123-45-6789 645 leave w/o pay 000-111-2905-031
08/20/1998 TURTLE, JOHN 987-65-4321 A52 app0intment 000-000-1800-988
Report Request:
EX AC
TABLE FILE AC
heading center
"active/ONLEAVE employees with no activity since 01/01/2000"
"Data as of <ac:dao"
" "
PRINT AC:effdate as 'effective'
ac:wname as 'employee'
ac:ssa as 'social'
ac:trancode as 'code'
ac:trantype as 'type'
ac:posit16 as 'position'
BY AC:EFFDATE noprint
IF ac:effdate lt 01/01/2000
END