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
Last Updated: March 1, 2024