FND Design Data [Home] [Help]

Table: PER_POSITION_LIST

Product: PER - Human Resources
Description: List of positions that a secure user can access.
Implementation/DBA Data: TableHR.PER_POSITION_LIST
Primary Key: PER_POSITION_LIST_PK
  1. ColumnSECURITY_PROFILE_ID
  2. ColumnPOSITION_ID
Primary Key: PER_POSITION_LIST_UK1
  1. ColumnSECURITY_PROFILE_ID
  2. ColumnPOSITION_ID
  3. ColumnUSER_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_POSITION_LIST FK Joins to TablePER_SECURITY_PROFILES PER_POSITION_LIST.SECURITY_PROFILE_ID
PER_POSITION_LIST FK Joins to TablePER_ALL_POSITIONS PER_POSITION_LIST.POSITION_ID