Search Results per_recruitment_activities_uk2

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:

• NAME — the descriptive activity label, part of the business key.
• BUSINESS_GROUP_ID — the enterprise-level business group owning the activity, referencing HR_ALL_ORGANIZATION_UNITS.
• RUN_BY_ORGANIZATION_ID — the organization responsible for executing the activity.
• PARENT_RECRUITMENT_ACTIVITY_ID — self-referencing column supporting hierarchical parent-child activity structures.
• TYPE — classification of the activity (for example, advertising, event, or referral).
• DATE_START, DATE_END, DATE_CLOSING — scheduling and cutoff dates controlling activity duration and application deadlines.
• PLANNED_COST and ACTUAL_COST — budgeted versus realized expenditure, both expressed in CURRENCY_CODE.
• AUTHORISING_PERSON_ID and INTERNAL_CONTACT_PERSON_ID — responsible internal parties.
• EXTERNAL_CONTACT and CONTACT_TELEPHONE_NUMBER — external point-of-contact details.
• STATUS — lifecycle state of the activity (active, closed, or pending).
• POSTING_CONTENT_ID, RECRUITING_SITE_ID, INTERNAL_POSTING, EXTERNAL_POSTING, LAST_POSTED_DATE — controls and audit fields for publishing the activity to recruiting sites.
• OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, and the ATTRIBUTE1–20 DFF columns — standard EBS concurrency, audit, and descriptive flexfield support.

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.