• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

PERSACTION-Position Number?

 3 Replies
 2 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
thummel1
Veteran Member
Posts: 121
Veteran Member
2/1/2016 6:34 PM
I am building a report designed to show various field that will be changing in the PERSACTION table. One of the fields I need to display is the Position Number, before and after. I can see where the "After" is (PERSACTION.NEW_VALUE_7), but I am not sure the best way to display the "before". I can see the Process Level and Department as their own data fields, but not Position, which is important because an employee can have up to 5 positions.

Any suggestions on how to display (e.g. data field names and table joins) the original posiiton would be helpful. Thank you!
Donna
Veteran Member
Posts: 110
Veteran Member
2/3/2016 6:59 PM
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


thummel1
Veteran Member
Posts: 121
Veteran Member
2/3/2016 8:07 PM
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.
pbelsky
Veteran Member
Posts: 80
Veteran Member
2/3/2016 10:03 PM
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.