​​​​​

Identifying Employees with Multiple Positions

The sample report below identifies current employees with multiple positions in the Active Current Status (AC) file and provides information about each of those positions.  It is generated using the MATCH command.  Each portion of the report request is described below.

 

NAME            SSA          CLASS  FTE      SALARY
----            ---          -----  ---      ------

APE, JOHN       555-55-5555  2355  .500     $400.00

                             2355  .250     $200.00

BEAR, ZOE       003-33-3333  2360  .500   $3,632.00

                             2360  .500   $3,478.50

Step 1:  

The first portion of the match request executes the standard defines for the AC file and counts the number of position sequences for each employee.   

 

EX AC

MATCH FILE AC

COUNT AC:PSNSEQ AS 'PSNCNT'

BY AC:SSA

RUN

Step 2:  

The next portion of the match request gathers data for all positions in the AC file and then matches that data to the position sequence count determined in the first part of the request.  The results of the match are held to PERMRPT.  

 

FILE AC

PRINT AC:WNAME AC:CLASS AC:FTE AC:SALARY

BY AC:SSA

AFTER MATCH HOLD AS PERMRPT

OLD-AND-NEW

END

Step 3:  

After generating your PERMRPT file, verify the results by browsing the file (F11 key), or by executing the following commands:

 

TABLE FILE PERMRPT

PRINT *

END

 

Below is a sample of the matched data in PERMRPT.  Note the number of positions (PSNCNT) held by each SSN is set for each record belonging to that SSN.  

 

AC:SSA      PSNCNT  AC:WNAME   AC:CLASS  AC:FTE  AC:SALARY

------      ------  ---------  --------  ------  ---------

001-11-1111      1  ZEBRA, ED  3312       1.000  $6,000.00

002-22-2222      1  CAT, JIM   2481        .600  $1,945.80

003-33-3333      2  BEAR, ZOE  2360        .500  $3,632.00

003-33-3333      2  BEAR, ZOE  2360        .500  $3,478.50

Step 4:  

The final report is generated from the data held in PERMRPT and selects only those records with a position count (PSNCNT) greater than 1.   

 

TABLE FILE PERMRPT

PRINT AC:CLASS  AS 'CLASS'

      AC:FTE    AS 'FTE'

      AC:SALARY AS 'SALARY'

BY AC:WNAME     AS 'NAME'

BY AC:SSA       AS 'SSA'

IF PSNCNT GT 1

END

 

The entire report request is available in the CIRS common library as FOC4001.  For complete information on matching files, refer to your FOCUS documentation/user manual. ​ Alternately, you can refer to the training module titled 'Holding & Matching Data' from the Advanced Reporting Agenda.

Last Updated: March 1, 2024