FND Design Data [Home] [Help]

Table: PER_PAY_PROPOSAL_COMPONENTS

Product: PAY - Payroll
Description: Component details of a pay proposal for an employee assignment.
Implementation/DBA Data: TableHR.PER_PAY_PROPOSAL_COMPONENTS
Primary Key: PER_PAY_PROPOSAL_COMPONENT_PK
  1. ColumnCOMPONENT_ID
Primary Key: PER_PAY_PROPOSAL_COMPONENT_UK2
  1. ColumnPAY_PROPOSAL_ID
  2. ColumnCOMPONENT_REASON
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_PAY_PROPOSAL_COMPONENTS FK Joins to TablePER_PAY_PROPOSALS PER_PAY_PROPOSAL_COMPONENTS.PAY_PROPOSAL_ID
PER_PAY_PROPOSAL_COMPONENTS FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_PAY_PROPOSAL_COMPONENTS.BUSINESS_GROUP_ID