FND Design Data [Home] [Help]

Table: PER_PAY_BASES

Product: PER - Human Resources
Description: Definitions of specific salary bases.
Implementation/DBA Data: TableHR.PER_PAY_BASES
Primary Key: PER_PAY_BASES_PK
  1. ColumnPAY_BASIS_ID
Primary Key: PER_PAY_BASES_UK2
  1. ColumnNAME
  2. ColumnBUSINESS_GROUP_ID
Primary Key: PER_PAY_BASES_UK3
  1. ColumnINPUT_VALUE_ID
  2. ColumnRATE_ID
  3. ColumnBUSINESS_GROUP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_PAY_BASES FK Joins to TablePAY_RATES PER_PAY_BASES.RATE_ID
PER_PAY_BASES FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_PAY_BASES.BUSINESS_GROUP_ID
TableHR_ALL_POSITIONS_F FK Joins to PER_PAY_BASES HR_ALL_POSITIONS_F.PAY_BASIS_ID
TablePAY_ELEMENT_LINKS_F FK Joins to PER_PAY_BASES PAY_ELEMENT_LINKS_F.PAY_BASIS_ID
TablePER_ALL_ASSIGNMENTS_F FK Joins to PER_PAY_BASES PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID
TablePQH_POSITION_TRANSACTIONS FK Joins to PER_PAY_BASES PQH_POSITION_TRANSACTIONS.PAY_BASIS_ID