Have you ever received a request like the following: Identify all employees who received a promotion per an A64 transaction for the last fiscal year. Provide the effective date of the promotion, their class before and after, along with their salary before and after.
Before you start manually pulling personnel files, save yourself some time and effort by using CIRS to generate worksheets. The worksheets contain all transactions for the employee and position sequence for the specified timeframe and can be used to determine the required information.
Here are the suggested steps:
Identify the social and position sequence number (TR:SSAPSN) of the target employees and hold the data to your permanent hold file named PERMSML.
EX TRTABLE FILE TRPRINT TR:SSAPSNON TABLE HOLD AS PERMSMLIF TR:TRANCODE EQ A64IF TR:EFFDATE FROM 07012000 TO 06302001END
Create an Employment History Extract file for the socials and position sequences held in your PERMSML file. Transactions will only be extracted for the position sequence appended to the social security number. Be sure to select a RELATIVE file type to ensure you capture the 'before' transaction for promotions effective 07/01/2001. The selections for the extract file would be:
SSN'S IN PERMSMLEFFECTIVE DATES FROM 000701 TO 010630RELATIVE FILE TYPEEH OUTPUT FILE
After confirming a successful extract, execute the report request HSTSUMRY from the common library or write your own request (example below). If desired, you could download the data to a spreadsheet and delete unwanted transactions.
EX EHTABLE FILE EHBY EH:SSA BY EH:WNAME BY EH:PSNSEQ BY EH:EFFDATE
PRINT EH:TRANCODE EH:CLASS EH:SALARYEND
Last Updated: February 22, 2024