PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 02/03/2016 5:03 PM by  pbelsky
PERSACTION-Position Number?
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
thummel1
Data Analyst II
Fairview Health Services
Veteran Member
(183 points)
Veteran Member
Posts:101


Send Message:

--
02/01/2016 1: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
    Private
    Private
    Veteran Member
    (256 points)
    Veteran Member
    Posts:106


    Send Message:

    --
    02/03/2016 1: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
    Data Analyst II
    Fairview Health Services
    Veteran Member
    (183 points)
    Veteran Member
    Posts:101


    Send Message:

    --
    02/03/2016 3: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
    Sr Analyst Project Manager
    Weyerhaeuser
    Veteran Member
    (215 points)
    Veteran Member
    Posts:75


    Send Message:

    --
    02/03/2016 5: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.
    You are not authorized to post a reply.