Identifying The Most Recent Appointment

​​The sample report request below identifies the most recent temporary appointment (Transaction Code = A52) within a position sequence for an employee.  It uses the HIGHEST 1 command to select only the most recent A52 transaction and prints the position number, salary and time base for that transaction.    

 

EX TR

TABLE FILE TR

PRINT TR:EFFDATE TR:TRANCODE TR:POSIT16 TR:SALARY TR:TIMEBASE

BY TR:SSA

BY TR:WNAME

BY TR:PSNSEQ

BY HIGHEST 1 TR:EFFDATE

IF TR:TRANCODE EQ A52

END




Last Updated: March 1, 2024