Search Results igs_ad_i_entry_stats_v

Overview

IGS_AD_I_ENTRY_STATS_V is an Oracle E-Business Suite dictionary view owned by the APPS schema and defined over the Student System (IGS) product family. In ETRM 12.1.1 and 12.2.2 it carries a status of VALID at the database level but is explicitly documented as obsolete in the functional metadata. The view exposes the rows of the IGS_AD_I_ENTRY_STATS table joined to IGS_LOOKUPS_VIEW so that the stored lookup code in the HIERARCHY_CD column is presented alongside its decoded meaning. In Admissions and recruitment reporting, this object was used to enumerate admissions enquiry entry-status definitions, their hierarchical grouping, and the reduction options applied when a prospect or applicant record is created. Because it is a view rather than a table, it holds no storage of its own and is dependent on the two referenced objects; any change to their definition or to the HIERARCHY lookup type is reflected immediately at query time. Its role is essentially reporting and integration-facing: it presents denormalised, human-readable enquiry entry statistics that can be consumed by concurrent programs, Discoverer workbooks, or custom interfaces without the caller needing to re-derive the hierarchy description.

Underlying Base Objects

The view text defines a two-object join with no aggregation or inline subqueries:

• IGS_AD_I_ENTRY_STATS IES — the driving table holding admission enquiry entry statistics. All addressable data columns originate here.
• IGS_LOOKUPS_VIEW LK — the lookup decoding source, joined as IES.HIERARCHY_CD = LK.LOOKUP_CODE with the restricting predicate LK.LOOKUP_TYPE = 'HIERARCHY'.

The join is therefore an equality join guaranteed to return at most one lookup row per entry-statistics row, assuming HIERARCHY lookup codes are unique. Rows whose HIERARCHY_CD has no matching HIERARCHY lookup entry are silently excluded. ETRM documentation for 12.2.2 records no separate referenced base objects beyond the excerpt above, so the dependency chain is limited to these two objects.

h4>Key Columns

• ROW_ID / ROWID — the row identifier inherited from IGS_AD_I_ENTRY_STATS; the documented column list shows ROW_ID while the select list aliases ROWID.
• INQ_ENTRY_STAT_ID / INQ_ENTRY_STAT / DESCRIPTION — the primary key, internal code, and description of the enquiry entry status.
• HIERARCHY_CD / HIERARCHY_MEANING — the raw hierarchy lookup code and its decoded meaning from IGS_LOOKUPS_VIEW.
• ENQUIRY_SOURCE_TYPE / ACTIVITY_SOURCE_CD / INSTITUTION_TYPE — classification attributes controlling where the entry status applies.
• TEST_SOURCE_ID / IMP_SOURCE_TYPE_ID / EMAIL_LINK — implementation source and communication attributes.
• PROG_CODE_REDUC_CD / UNIT_SET_REDUC_CD / PKG_ITEM_REDUC_CD — the reduction codes for program code, unit set, and package item respectively. PROG_CODE_REDUC_CD is the column matched by the search term "prog_code_reduc_cd"; it stores the code used to reduce or suppress the program code element when the associated entry statistics record is applied.
• CLOSED_IND — flags whether the entry status is closed.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard audit columns propagated from the base table.

Common Use Cases and Queries

The view was typically queried to populate selection lists or to validate configuration of enquiry entry statistics. A representative query filtering the reduction code follows:

• SELECT inq_entry_stat, description, hierarchy_cd, hierarchy_meaning FROM igs_ad_i_entry_stats_v WHERE prog_code_reduc_cd IS NOT NULL AND closed_ind = 'N';
• SELECT hierarchy_cd, COUNT(*) FROM igs_ad_i_entry_stats_v GROUP BY hierarchy_cd; — distribution of entry statistics across hierarchy groupings.
• SELECT * FROM igs_ad_i_entry_stats_v WHERE inq_entry_stat_id = :id; — single-record retrieval for an interface or form.

Because the object is marked obsolete, new development in 12.1.1 or 12.2.2 should treat it as read-only reference material and prefer the current replacement delivered by Oracle for the Admissions enquiry entry statistics configuration.