FND Design Data [Home] [Help]

Table: PER_POSITION_STRUCTURES

Product: PER - Human Resources
Description: Position Hierarchy names.
Implementation/DBA Data: TableHR.PER_POSITION_STRUCTURES
Primary Key: PER_POSITION_STRUCTURES_PK
  1. ColumnPOSITION_STRUCTURE_ID
Primary Key: PER_POSITION_STRUCTURES_UK2
  1. ColumnNAME
  2. ColumnBUSINESS_GROUP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_POSITION_STRUCTURES FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_POSITION_STRUCTURES.BUSINESS_GROUP_ID
TablePER_POS_STRUCTURE_VERSIONS FK Joins to PER_POSITION_STRUCTURES PER_POS_STRUCTURE_VERSIONS.POSITION_STRUCTURE_ID
TablePER_SECURITY_PROFILES FK Joins to PER_POSITION_STRUCTURES PER_SECURITY_PROFILES.POSITION_STRUCTURE_ID
TablePQH_ROUTING_CATEGORIES FK Joins to PER_POSITION_STRUCTURES PQH_ROUTING_CATEGORIES.POSITION_STRUCTURE_ID