We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Fast Formula to extract Manager ID (Person Number)

Accepted answer
13
Views
2
Comments
edited Jan 25, 2021 9:19PM in HCM Integrations 2 comments

Summary

any ideas?

Content

Hello,

In my extract I have assignment ID. How to calculate Manager ID (Person Number)?

Currently we have this value set, but is not working. 

PER_ASSIGNMENT_SUPERVISORS_F MH, PER_ALL_PEOPLE_F PEF, PER_ALL_ASSIGNMENTS_M MA

PEF.PERSON_ID = MH.MANAGER_ID
                          AND MA.PERSON_ID = MH.PERSON_ID
                          AND MA.ASSIGNMENT_TYPE IN ('E','C','P')
                          AND MA.PRIMARY_FLAG = 'Y' 
                          AND EXISTS
                              (SELECT 1 
                              FROM
                              PER_ASSIGNMENT_SUPERVISORS_F PASF
                              WHERE MA.PERSON_ID = PASF.MANAGER_ID)
                          AND TRUNC(SYSDATE) BETWEEN MH.EFFECTIVE_START_DATE AND MH.EFFECTIVE_END_DATE 
                                                  AND TRUNC(SYSDATE) BETWEEN MA.EFFECTIVE_START_DATE AND MA.EFFECTIVE_END_DATE

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!