Table: PER_COMPETENCE_ELEMENTS

Product:	PER - Human Resources
Description:	A competence element is used to record an individual competence and an evaluation rating.
Implementation/DBA Data:	HR.PER_COMPETENCE_ELEMENTS

Primary Key: PER_COMPETENCE_ELEMENTS_PK

1. COMPETENCE_ELEMENT_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_COMPETENCE_ELEMENTS		PER_COMPETENCES	PER_COMPETENCE_ELEMENTS.COMPETENCE_ID
PER_COMPETENCE_ELEMENTS		HR_ALL_ORGANIZATION_UNITS	PER_COMPETENCE_ELEMENTS.ORGANIZATION_ID
PER_COMPETENCE_ELEMENTS		PER_ASSESSMENTS	PER_COMPETENCE_ELEMENTS.ASSESSMENT_ID
PER_COMPETENCE_ELEMENTS		PER_ASSESSMENT_TYPES	PER_COMPETENCE_ELEMENTS.ASSESSMENT_TYPE_ID
PER_COMPETENCE_ELEMENTS		PER_RATING_LEVELS	PER_COMPETENCE_ELEMENTS.RATING_LEVEL_ID
PER_COMPETENCE_ELEMENTS		PER_RATING_LEVELS	PER_COMPETENCE_ELEMENTS.WEIGHTING_LEVEL_ID
PER_COMPETENCE_ELEMENTS		PER_COMPETENCE_ELEMENTS	PER_COMPETENCE_ELEMENTS.PARENT_COMPETENCE_ELEMENT_ID
PER_COMPETENCE_ELEMENTS		PER_VALID_GRADES	PER_COMPETENCE_ELEMENTS.VALID_GRADE_ID
PER_COMPETENCE_ELEMENTS		HR_ALL_ORGANIZATION_UNITS	PER_COMPETENCE_ELEMENTS.BUSINESS_GROUP_ID
PER_COMPETENCE_ELEMENTS		HR_ALL_ORGANIZATION_UNITS	PER_COMPETENCE_ELEMENTS.ENTERPRISE_ID
PER_COMPETENCE_ELEMENTS		PER_QUALIFICATION_TYPES	PER_COMPETENCE_ELEMENTS.QUALIFICATION_TYPE_ID
PER_COMPETENCE_ELEMENTS		PER_RATING_LEVELS	PER_COMPETENCE_ELEMENTS.PROFICIENCY_LEVEL_ID
PER_COMPETENCE_ELEMENTS		PER_RATING_LEVELS	PER_COMPETENCE_ELEMENTS.HIGH_PROFICIENCY_LEVEL_ID
PER_COMPETENCE_ELEMENTS		PER_JOBS	PER_COMPETENCE_ELEMENTS.JOB_ID
PER_COMPETENCE_ELEMENTS		PER_ALL_POSITIONS	PER_COMPETENCE_ELEMENTS.POSITION_ID
PER_COMPETENCE_ELEMENTS		PER_COMPETENCE_ELEMENTS	PER_COMPETENCE_ELEMENTS.PARENT_COMPETENCE_ELEMENT_ID
PER_COMP_ELEMENT_OUTCOMES		PER_COMPETENCE_ELEMENTS	PER_COMP_ELEMENT_OUTCOMES.COMPETENCE_ELEMENT_ID