Results for “igs_ad_recruit_pi_pk”

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

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:

• PROBABILITY_INDEX_ID — the surrogate primary key, enforced by the IGS_AD_RECRUIT_PI_PK unique index. It uniquely identifies each probability record.
• PERSON_ID — references HZ_PARTIES, identifying the prospective student or party being scored.
• PROBABILITY_TYPE_CODE_ID — references IGS_AD_CODE_CLASSES; classifies the kind of probability being recorded.
• PROBABILITY_SOURCE_CODE_ID — also references IGS_AD_CODE_CLASSES; identifies the origin or method that produced the score.
• CALCULATION_DATE — the date on which the probability value was computed.
• PROBABILITY_VALUE — the numeric probability result itself.
• Standard EBS audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.

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.