Search Results per_assessment_types




Overview
Explore in AI Chat

Overview

The PER_ASSESSMENT_TYPES table is a core data definition table within the Oracle E-Business Suite Human Resources (PER) module, specifically for Oracle EBS 12.1.1 and 12.2.2. It serves as the master repository for defining assessment templates. An assessment template provides a standardized structure for evaluating various aspects of an employee, such as competencies, objectives, or skills. This table is fundamental to the performance management and talent review processes, enabling organizations to create consistent, repeatable evaluation frameworks. The table's definition is owned by the HR schema and is a validated object within the application's data model.

Key Information Stored

The table stores the metadata that defines the characteristics of an assessment. While the full column list is not provided in the excerpt, the documented primary and foreign keys reveal critical fields. The primary identifier is ASSESSMENT_TYPE_ID. Each template must have a unique NAME within a specific BUSINESS_GROUP_ID, which links the template to an organizational unit. The table also references rating scales via RATING_SCALE_ID and WEIGHTING_SCALE_ID foreign keys, defining the scoring mechanism and the method for weighting different assessment components. Other typical columns (inferred from standard functionality) would include descriptive fields, effective dating columns (EFFECTIVE_START_DATE, EFFECTIVE_END_DATE), and attributes controlling the assessment's behavior and visibility.

Common Use Cases and Queries

This table is central to configuring and reporting on performance management. Common use cases include administering the library of available assessment templates, linking templates to appraisal forms, and analyzing the types of assessments conducted across the enterprise. A frequent reporting need is to list all active assessment templates within a business group, which can be achieved with a query such as: SELECT name, assessment_type_id FROM per_assessment_types WHERE business_group_id = :p_bg_id AND SYSDATE BETWEEN effective_start_date AND NVL(effective_end_date, SYSDATE). For technical integrations or data fixes, one might join to child tables like PER_ASSESSMENTS to update or validate data based on the template definition. Understanding the rating scale associations is also crucial for interpreting assessment scores in downstream reports.

Related Objects

PER_ASSESSMENT_TYPES has defined relationships with several key HR tables, as documented by its foreign key constraints. It is a parent table to multiple transactional and configuration objects:

  • PER_APPRAISAL_TEMPLATES: Links via ASSESSMENT_TYPE_ID and OBJECTIVE_ASMNT_TYPE_ID. This defines which assessment templates are used for competency and objective evaluations within an appraisal form.
  • PER_ASSESSMENTS: Links via ASSESSMENT_TYPE_ID. Each individual assessment record (e.g., for an employee) references its template definition here.
  • PER_COMPETENCE_ELEMENTS: Links via ASSESSMENT_TYPE_ID. This associates competence elements (skills, competencies) with specific assessment templates.

Furthermore, it is a child table to:

  • HR_ALL_ORGANIZATION_UNITS: Links via BUSINESS_GROUP_ID, securing the template to an organization.
  • PER_RATING_SCALES: Links via RATING_SCALE_ID and WEIGHTING_SCALE_ID, providing the scoring scales for the assessment.