Search Results per_recruitment_activities




Overview
Explore in AI Chat

Overview

PER_RECRUITMENT_ACTIVITIES is a core Human Resources (PER) table stored in the HR schema of Oracle E-Business Suite, holding records for recruitment activities and their associated costs. Each row represents a discrete recruiting event — such as a job fair, campus drive, advertising campaign, or internal referral program — that an enterprise uses to attract candidates. The table functions as the master repository for activity definitions, scheduling windows, budgeting figures, and posting configuration that drive downstream applicant tracking and requisition management within Oracle iRecruitment and the broader PER recruiting flow.

Heuristically, the FK topology classifies this object as a satellite-leaning entity: it carries descriptive and measurable attributes (costs, dates, status, contact details) around business keys such as BUSINESS_GROUP_ID and organizational references. From a Data Vault modeling perspective, this suggests it behaves largely as a satellite attached to core HR dimensions (organization units and business groups), with a recursive self-reference for parent-child activity hierarchies.

Key Information Stored

The table's surrogate primary key is RECRUITMENT_ACTIVITY_ID, exposed through the PER_RECRUITMENT_ACTIVITIES_PK unique index. A second unique index, PER_RECRUITMENT_ACTIVITIES_UK2, defines NAME and BUSINESS_GROUP_ID as composite business-key candidates — activity names are unique within a business group.

The most operationally significant columns include:

Common Use Cases and Queries

The table is central to recruiting cost analysis, activity scheduling reports, and candidate-source attribution. A typical query retrieves active activities and their budget consumption for a business group:

  • SELECT name, date_start, date_end, planned_cost, actual_cost FROM per_recruitment_activities WHERE business_group_id = :bg AND TRUNC(SYSDATE) BETWEEN date_start AND NVL(date_end, SYSDATE);
  • Cost variance reporting: compare ACTUAL_COST against PLANNED_COST grouped by TYPE to evaluate ROI of recruiting spend by channel.
  • Source-of-hire analysis: join through PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID to determine which activities produced lasting hires.
  • Hierarchy traversal: self-join on PARENT_RECRUITMENT_ACTIVITY_ID to build rolled-up activity trees for umbrella campaigns.
  • Posting management: filter on INTERNAL_POSTING/EXTERNAL_POSTING and LAST_POSTED_DATE to audit website publication status against IRC_ALL_RECRUITING_SITES.

Related Objects

Key relationships, per documented FK constraints, include:

  • HR_ALL_ORGANIZATION_UNITS — referenced via BUSINESS_GROUP_ID and RUN_BY_ORGANIZATION_ID for organizational attribution.
  • PER_RECRUITMENT_ACTIVITIES (self) — PARENT_RECRUITMENT_ACTIVITY_ID supports activity hierarchies.
  • IRC_POSTING_CONTENTS and IRC_ALL_RECRUITING_SITES — referenced via POSTING_CONTENT_ID and RECRUITING_SITE_ID, linking activities to iRecruitment posting infrastructure.
  • PER_ALL_ASSIGNMENTS_F — references RECRUITMENT_ACTIVITY_ID, enabling source-of-hire tracing from the activity to the resulting assignment.
  • PER_RECRUITMENT_ACTIVITY_FOR — child table capturing the activity-to-object applicability mapping.
  • IRC_JOB_BASKET_ITEMS — references activities for job-basket publication workflows.
  • HR_EDW_WRK_ACTVTY_F and HR_EDW_WRK_ACTVTY_FSTG — Enterprise Data Warehouse fact and staging tables consuming RECRUITMENT_ACTIVITY_ID for analytics.