FND Design Data [Home] [Help]

Table: PER_COMPETENCES

Product: PER - Human Resources
Description: A competence is a definition of knowledge, skills, abilities or other charactaristics that a person may possess.
Implementation/DBA Data: TableHR.PER_COMPETENCES
Primary Key: PER_COMPETENCES_PK
  1. ColumnCOMPETENCE_ID
Primary Key: PER_COMPETENCES_UK2
  1. ColumnNAME
  2. ColumnBUSINESS_GROUP_ID
Primary Key: PER_COMPETENCES_UK3
  1. ColumnCOMPETENCE_ALIAS
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_COMPETENCES FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_COMPETENCES.BUSINESS_GROUP_ID
PER_COMPETENCES FK Joins to TablePER_RATING_SCALES PER_COMPETENCES.RATING_SCALE_ID
PER_COMPETENCES FK Joins to TablePER_COMPETENCE_DEFINITIONS PER_COMPETENCES.COMPETENCE_DEFINITION_ID
TableAHL_RESOURCE_SKILLS FK Joins to PER_COMPETENCES AHL_RESOURCE_SKILLS.COMPETENCE_ID
TablePER_COMPETENCE_ELEMENTS FK Joins to PER_COMPETENCES PER_COMPETENCE_ELEMENTS.COMPETENCE_ID
TablePER_COMPETENCE_OUTCOMES FK Joins to PER_COMPETENCES PER_COMPETENCE_OUTCOMES.COMPETENCE_ID
TablePER_RATING_LEVELS FK Joins to PER_COMPETENCES PER_RATING_LEVELS.COMPETENCE_ID