Sample Request: 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. Alternately, you can refer to the training module titled 'Holding & Matching Data' from the Advanced Reporting Agenda.