Comparing Base Pay On 2 Different Dates

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.