Search Results probability_source_code_id




Overview
Explore in AI Chat

Overview

The view IGSBV_STDNT_RECRUITMNT_PROB is a read-only database object owned by the APPS schema within the Oracle E-Business Suite Student System (IGS) product family. In EBS 12.1.1 and 12.2.2, it exposes recruitment probability index data associated with prospective students. The "BV" naming convention denotes a business view intended for reporting, inquiry, and downstream integration rather than for transactional data entry. Functionally, the view surfaces the probability that a given person will convert through the recruitment pipeline, along with the date the probability was calculated, the probability value itself, and the source from which that probability was derived. Because it is defined WITH READ ONLY, consumers cannot perform DML through the view; all maintenance must occur against the underlying table. This makes it a safe, stable interface for Reports, BI Publisher data models, OAF inquiry pages, and custom PL/SQL extracts.

Underlying Base Objects

The view is defined over a single documented base object: IGS_AD_RECRUIT_PI (Recruitment Probability Index). The view text is a straightforward projection:

No joins, filters, decode logic, or analytic functions are applied, so the view is effectively a column-limited, read-only alias of the base table. It inherits the WHO audit columns directly. Because the view is a pass-through, query performance matches direct access to IGS_AD_RECRUIT_PI; no materialization or aggregation occurs.

Key Columns

  • PROBABILITY_INDEX_ID — Primary identifier for each probability index record.
  • PERSON_ID — Foreign key to the person (prospect/applicant) for whom the probability is recorded.
  • PROBABILITY_TYPE_CODE_ID — Identifies the type or category of probability being calculated.
  • CALCULATION_DATE — The date on which the probability value was computed; central to trending, recency, and "as-of" reporting. This is the column most relevant to the user's search term.
  • PROBABILITY_VALUE — The numeric probability outcome produced by the recruitment calculation engine.
  • PROBABILITY_SOURCE_CODE_ID — Indicates the origin of the probability, such as a specific calculation model or process.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard WHO audit columns.

Common Use Cases and Queries

Typical scenarios include identifying the most recent probability for a prospect, comparing values across calculation dates, and auditing which source produced a given score. Because the metadata documents no lookups or joins, callers should join to person and lookup tables explicitly.

  • Retrieve the latest probability per person using the calculation date.
  • Report probability trends for a recruitment cycle.
  • Extract records created or updated within an audit window.

Sample SQL:

  • SELECT person_id, probability_value, calculation_date FROM igsbv_stdnt_recruitmnt_prob WHERE person_id = :p_person_id ORDER BY calculation_date DESC;
  • SELECT person_id, probability_type_code_id, probability_value FROM igsbv_stdnt_recruitmnt_prob WHERE calculation_date >= :p_start_date;
  • SELECT * FROM igsbv_stdnt_recruitmnt_prob WHERE last_update_date >= TRUNC(SYSDATE)-7;

Because the view is read-only and unfiltered, all business logic, security predicates, and lookup resolution must be applied by the consuming query or report.