The sample report below identifies the base pay at COB on both 06/30/2004 and 07/01/2004 for active employees in their same position sequence. Generating the report requires several steps which are described below.
Psn 06/30 07/01
ssa Name seq basepay basepay
---- --- --- ------- -------
123-45-6789 BEAR, JOHN 01 $2,700.00 $2,768.00
Step 1
Generate a current status Employment History (EH) file to identify the employee's salary as of close of business on 06/30/2004. The selections for the extract would be:
SSN option - ALL SSN's
date type - effective FROM 040630 TO 040630
file type - current status
Output file - eh
Note: Selecting the ALL SSN option may result in an file size that exceeds the space limitations. If that occurs, contact the CIRS Hotline for assistance.
Step 2
After confirming a successful extract, write and execute a report request that holds the required 06/30 data for active and onleave positions to one of your permanent hold files (e.g., PERMLRG). This step must be executed before Step 3 otherwise your data will be overwritten.
ex eh
table file eh
print eh:ssa eh:wname eh:psnseq eh:basepay
if eh:sepcode eq ' ' or 't'
on table hold as permlrg
end
Step 3
Generate another EH extract to identify the employee's salary as of close of business on 07/01/2004. The selections for the extract would be:
SSN option - ALL SSN's
date type - effective FROM 040701 TO 040701
file TYPE - current status
Output file- eh
Step 4
After confirming a successful extract, write and execute a match request for PERMLRG file containing the 06/30 data and the EH file containing 07/01 data and save the matched data to another one of your permanent hold files (e.g., PERMRPT).
ex eh
-* 06/30 data from permlrg file
match file permlrg
print eh:basepay AS 0630BASE
BY eh:ssa
BY EH:WNAME
BY EH:psnseq
run
-*
-* 07/01 data from eh file
file eh
match file permlrg
print eh:basepay AS 0701BASE
BY eh:ssa
BY EH:WNAME
BY EH:psnseq
if eh:sepcode eq ' ' or 't'
after match hold as permrpt
old-AND-new
end
Step 5
Generate the final report from the matched data held in PERMRPT.
Table file permrpt
print 0630BASE as '06/30,basepay'
0701BASE as '07/01,basepay'
BY EH:SSA as 'ssa'
BY EH:WNAME as 'name'
BY EH:PSNSEQ as 'psn'
END
The entire report request (steps 4 and 5) is available in the common library as FOC4005. For more information on the EH extract, refer to your CIRS User Manual.