Search Results per_assessments

Overview

The PER_ASSESSMENTS table is a core data object within the Oracle E-Business Suite Human Resources (PER) module, specifically for versions 12.1.1 and 12.2.2. It serves as the central repository for assessment records, which are defined as the grouping of a set of assessment elements. An assessment is a formal evaluation of an employee's competencies, skills, performance, or other criteria, often conducted as part of a performance appraisal or a standalone review process. The table's primary role is to store the header-level information for each assessment instance, linking it to the assessed person, the assessor, the assessment type, and the relevant organizational context. This foundational table enables the structured capture and analysis of employee development and performance data.

Key Information Stored

The table stores metadata and key identifiers for each assessment record. Critical columns include the primary key ASSESSMENT_ID, which uniquely identifies each assessment. The ASSESSMENT_DATE column, central to the user's search, records the date on which the assessment was conducted or finalized. The table links to individuals via PERSON_ID (the employee being assessed) and ASSESSOR_PERSON_ID (the person conducting the assessment). It categorizes the assessment through ASSESSMENT_TYPE_ID and optionally associates it with a formal appraisal via APPRAISAL_ID. The GROUP_DATE and ASSESSMENT_GROUP_ID columns support the grouping of multiple assessments, while BUSINESS_GROUP_ID provides the organizational security context.

Common Use Cases and Queries

A primary use case is generating reports on assessment activity within a specific time period, leveraging the ASSESSMENT_DATE column. For example, HR analysts may need to list all assessments completed in a given quarter for compliance or review purposes. A typical query would join PER_ASSESSMENTS with PER_ALL_PEOPLE_F to retrieve employee names and filter by date range. Another common scenario is analyzing assessment coverage by department or manager, requiring joins to HR organization tables. Development teams often query this table via custom integrations to extract assessment data for downstream talent management systems. Sample SQL to find assessments for a person after a certain date would be:

• SELECT pa.assessment_id, pa.assessment_date, pa.person_id, papf.full_name FROM hr.per_assessments pa, per_all_people_f papf WHERE pa.person_id = papf.person_id AND pa.assessment_date > TO_DATE('01-JAN-2023','DD-MON-YYYY') AND papf.current_emp_or_apl_flag = 'Y';

Related Objects

The PER_ASSESSMENTS table maintains integral relationships with several other HR objects, as documented by its foreign key constraints. It is a parent table to PER_COMPETENCE_ELEMENTS, where the detailed scores or ratings for individual assessment criteria are stored (joined on ASSESSMENT_ID). It is a child table to multiple reference tables: PER_ASSESSMENT_TYPES (ASSESSMENT_TYPE_ID), which defines the assessment category; HR_ALL_ORGANIZATION_UNITS (BUSINESS_GROUP_ID), for organizational security; PER_ASSESSMENT_GROUPS (ASSESSMENT_GROUP_ID), for assessment bundling; and PER_APPRAISALS (APPRAISAL_ID), linking the assessment to a formal appraisal document. These relationships are essential for constructing complete views of assessment data.