Search Results igs_ad_recruit_pi




Overview
Explore in AI Chat

Overview

IGS_AD_RECRUIT_PI is a table within the IGS – Student System product family of Oracle E-Business Suite. Its documented description states that it "contains information about recruitment probability index values." In practical terms, the table stores calculated probability scores that estimate the likelihood of a prospective student (recruit) converting into an applicant or enrolled student. Each row represents a scored recruitment assessment for a specific party at a specific point in time, qualified by a probability type and source.

The ETRM metadata marks the IGS – Student System module as obsolete, and notes that the object is not implemented in this database. This is an important operational caveat: in Oracle EBS 12.1.1 and 12.2.2 environments where the obsolete IGS schema has been dropped or never deployed, the table will not exist in the data dictionary, and queries against it will fail with an ORA-00942 error.

The heuristic Data Vault classification mined from the foreign-key structure is link. As a modeling suggestion, this reflects the table's role as an associative/event structure: it joins a party (via PERSON_ID to HZ_PARTIES) to code classifications (via the two IGS_AD_CODE_CLASSES foreign keys) and carries a calculation timestamp and value — a pattern typical of a link table with attached descriptive context.

Key Information Stored

The table is documented with 11 physical columns in the 12.1.1 schema. The most significant are:

A second unique index, IGS_AD_RECRUIT_PI_U1, spans (PROBABILITY_TYPE_CODE_ID, CALCULATION_DATE, PERSON_ID), making this the documented business-key candidate and ensuring that a given person has at most one score of a given type per calculation date.

Common Use Cases and Queries

The table supports recruitment analytics and admissions funnel reporting. A typical query retrieves the latest probability per person:

SELECT p.person_id,
       p.probability_type_code_id,
       p.calculation_date,
       p.probability_value
FROM   igs_ad_recruit_pi p
WHERE  p.calculation_date =
       (SELECT MAX(p2.calculation_date)
        FROM   igs_ad_recruit_pi p2
        WHERE  p2.person_id = p.person_id);

Recruitment teams join to HZ_PARTIES to resolve names, and to IGS_AD_CODE_CLASSES to translate both code IDs into meaningful descriptions. Trend reporting groups by probability_type_code_id and calculation_date to observe how scores shift across a recruitment cycle.

Related Objects

  • HZ_PARTIES — joined on IGS_AD_RECRUIT_PI.PERSON_ID = HZ_PARTIES.PARTY_ID to identify the scored individual.
  • IGS_AD_CODE_CLASSES — referenced twice, through PROBABILITY_TYPE_CODE_ID and PROBABILITY_SOURCE_CODE_ID, providing code lookups.
  • IGS_AD_RECRUIT_PI_PK / IGS_AD_RECRUIT_PI_U1 — the primary key and unique business-key indexes governing row integrity.
  • Other IGS_AD admissions objects (recruit, application, and applicant tables) that share the PERSON_ID party reference for consolidated recruitment reporting.