PERSACTION-Position Number?

The PAEMPPOS table may have the position information you are seeking. This table tracks positions, position end dates, position levels (if an employee serves in more than one position) and other information relevant to position tracking.

I hope this information is helpful. We can pursue this subject offline if you want to contact me directly.

Thank you.

Donna Shelton

Thank you, but our customer is insterested in accessing the data "before" it posts to the PAEMPPOS table. My understanding is that the PERSACTION table stored the data before it is processed by the PA100.

I'd be interested to know if there is a translate table or something in a Lawson Data Dictionary that explains how to unravel the data stored in this table if possible.

If the new value is in PERSACTION NEW_VALUE_7, take the value of PERSACTION FLD_NBR_07 and go to PADICT and look at the row(s) where the value in PERSACTION FLD_NBR_07 equals PADICT FLD_NBR. I am not sure which topic you would look at (depends on where the value is coming from), but you can find the correct row by checking the PADICT ITEM_NAME if more than one row is returned. There is a PADICT column called DB_FILE that contains the 3 character table prefix of the table they are getting that value from. I am not sure what this will show when there are multiple positions per employee, but to give you an example, in my case where we only have one position per employee, DB_FILE contains "EMP," which is the prefix of the EMPLOYEE table.

Just FYI, there is also a PADICT2 table that you can look in if you don't find what you are looking for in PADICT.