We are using the PA340 and selecting the action codes we have created for transfers. However, it brings back a line for every item on the transfer action and is a manual process to sort through and find what I need. Does anyone have the SQL that creates the PA340 Action Listing from the history table? It is almost impossible to get a clean report with the employees' current position and their previous position numbers.