Skip to Content
0
Former Member
Sep 07, 2007 at 10:42 AM

HR - OM: Extractor to join Organizational Unit and Staffing Assignments

66 Views

Hi experts!!!

I need an extractor that gives me the hierarchy and the Personal ID. Like a join of the Organizational Unit extractor (0ORGUNIT_HR01_HIER) and the Staffing Assignments extractor (0HR_PA_OS_1).

I already saw that the 0ORGUNIT_HR01_HIER extractor give us the relationship between the nodes, but it doesn’t have the staffing assigned to a specific node. I mean, if you have a node that is a SubArea node, you could have the relationship between the nodes (Parent node, Child node and Next Node), and the Personal ID of the person that is assigned to that node.

From the 0HR_PA_OS_1 extractor, we can get the Personal ID that is assigned to a specific Hierarchy level, but we can not take the relationship between the nodes.

So, what I want to get and I don’t have any idea how to, is:

Get something like the resulting table from 0ORGUNIT_HR01_HIER with an additional field, the Personal ID of the assigned person to that node (NODENAME).

Fields for the table:

NODENAME|PARENTID|CHILDID|NEXTID|BEGDATE|ENDDATE| PERNR|

Anyone has faced a problem like this? Can anybody help me?

Thank you,

Hugo