Search Results per_performance_reviews
The PER_PERFORMANCE_REVIEWS table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical component of the Oracle Human Capital Management (HCM) module, specifically within the Performance Management functionality. This table stores comprehensive data related to employee performance reviews, evaluations, and appraisals, serving as the backbone for performance tracking, feedback management, and talent development processes. Below is a detailed technical and functional analysis of this table.
1. Table Overview
The PER_PERFORMANCE_REVIEWS table is part of the PER (Personnel) schema in Oracle EBS and is primarily used to store records of employee performance reviews. It captures metadata such as review dates, statuses, participants (e.g., reviewers, employees), and evaluation criteria. The table integrates with other HCM modules like PER_ALL_ASSIGNMENTS and PER_ALL_PEOPLE_F to ensure data consistency across employee records.2. Key Columns and Their Significance
- PERFORMANCE_REVIEW_ID: Primary key, uniquely identifying each performance review record.
- PERSON_ID: Foreign key linking to PER_ALL_PEOPLE_F, associating the review with an employee.
- ASSIGNMENT_ID: Foreign key referencing PER_ALL_ASSIGNMENTS_F, tying the review to a specific job assignment.
- REVIEW_TYPE: Defines the type of review (e.g., annual, probationary, project-based).
- REVIEW_STATUS: Indicates the current state of the review (e.g., "Draft," "Completed," "Approved").
- REVIEW_DATE: The date the review was conducted or scheduled.
- APPRAISAL_TEMPLATE_ID: Links to predefined appraisal templates stored in PER_APPRAISAL_TEMPLATES.
- OVERALL_RATING: Stores the final aggregated rating for the employee’s performance.
3. Functional Integration
The table supports Oracle EBS workflows for performance management by:- Enabling multi-rater feedback (360-degree reviews) through relationships with PER_REVIEWERS.
- Integrating with Oracle Learning Management (OLM) to recommend training based on review outcomes.
- Feeding data to Oracle Advanced Benefits (OAB) for compensation planning.
4. Technical Considerations
- Indexing: Performance-critical columns like PERSON_ID and REVIEW_DATE are indexed to optimize query performance.
- Partitioning: In large deployments, the table may be partitioned by REVIEW_DATE for scalability.
- Audit Trails: Changes to review records are logged in PER_PERFORMANCE_REVIEWS_AUDIT for compliance.
5. Customization and Extensions
Organizations often extend the table via:- Descriptive Flexfields (DFFs): Adding context-sensitive fields like department-specific KPIs.
- APIs: Using PER_PERFORMANCE_REVIEWS_PKG for programmatic review creation/updates.
- Triggers: Automating notifications or approvals based on status changes.
6. Data Security
Access to PER_PERFORMANCE_REVIEWS is controlled via:- Oracle HRMS Security Profiles restricting data visibility by organization hierarchy.
- VPD (Virtual Private Database) policies enforcing row-level security.
7. Reporting and Analytics
The table serves as a primary source for:- Standard Oracle BI Publisher reports (e.g., "Employee Performance Trends").
- Custom dashboards measuring review completion rates or rating distributions.
- ETL feeds to downstream data warehouses for talent analytics.
Conclusion
The PER_PERFORMANCE_REVIEWS table is a foundational element in Oracle EBS HCM, enabling structured performance evaluation processes. Its design supports complex workflows, integrations, and compliance requirements while offering flexibility for organizational customization. Proper understanding of this table is essential for HR system administrators, implementers, and developers working with Oracle Performance Management.-
Table: PER_PERFORMANCE_REVIEWS
12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PER.PER_PERFORMANCE_REVIEWS, object_name:PER_PERFORMANCE_REVIEWS, status:VALID, product: PER - Human Resources , description: Performance review information for employees. , implementation_dba_data: HR.PER_PERFORMANCE_REVIEWS ,
-
Table: PER_PERFORMANCE_REVIEWS
12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PER.PER_PERFORMANCE_REVIEWS, object_name:PER_PERFORMANCE_REVIEWS, status:VALID, product: PER - Human Resources , description: Performance review information for employees. , implementation_dba_data: HR.PER_PERFORMANCE_REVIEWS ,
-
Table: PER_PAY_PROPOSALS
12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PER.PER_PAY_PROPOSALS, object_name:PER_PAY_PROPOSALS, status:VALID, product: PER - Human Resources , description: Salary proposals and performance review information for employee assignments. , implementation_dba_data: HR.PER_PAY_PROPOSALS ,
-
Table: PER_EVENTS
12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PER.PER_EVENTS, object_name:PER_EVENTS, status:VALID, product: PER - Human Resources , description: Record of events such as interviews and appraisals for applicants and employees. , implementation_dba_data: HR.PER_EVENTS ,
-
Table: PER_PAY_PROPOSALS
12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PER.PER_PAY_PROPOSALS, object_name:PER_PAY_PROPOSALS, status:VALID, product: PER - Human Resources , description: Salary proposals and performance review information for employee assignments. , implementation_dba_data: HR.PER_PAY_PROPOSALS ,
-
Table: PER_EVENTS
12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PER.PER_EVENTS, object_name:PER_EVENTS, status:VALID, product: PER - Human Resources , description: Record of events such as interviews and appraisals for applicants and employees. , implementation_dba_data: HR.PER_EVENTS ,
-
View: PER_PAY_PROPOSALS_V2
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PER.PER_PAY_PROPOSALS_V2, object_name:PER_PAY_PROPOSALS_V2, status:VALID, product: PER - Human Resources , description: Used to support user-interface , implementation_dba_data: APPS.PER_PAY_PROPOSALS_V2 ,
-
View: HRFV_REVIEWS
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PER.HRFV_REVIEWS, object_name:HRFV_REVIEWS, status:VALID, product: PER - Human Resources , description: Business view template from which the flexfield view is generated. , implementation_dba_data: APPS.HRFV_REVIEWS ,
-
View: PER_PAY_PROPOSALS_V2
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PER.PER_PAY_PROPOSALS_V2, object_name:PER_PAY_PROPOSALS_V2, status:VALID, product: PER - Human Resources , description: Used to support user-interface , implementation_dba_data: APPS.PER_PAY_PROPOSALS_V2 ,
-
View: HRFV_REVIEWS
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PER.HRFV_REVIEWS, object_name:HRFV_REVIEWS, status:VALID, product: PER - Human Resources , description: Business view template from which the flexfield view is generated. , implementation_dba_data: APPS.HRFV_REVIEWS ,
-
View: PER_PERFORMANCE_REVIEWS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PER.PER_PERFORMANCE_REVIEWS_V, object_name:PER_PERFORMANCE_REVIEWS_V, status:VALID, product: PER - Human Resources , description: Used to support user-interface. , implementation_dba_data: APPS.PER_PERFORMANCE_REVIEWS_V ,
-
View: PER_PERFORMANCE_REVIEWS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PER.PER_PERFORMANCE_REVIEWS_V, object_name:PER_PERFORMANCE_REVIEWS_V, status:VALID, product: PER - Human Resources , description: Used to support user-interface. , implementation_dba_data: APPS.PER_PERFORMANCE_REVIEWS_V ,
-
View: HRU_SALARY_PROPOSALS
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PER.HRU_SALARY_PROPOSALS, object_name:HRU_SALARY_PROPOSALS, status:VALID, product: PER - Human Resources , description: Lists salary proposals including their components, also used to upload slary proposals via ADE. , implementation_dba_data: APPS.HRU_SALARY_PROPOSALS ,
-
View: HRU_SALARY_PROPOSALS
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PER.HRU_SALARY_PROPOSALS, object_name:HRU_SALARY_PROPOSALS, status:VALID, product: PER - Human Resources , description: Lists salary proposals including their components, also used to upload slary proposals via ADE. , implementation_dba_data: APPS.HRU_SALARY_PROPOSALS ,
-
View: HRFV_SALARIES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PER.HRFV_SALARIES, object_name:HRFV_SALARIES, status:VALID, product: PER - Human Resources , description: Business view template from which the flexfield view is generated. , implementation_dba_data: APPS.HRFV_SALARIES ,
-
View: HRFV_SALARIES
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PER.HRFV_SALARIES, object_name:HRFV_SALARIES, status:VALID, product: PER - Human Resources , description: Business view template from which the flexfield view is generated. , implementation_dba_data: APPS.HRFV_SALARIES ,