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.
Last Updated: March 1, 2024