FND Design Data [Home] [Help]

Table: PER_GRADES

Product: PER - Human Resources
Description: Grade definitions for a business group.
Implementation/DBA Data: TableHR.PER_GRADES
Primary Key: PER_GRADES_PK
  1. ColumnGRADE_ID
Primary Key: PER_GRADES_UK2
  1. ColumnNAME
  2. ColumnBUSINESS_GROUP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_GRADES FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_GRADES.BUSINESS_GROUP_ID
PER_GRADES FK Joins to TablePER_GRADE_DEFINITIONS PER_GRADES.GRADE_DEFINITION_ID
TableAP_POL_SCHEDULE_OPTIONS FK Joins to PER_GRADES AP_POL_SCHEDULE_OPTIONS.ROLE_ID
TableGHR_COMPLAINT_COSTS FK Joins to PER_GRADES GHR_COMPLAINT_COSTS.GRADE_ID
TableGHR_PA_REQUESTS FK Joins to PER_GRADES GHR_PA_REQUESTS.TO_GRADE_ID
TableHR_ALL_POSITIONS_F FK Joins to PER_GRADES HR_ALL_POSITIONS_F.ENTRY_GRADE_ID
TablePAY_ELEMENT_LINKS_F FK Joins to PER_GRADES PAY_ELEMENT_LINKS_F.GRADE_ID
TablePER_ALL_ASSIGNMENTS_F FK Joins to PER_GRADES PER_ALL_ASSIGNMENTS_F.GRADE_ID
TablePER_BUDGET_ELEMENTS FK Joins to PER_GRADES PER_BUDGET_ELEMENTS.GRADE_ID
TablePER_GRADE_SPINES_F FK Joins to PER_GRADES PER_GRADE_SPINES_F.GRADE_ID
TablePER_MM_ASSIGNMENTS FK Joins to PER_GRADES PER_MM_ASSIGNMENTS.GRADE_ID
TablePER_MM_VALID_GRADES FK Joins to PER_GRADES PER_MM_VALID_GRADES.TARGET_GRADE_ID
TablePER_SALARY_SURVEY_MAPPINGS FK Joins to PER_GRADES PER_SALARY_SURVEY_MAPPINGS.GRADE_ID
TablePER_ALL_VACANCIES FK Joins to PER_GRADES PER_ALL_VACANCIES.GRADE_ID
TablePER_VALID_GRADES FK Joins to PER_GRADES PER_VALID_GRADES.GRADE_ID
TablePQH_BUDGET_DETAILS FK Joins to PER_GRADES PQH_BUDGET_DETAILS.GRADE_ID
TablePQH_POSITION_TRANSACTIONS FK Joins to PER_GRADES PQH_POSITION_TRANSACTIONS.ENTRY_GRADE_ID
TablePQH_WORKSHEET_DETAILS FK Joins to PER_GRADES PQH_WORKSHEET_DETAILS.GRADE_ID