Get Employee attached to Actor using Landmark Pflow Designer (LPD)

Sort:
You are not authorized to post a reply.
Author
Messages
Woozy
Veteran Member
Posts: 709
Veteran Member
    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
    Basic Member
    Posts: 5
    Basic Member

      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
      Veteran Member
      Posts: 69
      Veteran Member

        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
        Veteran Member
        Posts: 69
        Veteran Member
          Just saw how old this thread was... nevermind.
          You are not authorized to post a reply.