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.