Table: PER_RATING_LEVELS

Product:	PER - Human Resources
Description:	A rating scale step is a single point on a rating scale and is used to rate competences.
Implementation/DBA Data:	HR.PER_RATING_LEVELS

Primary Key: PER_RATING_LEVELS_PK

1. RATING_LEVEL_ID

Primary Key: PER_RATING_LEVELS_UK2

1. RATING_SCALE_ID
2. COMPETENCE_ID
3. STEP_VALUE

Primary Key: PER_RATING_LEVELS_UK3

1. RATING_SCALE_ID
2. COMPETENCE_ID
3. NAME

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_RATING_LEVELS		PER_RATING_SCALES	PER_RATING_LEVELS.RATING_SCALE_ID
PER_RATING_LEVELS		HR_ALL_ORGANIZATION_UNITS	PER_RATING_LEVELS.BUSINESS_GROUP_ID
PER_RATING_LEVELS		PER_COMPETENCES	PER_RATING_LEVELS.COMPETENCE_ID
AHL_RESOURCE_SKILLS		PER_RATING_LEVELS	AHL_RESOURCE_SKILLS.RATING_LEVEL_ID
PER_APPRAISALS		PER_RATING_LEVELS	PER_APPRAISALS.OVERALL_PERFORMANCE_LEVEL_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_RATING_LEVELS	PER_COMPETENCE_ELEMENTS.PROFICIENCY_LEVEL_ID
PER_COMPETENCE_ELEMENTS		PER_RATING_LEVELS	PER_COMPETENCE_ELEMENTS.HIGH_PROFICIENCY_LEVEL_ID
PER_PERFORMANCE_RATINGS		PER_RATING_LEVELS	PER_PERFORMANCE_RATINGS.PERFORMANCE_LEVEL_ID