I have been racking my brain and gotten stuck.
I have a list of ids. Each id has the manager that incumbent report to.
The list is from CEO down to bottom of org including every employee. (~46k rows)
The list is in no particular order.
What I would like to do is analyses on what level each row/incumbent is from the CEO, CEO = 1, anyone have any ideas how to do this rationally and effectively?
[TABLE="width: 201"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD="align: center"]emp id[/TD]
[TD="align: center"]mngr id[/TD]
[TD="align: center"]emp org level[/TD]
[/TR]
[TR]
[TD="align: center"]2264[/TD]
[TD="align: center"]119[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]3789[/TD]
[TD="align: center"]119[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]5881[/TD]
[TD="align: center"]119[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]100219[/TD]
[TD="align: center"]119[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]100677[/TD]
[TD="align: center"]119[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]7551[/TD]
[TD="align: center"]126[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]11527[/TD]
[TD="align: center"]126[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]100699[/TD]
[TD="align: center"]137[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]111394[/TD]
[TD="align: center"]137[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]26545[/TD]
[TD="align: center"]137[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]26547[/TD]
[TD="align: center"]137[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]26552[/TD]
[TD="align: center"]137[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]26773[/TD]
[TD="align: center"]137[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]174[/TD]
[TD="align: center"]144[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]18061[/TD]
[TD="align: center"]144[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]18062[/TD]
[TD="align: center"]144[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]27645[/TD]
[TD="align: center"]144[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]30912[/TD]
[TD="align: center"]144[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I have a list of ids. Each id has the manager that incumbent report to.
The list is from CEO down to bottom of org including every employee. (~46k rows)
The list is in no particular order.
What I would like to do is analyses on what level each row/incumbent is from the CEO, CEO = 1, anyone have any ideas how to do this rationally and effectively?
[TABLE="width: 201"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD="align: center"]emp id[/TD]
[TD="align: center"]mngr id[/TD]
[TD="align: center"]emp org level[/TD]
[/TR]
[TR]
[TD="align: center"]2264[/TD]
[TD="align: center"]119[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]3789[/TD]
[TD="align: center"]119[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]5881[/TD]
[TD="align: center"]119[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]100219[/TD]
[TD="align: center"]119[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]100677[/TD]
[TD="align: center"]119[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]7551[/TD]
[TD="align: center"]126[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]11527[/TD]
[TD="align: center"]126[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]100699[/TD]
[TD="align: center"]137[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]111394[/TD]
[TD="align: center"]137[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]26545[/TD]
[TD="align: center"]137[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]26547[/TD]
[TD="align: center"]137[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]26552[/TD]
[TD="align: center"]137[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]26773[/TD]
[TD="align: center"]137[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]174[/TD]
[TD="align: center"]144[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]18061[/TD]
[TD="align: center"]144[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]18062[/TD]
[TD="align: center"]144[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]27645[/TD]
[TD="align: center"]144[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]30912[/TD]
[TD="align: center"]144[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]