Search Results per_recruitment_activities




Overview
Explore in AI Chat

Overview

The PER_RECRUITMENT_ACTIVITIES table is a core data object within the Oracle E-Business Suite Human Resources (PER) module, specifically for versions 12.1.1 and 12.2.2. It serves as the central repository for tracking and managing all recruitment initiatives undertaken by an organization. The table's primary role is to record the details and associated costs of various recruitment efforts, such as job fairs, advertising campaigns, agency engagements, and internal referral programs. By maintaining this data, the table enables comprehensive reporting on recruitment effectiveness, cost analysis, and the linkage of hiring activities to specific job requisitions and final employee assignments, thereby supporting strategic workforce planning and budgetary control.

Key Information Stored

The table stores a range of attributes that define a recruitment activity. Its structure is governed by a primary key on RECRUITMENT_ACTIVITY_ID and a unique key constraint on the combination of NAME and BUSINESS_GROUP_ID to ensure activity names are unique within a business group. Critical columns include BUSINESS_GROUP_ID, which anchors the activity to a specific organizational unit, and RUN_BY_ORGANIZATION_ID, identifying the department responsible for executing the activity. The PARENT_RECRUITMENT_ACTIVITY_ID column supports hierarchical relationships, allowing for the grouping of sub-activities under a main initiative. Foreign key columns like POSTING_CONTENT_ID and RECRUITING_SITE_ID integrate with the Oracle iRecruitment module, linking activities to specific job postings and external career sites. The table inherently tracks cost-related information, as indicated by its description.

Common Use Cases and Queries

A primary use case is generating cost analysis reports for recruitment campaigns. Analysts can query the table to aggregate costs by activity type, business group, or running organization. Another critical scenario is tracing the source of hire; the foreign key relationship to PER_ALL_ASSIGNMENTS_F allows queries to identify which recruitment activity resulted in a specific employee assignment. For iRecruitment implementations, linking activities to specific job postings on recruiting sites is essential for measuring channel effectiveness. A sample query to list activities with their responsible organization might be:

  • SELECT pra.NAME, pra.RECRUITMENT_ACTIVITY_ID, hou.NAME RUN_BY_ORG
  • FROM per_recruitment_activities pra, hr_all_organization_units hou
  • WHERE pra.run_by_organization_id = hou.organization_id
  • AND pra.business_group_id = :p_bg_id;

This supports operational reviews and budget allocation for recruitment teams.

Related Objects

PER_RECRUITMENT_ACTIVITIES is a central hub with several key relationships. It is primarily owned by a BUSINESS_GROUP_ID and RUN_BY_ORGANIZATION_ID, both referencing HR_ALL_ORGANIZATION_UNITS. Its self-referencing foreign key on PARENT_RECRUITMENT_ACTIVITY_ID allows for activity hierarchies. For iRecruitment, it links to IRC_POSTING_CONTENTS and IRC_ALL_RECRUITING_SITES. Crucially, it is referenced by the assignment table (PER_ALL_ASSIGNMENTS_F) to denote the hiring source for an employee and by the PER_RECRUITMENT_ACTIVITY_FOR table, which likely associates activities with specific vacancies or positions. The IRC_JOB_BASKET_ITEMS table also references it, connecting recruitment activities to candidate job baskets. These relationships make it integral to the end-to-end recruitment-to-hire process.