Search Results per_objectives




Overview
Explore in AI Chat

Overview

The PER_OBJECTIVES table is a core data object within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically under the Performance Management (PER) product family. As defined in the ETRM documentation, it serves as the primary repository for storing objectives, which are defined as targets or goals that may be evaluated during an employee appraisal. This table is fundamental to the performance appraisal process, enabling organizations to define, track, and assess individual and organizational goals. Its role is to structurally link specific performance objectives to an employee's formal appraisal, providing the measurable criteria against which performance is reviewed.

Key Information Stored

The table stores metadata and descriptive information for each objective. While the full column list is not detailed in the provided excerpt, the primary and foreign key structure reveals critical data points. The OBJECTIVE_ID column is the unique primary identifier. The APPRAISAL_ID foreign key establishes the essential link to the PER_APPRAISALS table, tying the objective to a specific performance review instance. The BUSINESS_GROUP_ID foreign key links the objective to an organizational unit in HR_ALL_ORGANIZATION_UNITS, enforcing data security and partitioning by business group. Typically, other columns would include fields for the objective's title or name (e.g., OBJECTIVE_NAME), a detailed description, weight, target and actual measurements, status, and dates for creation and completion.

Common Use Cases and Queries

Primary use cases revolve around performance reporting and appraisal management. Common operational and analytical queries include listing all objectives for a specific appraisal, calculating overall appraisal scores based on weighted objectives, and identifying objectives that are overdue or not yet completed. A fundamental reporting query might retrieve objectives for a given employee's appraisal cycle:

  • SELECT po.objective_id, po.objective_name, po.weight, po.target_value, po.actual_value FROM per_objectives po, per_appraisals pa WHERE po.appraisal_id = pa.appraisal_id AND pa.person_id = <employee_id> AND pa.appraisal_period = <period>;

Another common pattern is joining with the organization table to report on objectives by department or business group, supporting managerial reviews of goal alignment and completion rates across the organization.

Related Objects

The PER_OBJECTIVES table has defined relationships with several key HR objects, as indicated by its foreign keys. It is centrally dependent on the PER_APPRAISALS table, as every objective must belong to a parent appraisal record. It also references HR_ALL_ORGANIZATION_UNITS for its business group context. While not listed in the excerpt, it is common for this table to be referenced by other performance-related entities, such as tables storing objective comments, ratings, or competency linkages. The table is also a primary source for performance management views and is accessed by standard Oracle APIs for creating and managing objectives programmatically within the Appraisals workflow.