Personnel Action Previous Values in a Flow

We do this all the time, but to get the previous values we simply query the employee data.

What do you mean by query the employee data? Isn't the employee data the new values once the personnel action has been processed?

The values are stored in HRHISTORY. Assuming you are querying against tables, e.g. HRHISTORY or PERSACTHST, you will need to use platform-specific SQL to determine the previous value for a given field.

Query loop to HRHISTORY for the company+employee where fld_nbr = 20 and beg_date < beg_date of current status.
The A_value from the most recent one will be the previous status. Maybe use conditional branch/assignment inside the loop to do this ?

Posted By Ragu Raghavan on 04/30/2012 01:34 PM
Query loop to HRHISTORY for the company+employee where fld_nbr = 20 and beg_date < beg_date of current status.
The A_value from the most recent one will be the previous status. Maybe use conditional branch/assignment inside the loop to do this ?

That's not 100% accurate, as you can have multiple rows for the same beg_date with different seq_nbr.

To clarify my response - I had assumed that your Personnel Action was work-flow enabled. When set up that way, your flow will kick off when the Personnel Action is entered and you can query employee data at that time since the PA hasn't yet finished processing, send your "before" and "after" email notifications, then let the Personnel Action process.
If you aren't work flow enabled and your flow is looking at past actions - then the true, you would have to read the history tables.

Thanks for everyone's responses.  I was actually able to get the PA66.3 working.  This let me query on the actual action and let the Lawson application do the previous value logic.

Once I had the query response, I used Javascript to loop through the results and find the status field and pull the associated pre and new values.  Also because the screen only returns 12 results at once, there was re-querying logic built in to get subsequent pages of results until it finds the status.

result looping:

var n=0;
var fieldName = "";
var found = false;

for (n=0; n <= 11; n++) {
    fieldName =     eval("Transaction3200_PAD_ITEM_NAMEr" + n);
    if (fieldName == "Status"){
        CurrentStatus = eval("Transaction3200_LOG_NEW_VALUEr" + n);
        PreviousStatus = eval("Transaction3200_LOG_PRE_VALUEr" + n);
        found=true;
        break;
    }
}