Search Results irc_assignment_statuses




Overview
Explore in AI Chat

Overview

The IRC_ASSIGNMENT_STATUSES table is a core data object within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically supporting the iRecruitment functionality. As documented in the ETRM, its primary role is to store assignment statuses for a particular applicant assignment. This table acts as a historical log or audit trail, capturing the various statuses an applicant's assignment progresses through during the recruitment lifecycle. It is integral to tracking candidate movement within the system, from initial application through to hire or rejection, enabling reporting and workflow management.

Key Information Stored

The table's structure is designed to link an applicant's assignment to its status history. The primary key is ASSIGNMENT_STATUS_ID, which uniquely identifies each status record. A critical foreign key column is ASSIGNMENT_STATUS_TYPE_ID, which references the PER_ASSIGNMENT_STATUS_TYPES table. This relationship ensures that the status values are valid and controlled by the application's setup data. While the provided metadata does not list all columns, typical data stored includes the assignment identifier (ASSIGNMENT_ID), the effective date of the status change, and potentially a sequence number to order multiple statuses for the same assignment. The table essentially creates a timeline of status events for each recruitment assignment.

Common Use Cases and Queries

The primary use case is tracking and reporting on applicant assignment history. Recruitment analysts or hiring managers may query this table to understand the time spent in each stage of the process or to identify bottlenecks. A common reporting pattern involves joining this table to applicant and vacancy information. For example, to find the current status and status history for a specific applicant assignment, a query might join IRC_ASSIGNMENT_STATUSES to PER_ALL_ASSIGNMENTS_F and IRC_ASSIGNMENT_STATUSES to PER_ASSIGNMENT_STATUS_TYPES_TL for the status name. Another critical use is within the iRecruitment application's own pages and workflows, which rely on this table to display assignment history and enforce business rules based on status transitions.

Related Objects

  • PER_ASSIGNMENT_STATUS_TYPES: This is a directly referenced foreign key table, as per the ETRM. It provides the valid list of status types (e.g., "Active Applicant", "Hired", "Rejected") that can be assigned to a recruitment assignment.
  • PER_ALL_ASSIGNMENTS_F: The applicant assignment record itself, to which the status history in IRC_ASSIGNMENT_STATUSES belongs, is likely stored in or related to this core HR assignments table.
  • IRC_APPLICANT_ASSIGNMENTS / IRC_ASSIGNMENTS: While not explicitly listed in the metadata, tables with similar names are central to iRecruitment and would have a direct foreign key relationship with IRC_ASSIGNMENT_STATUSES via the ASSIGNMENT_ID.
  • IRC_ASSIGNMENT_STATUSES_PK: The primary key constraint enforcing uniqueness on the ASSIGNMENT_STATUS_ID column.