Search Results irc_all_recruiting_sites




Overview
Explore in AI Chat

Overview

HR.IRC_ALL_RECRUITING_SITES is a Human Resources (PER) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that maintains the master list of external recruiting sites and third-party advertising channels with which an enterprise holds agreements to post job advertisements. The ETRM documentation describes it as storing "a list of all of the third parties which you have agreements with to send adverts to," noting that its scope may be expanded for other uses in the future. Functionally, the table acts as the recruitment-channel registry consumed by the iRecruitment posting and sourcing process, and it is also a reference source for recruiting activities captured elsewhere in the HR schema.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign-key structure is hub-leaning. This is consistent with the table's role: it defines a stable, uniquely identified business entity (a recruiting site), keyed by a single-column surrogate primary key, with descriptive attributes such as site configuration and cost parameters behaving as satellite-like detail. The table is owned by the HR schema, holds a VALID status in ETRM, and is documented with 55 physical columns in 12.2.2.

Key Information Stored

The surrogate primary key is RECRUITING_SITE_ID, enforced by IRC_ALL_RECRUITING_SITES_PK. The documented unique indexes, SYS_IL0000244039C00008$$ and SYS_IL0000244039C00009$$, are system-managed LOB indexes rather than business-key constraints, so no explicit natural unique key is published in the metadata. The most significant business columns include:

Thirty attribute columns (ATTRIBUTE1 through ATTRIBUTE30) and ATTRIBUTE_CATEGORY provide the standard descriptive-flexfield extension area. ZD_EDITION_NAME is present as a 12.2.2 editioning artifact.

Common Use Cases and Queries

Typical reporting scenarios include validating which recruiting channels are currently active, auditing advertising costs by period and currency, and reconciling postings submitted to third parties. A representative query returning active external channels follows:

  • SELECT recruiting_site_id, site_name, posting_url, posting_cost, posting_cost_currency FROM hr.irc_all_recruiting_sites WHERE TRUNC(SYSDATE) BETWEEN date_from AND NVL(date_to, TRUNC(SYSDATE)) AND external = 'Y';
  • Count postings by channel: join to PER_RECRUITMENT_ACTIVITIES on RECRUITING_SITE_ID and aggregate by SITE_NAME.
  • Cost analysis: sum POSTING_COST grouped by POSTING_COST_PERIOD and POSTING_COST_CURRENCY.
  • Credential audit: list sites with non-null POSTING_USERNAME or POSTING_PASSWORD flagged as THIRD_PARTY = 'Y'.

Security-sensitive columns such as POSTING_PASSWORD should be excluded from general extracts.

Related Objects

The documented foreign-key relationship identifies PER_RECRUITMENT_ACTIVITIES as the primary dependent table, joining on PER_RECRUITMENT_ACTIVITIES.RECRUITING_SITE_ID → IRC_ALL_RECRUITING_SITES.RECRUITING_SITE_ID. This link connects each recorded recruitment activity to the site against which it was performed. Related iRecruitment and HR objects commonly associated with this table include:

  • HR.PER_RECRUITMENT_ACTIVITIES — activity records referencing recruiting sites.
  • IRC_ALL_RECRUITING_SITES base table view forms used by the iRecruitment Administrative functions.
  • Recruitment posting and vacancy tables that consume site identifiers for advert placement.
  • Standard HR lookup objects underlying POSTING_COST_PERIOD and related flags.

The table serves as the authoritative registry underpinning recruitment-channel configuration and reporting across the HR and iRecruitment product areas.