Search Results per_recruitment_activity_for

Overview

The PER_RECRUITMENT_ACTIVITY_FOR table is a core data object within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically under the PER (Personnel) product family. Its primary function is to manage the many-to-many relationship between recruitment activities and vacancies. In the recruitment lifecycle, a single activity, such as a job fair or a newspaper advertisement, can be associated with multiple open positions (vacancies). Conversely, a vacancy may be promoted through several recruitment activities. This table serves as the junction or intersection table that formally links these two key entities, providing a complete audit trail of which recruitment initiatives are used to fill which specific job openings.

Key Information Stored

The table's structure is designed to establish and record the links between its parent entities. Its primary key is a unique system-generated identifier, RECRUITMENT_ACTIVITY_FOR_ID. The table's critical foreign key columns define its relationships:

• RECRUITMENT_ACTIVITY_ID: References the PER_RECRUITMENT_ACTIVITIES table, identifying the specific recruitment campaign or event.
• VACANCY_ID: References the PER_ALL_VACANCIES table, identifying the specific job opening being targeted.
• BUSINESS_GROUP_ID: References the HR_ALL_ORGANIZATION_UNITS table, enforcing data security by anchoring the record to a specific business group, a fundamental concept in Oracle HRMS.

These columns collectively ensure data integrity and enable reporting on recruitment effort effectiveness per vacancy.

Common Use Cases and Queries

This table is central to recruitment analysis and operational reporting. A common use case is generating a report of all vacancies associated with a particular recruitment activity to assess its return on investment. Conversely, HR personnel may query all recruitment activities used for a hard-to-fill vacancy to understand the sourcing strategy. Sample SQL patterns include joining to the related master tables:

SELECT pra.NAME AS activity_name,
       pav.NAME AS vacancy_name,
       pav.SEGMENT1 AS vacancy_number
FROM   per_recruitment_activity_for praf,
       per_recruitment_activities pra,
       per_all_vacancies pav
WHERE  praf.recruitment_activity_id = pra.recruitment_activity_id
AND    praf.vacancy_id = pav.vacancy_id
AND    pra.business_group_id = :p_business_group
AND    pra.recruitment_activity_id = :p_activity_id;

This table is also critical for underlying logic in recruitment-related forms, workflows, and standard reports within the EBS application.

Related Objects

As indicated by its foreign keys, PER_RECRUITMENT_ACTIVITY_FOR has direct dependencies on three primary tables:

• PER_RECRUITMENT_ACTIVITIES: The parent table for recruitment campaign details (e.g., type, start/end dates, cost).
• PER_ALL_VACANCIES: The parent table for vacancy details (e.g., job, location, status, hiring manager).
• HR_ALL_ORGANIZATION_UNITS: The table defining the business group and other organizational units for security.

This table is also likely referenced by various HRMS APIs, public views (such as PER_RECRUITMENT_ACTIVITIES_VL), and embedded within the data model for recruitment analytics and iRecruitment functionalities.