Search Results irc_search_criteria_pk

Overview

The IRC_SEARCH_CRITERIA 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 store user-defined job matching preferences and saved advanced search criteria. This enables both recruiters and candidates to define, save, and reuse complex search parameters for identifying suitable job opportunities or candidates, thereby centralizing and streamlining the talent search and matching process within the application.

Key Information Stored

While the provided metadata does not list all columns, the table's description and foreign key relationships indicate it holds criteria for constructing sophisticated searches. Key data points stored include a unique search identifier (the primary key), references to the user who created the search, and the search criteria itself. Crucially, the documented foreign keys to the PER_QUALIFICATION_TYPES table via the MIN_QUAL_LEVEL and MAX_QUAL_LEVEL columns show that the table stores minimum and maximum qualification level thresholds as part of its search parameters. Other typical columns would capture criteria such as job title keywords, location preferences, experience range, salary expectations, and other saved filter conditions from the iRecruitment advanced search interface.

Common Use Cases and Queries

A primary use case is the retrieval of a user's saved searches for display in the iRecruitment self-service pages. System administrators may also query this table for audit or reporting purposes to understand common search patterns. A typical query would join to FND_USER to display search names alongside creator details. For example, to list all saved searches that include a specific qualification level requirement, one might use a SQL pattern such as: SELECT search_criteria_name, created_by FROM hr.irc_search_criteria WHERE min_qual_level = '&QUAL_CODE';. Another common operational query involves fetching the complete criteria set for a specific saved search ID to re-execute the search logic within the application.

Related Objects

The table has defined relationships with other HR schema objects, primarily through its foreign key constraints. As per the documented metadata:

• Primary Key: IRC_SEARCH_CRITERIA_PK on the table's primary key column(s).
• Foreign Keys: The table references the PER_QUALIFICATION_TYPES table twice.
  • Via the MIN_QUAL_LEVEL column, ensuring the minimum qualification level in a saved search is valid.
  • Via the MAX_QUAL_LEVEL column, ensuring the maximum qualification level in a saved search is valid.

It is also logically related to core HR tables like PER_ALL_PEOPLE_F (for person references) and IRC_VACANCIES (for job postings against which searches are run), though these are not explicitly listed in the provided constraints.