Search Results per_jobs




Overview
Explore in AI Chat

Overview

The PER_JOBS table is a core master data table within the Oracle E-Business Suite Human Resources (HR) module, specifically under the PER product family. It serves as the central repository for all job definitions within a business group. A job represents a formal, named position or role within an organization's structure, such as "Senior Accountant" or "Software Developer," which can be assigned to employees and positions. The table's primary role is to establish a standardized catalog of job titles, enabling consistent reporting, compensation management, position control, and integration with other EBS modules like Projects and iRecruitment. Its integrity is enforced by the primary key constraint PER_JOBS_PK on the JOB_ID column, a detail directly relevant to the user's search.

Key Information Stored

The table stores descriptive and relational attributes for each job record. The primary identifier is the system-generated JOB_ID (Primary Key: PER_JOBS_PK). Each job is uniquely identified within a business group by the combination of NAME and BUSINESS_GROUP_ID (Unique Key: PER_JOBS_UK2). Key columns include BUSINESS_GROUP_ID, which links the job to its owning HR organization, and JOB_DEFINITION_ID, which references a template job definition from the PER_JOB_DEFINITIONS table. Other significant attributes typically include ENABLED_FLAG (active status), DATE_FROM and DATE_TO (effective dates), and descriptive fields like INTERNAL_TITLE. The table also maintains relationships via JOB_GROUP_ID to categorize jobs within PER_JOB_GROUPS.

Common Use Cases and Queries

This table is fundamental for HR operations and cross-module reporting. Common use cases include maintaining the enterprise job catalog, assigning jobs to employees and positions, and configuring compensation rules or project billing rates based on job roles. A frequent reporting requirement is to list all active jobs within a business group. A sample query to achieve this, utilizing the primary key column, is:

  • SELECT JOB_ID, NAME, INTERNAL_TITLE FROM PER_JOBS WHERE BUSINESS_GROUP_ID = &BG_ID AND ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN DATE_FROM AND NVL(DATE_TO, SYSDATE) ORDER BY NAME;

Another critical pattern involves joining PER_JOBS with HR_ALL_POSITIONS_F to analyze position occupancy by job title, or with PA_RESOURCE_ASSIGNMENTS in Projects to report on project staffing by job role.

Related Objects

As indicated by the extensive foreign key relationships in the metadata, PER_JOBS is a heavily referenced master table. Key dependencies include:

  • Core HR: HR_ALL_POSITIONS_F directly references PER_JOBS via JOB_ID for position management.
  • Projects (PA): Numerous tables reference JOB_ID for resource management and billing, including PA_RESOURCE_ASSIGNMENTS, PA_EXPENDITURE_ITEMS_ALL, and PA_BILL_RATES_ALL.
  • Talent Acquisition: IRC_DEFAULT_POSTINGS and related iRecruitment tables use JOB_ID for requisition and posting setup.
  • Payroll: PAY_ELEMENT_LINKS_F can associate earnings or deductions with specific jobs.
  • Parent/Reference Tables: It draws definitional data from PER_JOB_DEFINITIONS and is scoped by HR_ALL_ORGANIZATION_UNITS (Business Group).