FND Design Data [Home] [Help]

Table: PER_POS_STRUCTURE_ELEMENTS

Product: PER - Human Resources
Description: Position hierarchy details showing parent-child reporting relationships between positions.
Implementation/DBA Data: TableHR.PER_POS_STRUCTURE_ELEMENTS
Primary Key: PER_POS_STRUCTURE_ELEMENTS_PK
  1. ColumnPOS_STRUCTURE_ELEMENT_ID
Primary Key: PER_POS_STRUCTURE_ELEMENTS_UK2
  1. ColumnPOS_STRUCTURE_VERSION_ID
  2. ColumnSUBORDINATE_POSITION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_POS_STRUCTURE_ELEMENTS FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_POS_STRUCTURE_ELEMENTS.BUSINESS_GROUP_ID
PER_POS_STRUCTURE_ELEMENTS FK Joins to TablePER_POS_STRUCTURE_VERSIONS PER_POS_STRUCTURE_ELEMENTS.POS_STRUCTURE_VERSION_ID
PER_POS_STRUCTURE_ELEMENTS FK Joins to TablePER_ALL_POSITIONS PER_POS_STRUCTURE_ELEMENTS.SUBORDINATE_POSITION_ID
PER_POS_STRUCTURE_ELEMENTS FK Joins to TablePER_ALL_POSITIONS PER_POS_STRUCTURE_ELEMENTS.PARENT_POSITION_ID