Search Results test_source

Overview

IGS_AD_INQ_ENTRY_STAT_V is a reporting view within the Oracle E-Business Suite Student System (IGS) module. Its name derives from "Admissions Inquiry Entry Status," reflecting its role in presenting configured inquiry entry statuses and the descriptive attributes that govern how admissions inquiries are categorized, sourced, and reduced during processing. The view consolidates denormalized lookup descriptions alongside the core entry status definition, allowing inquiry entry status records to be reported with human-readable meanings rather than raw coded values.

In the context of Oracle EBS 12.1.1 and 12.2.2, this object is explicitly documented as obsolete. The ETRM metadata records that the view is "not implemented in this database," meaning it does not exist in a standard or currently supported installation. It was defined in earlier iterations of the Student System before the relevant admissions inquiry functionality was deprecated or superseded. Consequently, it should not be relied upon for new development, customization, or integration work, and any existing references to it should be treated as legacy artifacts requiring migration or removal.

Underlying Base Objects

According to the documented view text, IGS_AD_INQ_ENTRY_STAT_V is constructed from a join across the following base objects:

• IGS_AD_I_ENTRY_STATS — the primary admissions inquiry entry statistics table (aliased IES), supplying the driving records and most columns.
• IGS_AD_CODE_CLASSES — aliased CC1, joined via TEST_SOURCE_ID to CODE_ID to resolve the test source description (TEST_SOURCE).
• IGS_PE_SRC_TYPES — aliased PSR, joined via IMP_SOURCE_TYPE_ID to SOURCE_TYPE_ID to provide the implementation source type.
• IGS_IN_ENQ_SRC_TYPE — aliased EST, joined via ENQUIRY_SOURCE_TYPE to supply the enquiry source type and its description.
• IGS_LOOKUPS_VIEW — referenced five times as LK1 through LK5, resolving encoded meanings for hierarchy code, activity source, and the three item reduction codes (program, unit set, and package item).
• FND_FORM_FUNCTIONS_VL — aliased FFV, joined via CONFIGURABILITY_FUNC_NAME to FUNCTION_NAME, resolving the user function name for configurability.

All joins to the lookup and descriptive tables are outer joins, permitting entry status records to appear even where no matching descriptive value is defined. The ETRM metadata lists no referenced base objects separately, though the view text documents the participants above.

h4>Key Columns

• INQ_ENTRY_STAT_ID / INQ_ENTRY_STAT — the primary identifier and coded name of the inquiry entry status.
• INQ_ENTRY_STAT_DESCRIPTION — the descriptive text for the entry status.
• ENQUIRY_SOURCE_TYPE / ENQ_SOURCE_DESCRIPTION — the enquiry source type code and its resolved description.
• ACTIVITY_SOURCE_CD / ACTIVITY_SOURCE_MEANING — activity source code with lookup-derived meaning.
• INSTITUTION_TYPE — the institution classification applicable to the status.
• TEST_SOURCE / TEST_SOURCE_ID — test source name and identifier from code classes.
• HIERARCHY_CD and reduction codes — hierarchy, program code reduction, unit set reduction, and package item reduction codes, each with their lookup meanings.
• CLOSED_IND — indicates whether the entry status is closed.
• CONFIGURABILITY_FUNC_NAME — the associated form function name.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

In legacy environments this view served reporting and inquiry screens needing descriptive context for entry statuses. A representative query, guarded by existence checks, would be:

SELECT INQ_ENTRY_STAT, INQ_ENTRY_STAT_DESCRIPTION, ENQ_SOURCE_DESCRIPTION, ACTIVITY_SOURCE_MEANING, CLOSED_IND FROM IGS_AD_INQ_ENTRY_STAT_V WHERE CLOSED_IND = 'N';

Because the view is documented as obsolete and not implemented, it should not be used in new builds. Modernizations should query IGS_AD_I_ENTRY_STATS directly and join lookups explicitly. Teams should verify presence via ALL_VIEWS before referencing it.