Search Results irc_notes




Overview
Explore in AI Chat

Overview

The IRC_NOTES table is a core data object within the Oracle E-Business Suite Human Resources (HR) module, specifically supporting the iRecruitment (IRC) functionality. It serves as the central repository for textual notes associated with job offers made through the recruitment process. This table is critical for maintaining an audit trail and contextual history of communications, decisions, and remarks logged against an offer throughout its lifecycle, from creation through acceptance or rejection. Its role is to persist offer-related annotations that are not part of the formal structured offer data, thereby enabling recruiters and hiring managers to track informal details and internal commentary.

Key Information Stored

The table's structure is designed to link notes directly to specific events in an offer's status history. Based on the provided metadata, the primary and foreign key relationships are its most significant columns. The NOTE_ID column is the table's primary key, uniquely identifying each note entry. The OFFER_STATUS_HISTORY_ID column is a critical foreign key that links each note to a specific status change event recorded in the IRC_OFFER_STATUS_HISTORY table. This relationship ensures that every note is contextualized within the precise moment of the offer's progression. While the explicit column list for note content is not detailed in the excerpt, tables of this nature typically include columns such as NOTE_TEXT or COMMENTS to store the note body, and standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) for auditing.

Common Use Cases and Queries

This table is primarily accessed for reporting and audit purposes within the recruitment workflow. Common use cases include generating a complete communication history for a specific job offer, reviewing notes added during a particular approval stage, or auditing user actions. A typical query would join IRC_NOTES to IRC_OFFER_STATUS_HISTORY and further to IRC_OFFERS to retrieve notes for a specific candidate or requisition.

  • Retrieve all notes for an offer: SELECT n.note_text, n.creation_date FROM hr.irc_notes n, hr.irc_offer_status_history osh WHERE n.offer_status_history_id = osh.offer_status_history_id AND osh.offer_id = <OFFER_ID> ORDER BY n.creation_date;
  • Audit note activity: Reports can be built to show which users added notes and when, providing transparency into the recruitment process.

Related Objects

The IRC_NOTES table has a direct and essential dependency on the IRC_OFFER_STATUS_HISTORY table, as defined by its foreign key constraint. This means a note cannot exist without a corresponding status history record. Consequently, IRC_NOTES is a child table within a hierarchy that typically includes IRC_OFFERS (the parent of IRC_OFFER_STATUS_HISTORY). Any process, API, or user interface (likely within the iRecruitment screens) that creates or displays offer status history will have the capability to create and display associated notes. While not listed in the excerpt, it is common for PL/SQL APIs in the IRC_OFFER_API or similar packages to provide procedures for inserting and managing note data.