Search Results irc_rec_team_members




Overview
Explore in AI Chat

Overview

The IRC_REC_TEAM_MEMBERS table is a core data object within the Oracle E-Business Suite Human Resources (PER) module, specifically supporting the recruitment functionality. Its primary role is to manage the composition of recruitment teams. The table stores the definitive list of individuals assigned to work on a specific job vacancy, enabling structured collaboration, task assignment, and responsibility tracking throughout the hiring process. This data is essential for workflows in Oracle iRecruitment and integrated HR processes, ensuring that vacancies are managed by authorized personnel and that recruitment activities are properly coordinated within the organization.

Key Information Stored

The table's structure is designed to link vacancies, team members, and their roles. The primary key, REC_TEAM_MEMBER_ID, uniquely identifies each team member assignment. The most critical foreign key columns define its core relationships: VACANCY_ID links a team member to a specific vacancy in the PER_ALL_VACANCIES table, and JOB_ID links to the job definition in the PER_JOBS table, which may define the team member's functional role or position within the recruitment team. While the provided metadata highlights these key columns, typical implementations may also include columns for the person identifier (often a foreign key to PER_ALL_PEOPLE_F), a role or responsibility code, and status indicators to denote active or inactive assignments.

Common Use Cases and Queries

This table is central to recruitment administration and reporting. Common operational use cases include generating a list of all recruiters and hiring managers assigned to open vacancies, assigning screening tasks to specific team members, and auditing recruitment workload distribution. For reporting, it is frequently joined to vacancy and job tables to analyze team structures. A fundamental query pattern retrieves the recruitment team for a given vacancy:

  • SELECT p.full_name, j.name AS job_role FROM hr.irc_rec_team_members irm JOIN per_all_people_f p ON irm.person_id = p.person_id JOIN per_jobs j ON irm.job_id = j.job_id WHERE irm.vacancy_id = <VACANCY_ID> AND SYSDATE BETWEEN p.effective_start_date AND p.effective_end_date;

Another common reporting use case involves listing all vacancies a specific person is assigned to, which is instrumental for capacity planning and ensuring segregation of duties.

Related Objects

The IRC_REC_TEAM_MEMBERS table maintains defined foreign key relationships with other critical HR tables, forming the backbone of recruitment data integrity. As per the documented metadata:

  • PER_ALL_VACANCIES: Linked via the IRC_REC_TEAM_MEMBERS.VACANCY_ID column. This is the principal relationship, anchoring each team member record to a specific job opening.
  • PER_JOBS: Linked via the IRC_REC_TEAM_MEMBERS.JOB_ID column. This relationship associates a job role or title (e.g., "Hiring Manager," "Recruiter") with each team member for the vacancy.

While not listed in the provided excerpt, this table is also logically related to person tables (e.g., PER_ALL_PEOPLE_F) via a PERSON_ID column, which stores the identifier for the individual team member. It is a foundational table for recruitment APIs and underlying views within the iRecruitment product family.