Sample Request: Active Employees With No Activity

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