Search Results assessment_group_id

Overview

The PER_ASSESSMENT_GROUPS 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 a master table for defining logical groupings of individuals, primarily for the purpose of facilitating 360-degree reviews. A 360-degree review is a multi-rater feedback process where an employee is assessed by peers, managers, direct reports, and sometimes even customers. This table provides the foundational structure to organize participants—both assessors and subjects—into manageable sets, enabling the systematic administration and execution of these comprehensive performance assessments.

Key Information Stored

The table's primary function is to define and identify each unique assessment group. The most critical column is ASSESSMENT_GROUP_ID, which serves as the unique identifier (primary key) for each group record. While the provided ETRM metadata does not list all columns, typical columns in such a table would include the group's name, an effective start date, a description of the group's purpose, and creation/modification audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE). The ASSESSMENT_GROUP_ID is the essential foreign key referenced by other transactional tables in the assessment process.

Common Use Cases and Queries

The primary use case is the setup and reporting of 360-degree feedback cycles. Administrators create an assessment group to link a set of participants to a specific review event. Common queries involve listing all active assessment groups, identifying participants within a specific group, or joining with the PER_ASSESSMENTS table to report on the status of reviews for a given group. A fundamental query pattern is retrieving group details using the ASSESSMENT_GROUP_ID:

• SELECT * FROM hr.per_assessment_groups WHERE assessment_group_id = <value>;

For reporting, a typical join to the child assessments table would be:

• SELECT gag.name, pa.* FROM hr.per_assessment_groups gag, hr.per_assessments pa WHERE gag.assessment_group_id = pa.assessment_group_id;

Related Objects

The PER_ASSESSMENT_GROUPS table has a direct parent-child relationship with the PER_ASSESSMENTS table, as documented in the provided foreign key metadata. This is the principal relationship for this object.

• PER_ASSESSMENTS: This is the primary transactional table that references PER_ASSESSMENT_GROUPS. The foreign key column PER_ASSESSMENTS.ASSESSMENT_GROUP_ID links each individual assessment record (e.g., a specific review form for one person) back to the logical group to which it belongs (PER_ASSESSMENT_GROUPS.ASSESSMENT_GROUP_ID). This relationship allows all assessments belonging to a single 360-degree review cycle to be managed and reported on collectively.