Results for “sys_il0000244039c00008”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

HR.IRC_ALL_RECRUITING_SITES is a transactional table in the Oracle E-Business Suite Human Resources (HR) schema that defines the catalog of iRecruitment web sites available within an enterprise. Each row represents a single recruiting site — an external career portal, an internal opportunities page, a third-party job board, or a division-specific branded site — that applicants can log onto in order to search for and apply to published vacancies. The object is registered under FND Design Data as PER.IRC_ALL_RECRUITING_SITES, carries VALID status, and resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10.

Because the table stores the identity, availability window, branding reference, and access credentials of each site, it functions as the configuration hub from which iRecruitment routing and posting behavior is driven. A site can be restricted by date range, flagged as third party, and targeted at internal versus external audiences through the INTERNAL and EXTERNAL columns, although the documentation marks these two columns as not currently used.

From a Data Vault modeling perspective, the heuristic mined from the foreign-key structure classifies this object as hub-leaning. Treating RECRUITING_SITE_ID as a durable business key and surrounding it with descriptive satellites is a reasonable modeling suggestion; the descriptive attributes (cost, credentials, stylesheet, flexfield context) would naturally separate into one or more satellite structures keyed on the same identifier.

Key Information Stored

The table contains 55 documented columns. The most operationally significant are:

• RECRUITING_SITE_ID — NUMBER(15), mandatory, and the surrogate primary key enforced by IRC_ALL_RECRUITING_SITES_PK. This is the single-column identifier referenced by every dependent table.
• SITE_NAME — VARCHAR2(240); the display name of the recruiting site. The ETRM documentation marks this column obsolete, so portal naming may now be driven elsewhere.
• DATE_FROM / DATE_TO — the validity window during which the site may be used by applicants.
• THIRD_PARTY — VARCHAR2(30); indicates whether the site is an external third-party job board.
• POSTING_URL / REDIRECTION_URL — CLOB(4000); both documented as obsolete, but historically used for posting endpoints and redirect targets.
• POSTING_USERNAME / POSTING_PASSWORD — VARCHAR2(240); credentials used to authenticate against the posting site.
• POSTING_COST, POSTING_COST_PERIOD, POSTING_COST_CURRENCY — describe the commercial terms of posting to the site.
• STYLESHEET — VARCHAR2(4000); location of the stylesheet, allowing alternative DTDs and branded layouts to be supported.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE30 — the Descriptive Flexfield structure-defining column and its 30 segment columns, providing extensibility.
• INTERNAL_NAME, POSTING_IMPL_CLASS, ZD_EDITION_NAME, OBJECT_VERSION_NUMBER — implementation and concurrency-control columns.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard EBS WHO audit columns.

Two LOB unique indexes, SYS_IL0000244039C00008$$ and SYS_IL0000244039C00009$$, exist in APPS_TS_TX_DATA. These are internal LOB segment indexes rather than true business-key candidates; RECRUITING_SITE_ID remains the only meaningful unique identifier.

Common Use Cases and Queries

Typical scenarios include enumerating active recruiting sites for a given date, identifying third-party boards and their posting costs, and joining site configuration to recruitment activity records.

• List currently valid sites: SELECT recruiting_site_id, date_from, date_to, third_party FROM hr.irc_all_recruiting_sites WHERE SYSDATE BETWEEN date_from AND date_to AND third_party = 'N';
• Third-party cost analysis: aggregate POSTING_COST by POSTING_COST_CURRENCY and POSTING_COST_PERIOD for sites flagged THIRD_PARTY = 'Y'.
• Activity linkage: SELECT a.recruiting_site_id, s.site_name, COUNT(*) FROM per_recruitment_activities a JOIN hr.irc_all_recruiting_sites s ON s.recruiting_site_id = a.recruiting_site_id GROUP BY a.recruiting_site_id, s.site_name;
• Flexfield reporting: query ATTRIBUTE_CATEGORY to identify which DFF context is populated per site, then pivot ATTRIBUTE1–ATTRIBUTE30 for site-specific metadata.

Related Objects

• PER_RECRUITMENT_ACTIVITIES — the only documented foreign key; references RECRUITING_SITE_ID and records recruitment activity per site.
• IRC_ALL_RECRUITING_SITES_PK — primary key index on RECRUITING_SITE_ID.
• SYS_IL0000244039C00008$$ / SYS_IL0000244039C00009$$ — LOB unique indexes supporting the CLOB columns.
• PER.IRC_ALL_RECRUITING_SITES — FND Design Data registration governing the table's application ownership.