FND Design Data [Home] [Help]

Table: HR_ALL_POSITIONS_F

Product: PER - Human Resources
Description: Position definition information.
Implementation/DBA Data: TableHR.HR_ALL_POSITIONS_F
Primary Key: HR_ALL_POSITIONS_F_PK
  1. ColumnPOSITION_ID
  2. ColumnEFFECTIVE_START_DATE
  3. ColumnEFFECTIVE_END_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
HR_ALL_POSITIONS_F FK Joins to TablePER_GRADES HR_ALL_POSITIONS_F.ENTRY_GRADE_ID
HR_ALL_POSITIONS_F FK Joins to TablePER_SHARED_TYPES HR_ALL_POSITIONS_F.AVAILABILITY_STATUS_ID
HR_ALL_POSITIONS_F FK Joins to TablePER_PAY_BASES HR_ALL_POSITIONS_F.PAY_BASIS_ID
HR_ALL_POSITIONS_F FK Joins to TableHR_LOCATIONS_ALL HR_ALL_POSITIONS_F.LOCATION_ID
HR_ALL_POSITIONS_F FK Joins to TablePER_JOBS HR_ALL_POSITIONS_F.JOB_ID
HR_ALL_POSITIONS_F FK Joins to TablePER_POSITION_DEFINITIONS HR_ALL_POSITIONS_F.POSITION_DEFINITION_ID
HR_ALL_POSITIONS_F FK Joins to TableHR_ALL_ORGANIZATION_UNITS HR_ALL_POSITIONS_F.BUSINESS_GROUP_ID
HR_ALL_POSITIONS_F FK Joins to TableHR_ALL_ORGANIZATION_UNITS HR_ALL_POSITIONS_F.ORGANIZATION_ID