EBS:PO_ EMPLOYEE_ HIERARCHIES_ ALL

describe ： Staff and position hierarchy

Primary Key: PO_EMPLOYEE_HIERARCHIES_PK

1. EMPLOYEE_ID
2. SUPERIOR_ID
3. POSITION_STRUCTURE_ID
4. ORG_ID

Comments:

PO_EMPLOYEE_HIERARCHIES_ALL Contains information about the relationship between an employee and all his supervisors in a specific position hierarchy . This is a kind of “ flat ” Hierarchical employee relationship model .

Each record in the table saves the employee id And the supervisor id.
The relationship between supervisors and employees is determined by the degree of advantage . The employee's direct supervisor is always at the first level . The higher the supervisor is in the chain of command , The higher he ranks each employee .

Oracle Purchasing Use... When looking for managers of employees PO_EMPLOYEE_HIEARCHIES_ALL surface . at present , Approval documents 、 This is required to find the next person to forward the file to and deal with security .Oracle This form will only be used when purchasing positions are used by the whole organization .