Search Results participant_id

Overview

The PER_PARTICIPANTS table is a core data object within the Oracle E-Business Suite Human Resources (PER) module, specifically supporting the performance management functionality. As documented in the ETRM, it serves as the master repository for recording all individuals who are participants in an appraisal or assessment process. Its primary role is to establish the fundamental link between a person and a specific appraisal event, enabling the system to track who is being evaluated, by whom, and in what capacity. This table is essential for structuring the workflow and data collection of performance reviews, 360-degree feedback, and other assessment activities within Oracle EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to capture the essential details of an appraisal participant. Its primary key, PARTICIPANT_ID, is the unique system-generated identifier for each participant record. As indicated by the foreign key relationship, the BUSINESS_GROUP_ID column is a critical field that links the participant to a specific business unit within the HR_ALL_ORGANIZATION_UNITS table, enforcing data security and partitioning. While the full column list is not exhaustively detailed in the provided excerpt, typical columns in such a table would include the APPRAISAL_ID (linking to the specific appraisal), PERSON_ID (identifying the individual participant), PARTICIPANT_TYPE (e.g., Appraisee, Manager, Peer, Reviewer), and STATUS to track the participant's progress within the appraisal cycle.

Common Use Cases and Queries

This table is central to reporting and auditing appraisal participation. Common operational use cases include generating lists of all participants for a given appraisal, identifying incomplete assessments by participant status, and managing the appraisal workflow. A typical reporting query would join PER_PARTICIPANTS to the core person tables (like PER_ALL_PEOPLE_F) and the appraisal header table to produce a participant roster. For example, to find all appraisees for a specific manager, one might query the PARTICIPANT_TYPE and link through manager assignment tables. Data from this table is also critical for compliance reporting, demonstrating who was involved in an employee's performance evaluation.

Related Objects

PER_PARTICIPANTS sits at the center of a network of related performance management objects. The documented foreign key explicitly shows its dependency on the HR_ALL_ORGANIZATION_UNITS table via the BUSINESS_GROUP_ID column. Its primary key, PARTICIPANT_ID, is almost certainly referenced by child tables that store the actual assessment scores, comments, or goals (e.g., tables like PER_APPRAISAL_SCORES or PER_ANSWER_VALUES). Furthermore, it has a fundamental relationship with the main appraisal header table (commonly named PER_APPRAISALS) via a foreign key like APPRAISAL_ID, and with the person table (PER_ALL_PEOPLE_F) via PERSON_ID, though these specific relationships are implied by the table's purpose rather than explicitly listed in the provided metadata.