FND Design Data [Home] [Help]

Table: PER_PARENT_SPINES

Product: PER - Human Resources
Description: Details of pay scales, (previously known as parent spines).
Implementation/DBA Data: TableHR.PER_PARENT_SPINES
Primary Key: PER_PARENT_SPINES_PK
  1. ColumnPARENT_SPINE_ID
Primary Key: PER_PARENT_SPINES_UK2
  1. ColumnNAME
  2. ColumnBUSINESS_GROUP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_PARENT_SPINES FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_PARENT_SPINES.BUSINESS_GROUP_ID
TablePAY_RATES FK Joins to PER_PARENT_SPINES PAY_RATES.PARENT_SPINE_ID
TablePER_CAGR_ENTITLEMENT_LINES_F FK Joins to PER_PARENT_SPINES PER_CAGR_ENTITLEMENT_LINES_F.PARENT_SPINE_ID
TablePER_GRADE_SPINES_F FK Joins to PER_PARENT_SPINES PER_GRADE_SPINES_F.PARENT_SPINE_ID
TablePER_SPINAL_POINTS FK Joins to PER_PARENT_SPINES PER_SPINAL_POINTS.PARENT_SPINE_ID