Search Results per_jobs_n2

Overview

The HR.PER_JOBS table is a core master data table within the Oracle E-Business Suite Human Capital Management (HCM) module, specifically for releases 12.1.1 and 12.2.2. It serves as the central repository for all defined job roles within a Business Group. A job represents a functional role an employee can perform, such as 'Senior Accountant' or 'Software Developer', and is defined independently of any specific organizational unit. This abstraction allows the same job to be utilized across multiple departments and positions. Each job record is mandatory linked to a Job Group for categorization and is sourced from a Job Definition, which holds the key flexfield structure.

Key Information Stored

The table's primary identifier is the JOB_ID column, a system-generated surrogate key enforced by the primary key constraint PER_JOBS_PK. The NAME column holds the concatenated, user-friendly name of the job, constructed from the segments of the Job flexfield. A unique constraint (PER_JOBS_UK2) ensures that the combination of NAME and BUSINESS_GROUP_ID is unique, preventing duplicate job names within a single Business Group. Other critical foreign key columns include JOB_DEFINITION_ID, linking to PER_JOB_DEFINITIONS for the flexfield definition, and JOB_GROUP_ID, linking to PER_JOB_GROUPS. The table also contains descriptive columns like JOB_INFORMATION4, which is indexed (PER_JOBS_N2) for performance in queries.

Common Use Cases and Queries

This table is fundamental for workforce modeling, reporting, and transactional integrity. Common use cases include populating job lists of values in assignment forms, defining position requirements, and generating organizational job hierarchies. A typical query to retrieve all active jobs for a specific Business Group would join to the Job Definitions table for segment details:

• SELECT pj.JOB_ID, pj.NAME, pjd.SEGMENT1 AS "Job Code" FROM HR.PER_JOBS pj, HR.PER_JOB_DEFINITIONS pjd WHERE pj.JOB_DEFINITION_ID = pjd.JOB_DEFINITION_ID AND pj.BUSINESS_GROUP_ID = :p_bg_id ORDER BY pj.NAME;

Another critical reporting pattern involves analyzing employee assignments by job, joining PER_JOBS to PER_ALL_ASSIGNMENTS_F. The JOB_ID column is the pivotal link for such analyses, enabling headcount, compensation, and competency reporting by job role.

Related Objects

As a master table, PER_JOBS is referenced extensively across the HCM and Payroll schemas. Key foreign key dependencies, as documented, include:

• Assignment and Position Data: PER_ALL_ASSIGNMENTS_F, PER_ALL_POSITIONS, and HR_ALL_POSITIONS_F store the JOB_ID to link incumbents and vacant roles to a specific job.
• Career and Competency Management: PER_CAREER_PATH_ELEMENTS (for parent/subordinate job relationships) and PER_COMPETENCE_ELEMENTS.
• Payroll and Budgeting: PAY_ELEMENT_LINKS_F, PAY_JOB_WC_CODE_USAGES, PER_BUDGET_ELEMENTS.
• Recruitment: PER_ALL_VACANCIES.
• Foundation: The table is linked to its Business Group via HR_ALL_ORGANIZATION_UNITS and to its flexfield source via PER_JOB_DEFINITIONS.