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
For another example of the using the HIGHEST command, refer to the topic: Ranking Sort Field Values. For additional information on the HIGHEST command, refer to your FOCUS documentation.