FND Design Data [Home] [Help]

Table: PER_ASSESSMENTS

Product: PER - Human Resources
Description: The grouping of a set of assessment elements.
Implementation/DBA Data: TableHR.PER_ASSESSMENTS
Primary Key: PER_ASSESSMENTS_PK
  1. ColumnASSESSMENT_ID
Primary Key: PER_ASSESSMENTS_UK1
  1. ColumnGROUP_DATE
  2. ColumnASSESSMENT_TYPE_ID
  3. ColumnPERSON_ID
  4. ColumnASSESSMENT_DATE
  5. ColumnASSESSOR_PERSON_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_ASSESSMENTS FK Joins to TablePER_ASSESSMENT_TYPES PER_ASSESSMENTS.ASSESSMENT_TYPE_ID
PER_ASSESSMENTS FK Joins to TableHR_ALL_ORGANIZATION_UNITS PER_ASSESSMENTS.BUSINESS_GROUP_ID
PER_ASSESSMENTS FK Joins to TablePER_ASSESSMENT_GROUPS PER_ASSESSMENTS.ASSESSMENT_GROUP_ID
PER_ASSESSMENTS FK Joins to TablePER_APPRAISALS PER_ASSESSMENTS.APPRAISAL_ID
TablePER_COMPETENCE_ELEMENTS FK Joins to PER_ASSESSMENTS PER_COMPETENCE_ELEMENTS.ASSESSMENT_ID