Hi experts
I am trying to build an HR hierarchy that i need to know who manages what.
For example I have a list of managers:
| MangerID | Department | Department ID | Location | LocationID |
|---|
| 1 | Total Products | 0 | World | 1 |
| 123 | Clothing | 1 | USA | 1011 |
| 321 | Woman's Clothing | 20 | World | 1 |
| 213 | Man's Clothing | 30 | Asia | 1003 |
| 312 | Shoes | 2 | North America | 1000 |
For Each Employee
| EmployeeID | Department | Department ID | Location | Location ID | | Header 7 |
|---|
| 456 | Women's Sweater | 2025 | NYC | 100001 | | |
| 564 | Boots | 3075 | Vancouver | 100070 | | |
| 654 | Men's ties | 4073 | Hongkong | 100084 | | |
| 444 | underwear | 252 | Chicago | 100045 | | |
| 555 | Sleepwear | 111 | USA | 1011 | | |
I do have the hierarchy for the department and location
| Department ID | Parent ID |
|---|
| 2025 | 20 |
| 20 | 1 |
| 30 | 1 |
| 3075 | 2 |
| 1 | 0 |
| 4073 | 30 |
| 252 | 1 |
| 111 | 1 |
| 2 | 0 |
| Location ID | Parent Location ID |
|---|
| 1011 | 1000 |
|---|
| 1000 | 1 |
|---|
| 10001 | 1000 |
|---|
| 100084 | 1003 |
|---|
| 100074 | 1000 |
|---|
| 100045 | 1000 |
|---|
| 100070 | 1000 |
|---|
| 1000 | 1 |
|---|
How do I create a model so it rolls up and I can tell who is under the manager given? Or do i need more information to get what i want?
thanks!
