Search Results irc_all_recruiting_sites

Overview

The IRC_ALL_RECRUITING_SITES table is a core data object within the Oracle E-Business Suite Human Resources (PER) module, specifically supporting the iRecruitment functionality. Its primary role is to serve as the master repository for external third-party recruitment agencies, job boards, or other advertising partners with whom an organization has established agreements. This table acts as a reference source, enabling the system to track and manage the distribution of job advertisements to these external sites. The provided metadata indicates its scope may expand in future releases, but in versions 12.1.1 and 12.2.2, its central purpose is to manage these recruitment channel partnerships.

Key Information Stored

The table's structure is designed to catalog essential details for each recruiting partner. While the full column list is not provided in the excerpt, the documented primary key is the RECRUITING_SITE_ID, a unique system-generated identifier for each third-party site record. Based on its described purpose and standard Oracle EBS design patterns, the table would typically store columns such as the recruiting site's name, a status or active flag, contact information, and details regarding the nature of the agreement. It functions as a lookup table, providing validated and controlled values for use in transactional recruitment processes.

Common Use Cases and Queries

The primary use case is during the creation and management of a recruitment campaign or job posting. When a recruiter initiates an activity to advertise a vacancy externally, they select from the validated list of partners stored in this table. Common reporting and operational queries include listing all active recruiting partners, identifying which partners were used for specific job postings, and auditing agreement usage. A fundamental SQL pattern involves joining this table to transactional data.

• Listing all active recruiting sites: SELECT recruiting_site_id, name FROM irc_all_recruiting_sites WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
• Finding recruitment activities for a specific site: SELECT pra.* FROM per_recruitment_activities pra, irc_all_recruiting_sites rs WHERE pra.recruiting_site_id = rs.recruiting_site_id AND rs.name = '&SITE_NAME';

Related Objects

The IRC_ALL_RECRUITING_SITES table has a direct and critical relationship with the PER_RECRUITMENT_ACTIVITIES table, as documented by the foreign key constraint. The RECRUITING_SITE_ID column in PER_RECRUITMENT_ACTIVITIES references the primary key in IRC_ALL_RECRUITING_SITES, enforcing data integrity. This relationship is central to the recruitment process, linking each external advertising activity to its authorized partner. The table is also likely referenced by other iRecruitment objects, such as the IRC_POSTINGS table for job board distributions, and is accessed via standard HRMS APIs for data integration and extension purposes.