FND Design Data [Home] [Help]

Table: PER_ORG_STRUCTURE_ELEMENTS

Product: PER - Human Resources
Description: Organization hierarchy details showing parent-child reporting relationships between organizations.
Implementation/DBA Data: TableHR.PER_ORG_STRUCTURE_ELEMENTS
Primary Key: PER_ORG_STRUCTURE_ELEMENTS_PK
  1. ColumnORG_STRUCTURE_ELEMENT_ID
Primary Key: PER_ORG_STRUCTURE_ELEMENTS_UK2
  1. ColumnORG_STRUCTURE_VERSION_ID
  2. ColumnORGANIZATION_ID_CHILD
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_ORG_STRUCTURE_ELEMENTS FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_ORG_STRUCTURE_ELEMENTS.BUSINESS_GROUP_ID
PER_ORG_STRUCTURE_ELEMENTS FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_ORG_STRUCTURE_ELEMENTS.ORGANIZATION_ID_PARENT
PER_ORG_STRUCTURE_ELEMENTS FK Joins to TablePER_ORG_STRUCTURE_VERSIONS PER_ORG_STRUCTURE_ELEMENTS.ORG_STRUCTURE_VERSION_ID
PER_ORG_STRUCTURE_ELEMENTS FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_ORG_STRUCTURE_ELEMENTS.ORGANIZATION_ID_CHILD