FND Design Data [Home] [Help]

Table: PAY_ELEMENT_LINKS_F

Product: PAY - Payroll
Description: Eligibility rules for an element type.
Implementation/DBA Data: TableHR.PAY_ELEMENT_LINKS_F
Primary Key: PAY_ELEMENT_LINKS_F_PK
  1. ColumnELEMENT_LINK_ID
  2. ColumnEFFECTIVE_START_DATE
  3. ColumnEFFECTIVE_END_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
PAY_ELEMENT_LINKS_F FK Joins to TablePAY_COST_ALLOCATION_KEYFLEX PAY_ELEMENT_LINKS_F.BALANCING_KEYFLEX_ID
PAY_ELEMENT_LINKS_F FK Joins to TableHR_ALL_ORGANIZATION_UNITS PAY_ELEMENT_LINKS_F.BUSINESS_GROUP_ID
PAY_ELEMENT_LINKS_F FK Joins to TablePAY_ELEMENT_SETS PAY_ELEMENT_LINKS_F.ELEMENT_SET_ID
PAY_ELEMENT_LINKS_F FK Joins to TablePER_PAY_BASES PAY_ELEMENT_LINKS_F.PAY_BASIS_ID
PAY_ELEMENT_LINKS_F FK Joins to TablePER_JOBS PAY_ELEMENT_LINKS_F.JOB_ID
PAY_ELEMENT_LINKS_F FK Joins to TablePER_ALL_POSITIONS PAY_ELEMENT_LINKS_F.POSITION_ID
PAY_ELEMENT_LINKS_F FK Joins to TablePAY_PEOPLE_GROUPS PAY_ELEMENT_LINKS_F.PEOPLE_GROUP_ID
PAY_ELEMENT_LINKS_F FK Joins to TablePAY_COST_ALLOCATION_KEYFLEX PAY_ELEMENT_LINKS_F.COST_ALLOCATION_KEYFLEX_ID
PAY_ELEMENT_LINKS_F FK Joins to TableHR_ALL_ORGANIZATION_UNITS PAY_ELEMENT_LINKS_F.ORGANIZATION_ID
PAY_ELEMENT_LINKS_F FK Joins to TableHR_LOCATIONS_ALL PAY_ELEMENT_LINKS_F.LOCATION_ID
PAY_ELEMENT_LINKS_F FK Joins to TablePER_GRADES PAY_ELEMENT_LINKS_F.GRADE_ID