Search Results lead_classification_flag

Overview

The view IGS_RC_I_ENTRY_STATS_V is a base inquiry view delivered within the Oracle Student System (IGS) product family. Its documented purpose is to serve as the Base View for Inquiry Entry Status, exposing the classification and status attributes that describe how an inquiry (prospective student or lead) entered the institution's recruitment pipeline. The view presents a flattened, reporting-friendly projection that joins the inquiry entry status records held in the IGS recruitment tables to the descriptive interest-type definitions maintained in the Oracle Advanced Scheduler (AS) interest type repository.

In the EBS 12.1.1 and 12.2.2 releases this view is used predominantly for recruitment reporting, inquiry analytics, and integration extracts where downstream systems require both the technical key of an inquiry entry status and its human-readable classification. Columns such as LEAD_CLASSIFICATION_FLAG, CONTACT_INTEREST_FLAG, EXPECTED_PURCHASE_FLAG, and COMPANY_CLASSIFICATION_FLAG are surfaced directly from the interest-type definition, allowing a single query to determine whether a given inquiry entry status participates in lead classification, contact interest, or other functional categorisations. Several attributes carried by predecessor views — including HIERARCHY_CD, HIERARCHY_MEANING, ENQUIRY_SOURCE_TYPE, ACTIVITY_SOURCE_CD, TEST_SOURCE_ID, PROG_CODE_REDUC_CD, and UNIT_SET_REDUC_CD — are documented as obsolete and are not exposed by this view.

Underlying Base Objects

The view is defined over two objects joined on the interest type identifier:

• IGS_RC_I_ENT_STATS (aliased IES) — the inquiry entry status base table, which supplies the entry status key, institution type, import source, email linkage, and package item reduction code.
• AS_INTEREST_TYPES_VL (aliased INVL) — the translated interest-type view from Oracle Advanced Scheduler, which supplies the interest type name, description, and the various functional classification flags.

The join predicate is IES.INTEREST_TYPE_ID = INVL.INTEREST_TYPE_ID. Because AS_INTEREST_TYPES_VL is a _VL (translated) view, only interest types having a translation in the session's language are returned. The ETRM metadata records no additional documented base objects beyond these two, and the row identifier is derived from IES.ROWID.

Key Columns

• ROW_ID — the ROWID of the underlying inquiry entry status row, useful for row-level identification.
• INQ_ENTRY_STAT_ID — primary key of the inquiry entry status record.
• INTEREST_TYPE_ID — the foreign key linking to the interest type definition.
• INQ_ENTRY_STAT and DESCRIPTION — the interest type name and description describing the entry status.
• INSTITUTION_TYPE — the institution category to which the entry status applies.
• IMP_SOURCE_TYPE_ID — identifies the import source type associated with the entry.
• EMAIL_LINK — the email linkage used when inquiries arrive through electronic channels.
• PKG_ITEM_REDUC_CD — the reduction code for the associated package item.
• ENABLED_FLAG and MASTER_ENABLED_FLAG — indicate whether the interest type is active, and whether the master interest type is active.
• LEAD_CLASSIFICATION_FLAG — indicates whether the interest type is used for lead classification, the attribute most directly relevant to the originating search.
• COMPANY_CLASSIFICATION_FLAG, CONTACT_INTEREST_FLAG, EXPECTED_PURCHASE_FLAG, CURRENT_ENVIRONMENT_FLAG — additional functional flags controlling how the interest type is applied.
• Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical usages include validating which inquiry entry statuses are enabled for lead classification, populating recruitment dashboards, and driving integration extracts into CRM or marketing systems.

SELECT inq_entry_stat_id,
       inq_entry_stat,
       description,
       lead_classification_flag
FROM   igs_rc_i_entry_stats_v
WHERE  lead_classification_flag = 'Y'
AND    enabled_flag = 'Y'
ORDER BY inq_entry_stat;

A second common pattern lists all entry statuses and their associated classification flags for a given institution type:

SELECT inq_entry_stat,
       institution_type,
       company_classification_flag,
       contact_interest_flag,
       expected_purchase_flag
FROM   igs_rc_i_entry_stats_v
WHERE  institution_type = :institution_type
ORDER BY inq_entry_stat;

Because the view returns translated interest-type text, it is also suitable for LOV definitions and multilingual reporting where the inquiry entry status label must be presented in the user's session language.