Search Results probability_source_code_id




Overview
Explore in AI Chat

Overview

IGS_AD_RECRUIT_PI_V is a supplementary view owned by the APPS schema in Oracle E-Business Suite, registered under the FND Design Data object IGS.IGS_AD_RECRUIT_PI_V. It belongs to the Oracle Student System / Admissions (IGS) product family and exposes recruitment probability index data used by the admissions recruiting functionality. According to the ETRM documentation, this view is a "supplementary view used to simplify forms coding," and Oracle explicitly warns that it should not be queried or altered directly, as its definition may change dramatically in subsequent minor or major releases. It is therefore a presentation-layer object supporting the admissions recruitment forms rather than a supported integration or reporting interface. The status is VALID in both 12.1.1 and 12.2.2, and the documented referenced base objects list shows IGS_AD_RECRUIT_PI and IGS_AD_CODE_CLASSES. The view is referenced by APPS.IGS_AD_IMP_PRBLTY_VAL_PKG, which indicates it participates in probability value import processing within the recruitment module.

Underlying Base Objects

The view is defined over two documented base objects. The primary table is APPS.IGS_AD_RECRUIT_PI, which stores recruitment probability index lines — one row per calculated probability for a person, keyed by a sequence-generated PROBABILITY_INDEX_ID. The second object, APPS.IGS_AD_CODE_CLASSES, is a code/classification lookup table that supplies the descriptive names used to translate the numeric type and source code identifiers into readable values. The view resolves PROBABILITY_TYPE_CODE_ID into TYPE_NAME and PROBABILITY_SOURCE_CODE_ID into SOURCE_NAME, which is consistent with a join against the code classes table. The presence of the ROW_ID (ROWID) column confirms this is a standard EBS forms-enabling view designed to give the form a stable row identifier while abstracting the multi-table join. Because no additional base objects are documented, the view's data set is limited to the recruitment probability index and its associated classification lookups.

Key Columns

The columns exposed by IGS_AD_RECRUIT_PI_V are as follows:

  • ROW_ID (ROWID) – Row identifier used by the form block for row-level operations.
  • PROBABILITY_INDEX_ID (NUMBER) – Sequence-generated primary identifier of the probability index line.
  • PERSON_ID (NUMBER) – Foreign key to HZ_PARTIES, identifying the person (prospect or applicant) assessed.
  • PROBABILITY_TYPE_CODE_ID (NUMBER) – Identifier of the probability type class, resolved to a descriptive name via IGS_AD_CODE_CLASSES.
  • TYPE_NAME (VARCHAR2) – Descriptive name of the probability type.
  • CALCULATION_DATE (DATE) – Date on which the probability was calculated.
  • PROBABILITY_VALUE (NUMBER) – The calculated numeric probability value.
  • PROBABILITY_SOURCE_CODE_ID (NUMBER) – Identifier of the probability source class, matching the user's search term; resolved to SOURCE_NAME.
  • SOURCE_NAME (VARCHAR2) – Descriptive name of the probability source.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard Who columns maintained by the EBS framework.

Common Use Cases and Queries

The principal consumers of this view are the admissions recruitment forms and the probability value import package IGS_AD_IMP_PRBLTY_VAL_PKG. Reporting or diagnostic queries typically join PERSON_ID to HZ_PARTIES and filter on the probability source code. A representative query is:

SELECT pi.PERSON_ID, pi.TYPE_NAME, pi.SOURCE_NAME, pi.CALCULATION_DATE, pi.PROBABILITY_VALUE FROM APPS.IGS_AD_RECRUIT_PI_V pi WHERE pi.PROBABILITY_SOURCE_CODE_ID = :source_code_id ORDER BY pi.CALCULATION_DATE DESC;

Because Oracle advises against direct queries, any such use should be treated as read-only and validated after upgrades, since the view definition is subject to change. For supported development, direct queries against IGS_AD_RECRUIT_PI joined to IGS_AD_CODE_CLASSES are preferable to relying on this view.