PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 08/04/2015 2:01 PM by  Peter O
Get Employee attached to Actor using Landmark Pflow Designer (LPD)
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Woozy
Private
Private
Veteran Member
(3469 points)
Veteran Member
Posts:701


Send Message:

--
07/22/2010 11:29 AM
    I am trying to find a way to identify the LTM employee number that is associated with an LTM actor using Landmark ProcessFlow Designer (LPD).

    I have the actor id (not the guid), but I can't figure out how to use a Landmark Transaction node to enter the Actor and return the HROrg and Employee from the Agent business class.

    I've also tried a relationship query from Actor without success.

    I've been able to get the ParentAgent GUID, but I can't seem to pass it into an AGENT query - I get an "Agent Does Not Exist" error.

    Anybody have ideas on this? Thanks.
    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    Angela
    Private
    Private
    Basic Member
    (15 points)
    Basic Member
    Posts:5


    Send Message:

    --
    06/16/2011 1:21 PM

    I am not sure if there is another easier way, but you can do a LM query , module = person and object ID = actor. You can get the actor's email address and from a RM query you get the employee number.
    Peter O
    Systems Analyst
    Independent
    Veteran Member
    (205 points)
    Veteran Member
    Posts:69


    Send Message:

    --
    08/04/2015 2:01 PM

    Hey Woozy,

     

    This works for me:

    select emp.EMPLOYEE
    from LMHCM.hcm.EMPLOYEE emp
    inner join LMHCM.hcm.AGENT agent on (emp.UNIQUEID = agent.BORBUSINESSOBJECTKEY)
    inner join LMHCM.hcm.PARENTAGENT pagent on (agent.PARENTAGENT = pagent.PARENTAGENT)
    where pagent.ACTOR = 'ACTOR_ID'
    
    

     Your mileage may vary, but works 100% on our build.

    Also assumes your employee is completely set up - Actor, Agent, and agent attached to it's proper actor agent. if actor is not attached yet, this won't work.

    -Peter

     

    Peter O
    Systems Analyst
    Independent
    Veteran Member
    (205 points)
    Veteran Member
    Posts:69


    Send Message:

    --
    08/04/2015 2:01 PM
    Just saw how old this thread was... nevermind.
    You are not authorized to post a reply.