Search Results pkg_item_reduc_meaning




Overview
Explore in AI Chat

Overview

The IGS_RC_I_ENTRY_STATS_CV view belongs to the Oracle Student System (IGS) product family and serves as a foreign-key resolved view for Inquiry Entry Status records. It is a "CV" (code-and-meaning) view, meaning its principal design intent is to expose descriptive, human-readable values — meanings and descriptions — in place of the raw coded identifiers stored in the underlying transaction table. Where the base entity holds surrogate keys and lookup codes, this view resolves them against their respective validation and lookup sources so that reporting tools, concurrent programs, and inquiry screens can display business-friendly text without constructing their own joins.

The view is of particular interest to developers searching on the identifier pkg_item_reduc_meaning. That term corresponds directly to the PKG_ITEM_REDUC_MEANING column exposed by this view, which is the resolved meaning of the item reduction code (PKG_ITEM_REDUC_CD) carried on the entry status record. Implementers who encounter the code column in the base table and need the associated meaning should query this view rather than the base table.

Per the documented ETRM metadata, several attributes present in the legacy iteration of the view are now obsolete: ENQUIRY_SOURCE_TYPE, ENQ_SOURCE_DESCRIPTION, ACTIVITY_SOURCE_CD, ACTIVITY_SOURCE_MEANING, TEST_SOURCE_ID, HIERARCHY_CD, and related hierarchy attributes. Customizations or reports that still reference these columns must be remediated against the current column list. The metadata further records that the view is not implemented in the database in the documented environment, indicating that availability can vary by installation, patch level, or the specific ETRM reference snapshot.

Underlying Base Objects

The view text documents the following base objects, all joined with outer joins ((+)) on the lookup and descriptive sources to preserve rows even where validation data is absent:

The metadata lists no separately documented referenced base objects, so the view text is the authoritative record of its dependencies.

Key Columns

  • ROW_ID — ROWID of the underlying IGS_RC_I_ENT_STATS row, useful for direct row identification.
  • INQ_ENTRY_STAT_ID — primary key of the entry status record.
  • INQ_ENTRY_STAT / INQ_ENTRY_STAT_DESCRIPTION — interest type code and its description.
  • INTEREST_TYPE_ID, INSTITUTION_TYPE — foreign keys and classification attributes for the interest type.
  • IMP_SOURCE_TYPE_ID, IMP_SOURCE_TYPE — implied source type identifier and resolved value.
  • PKG_ITEM_REDUC_CD and PKG_ITEM_REDUC_MEANING — the item reduction code and its decoded meaning from the IGS_ITEM_REDUCTION lookup; the latter is the column referenced by searches for pkg_item_reduc_meaning.
  • EMAIL_LINK — email linkage attribute for the entry status configuration.
  • CONFIGURABILITY_FUNC_NAME / CONFIG_FUNC_NAME_DESC — the configurability function name and its user function description.
  • WHO columns — ENABLED_FLAG, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical uses include seeded inquiry/self-service entry status pages, validation of item reduction setup, and ad hoc reporting on entry status configuration. A representative query retrieving the resolved columns, including the item reduction meaning, is:

  • SELECT INQ_ENTRY_STAT, INQ_ENTRY_STAT_DESCRIPTION, IMP_SOURCE_TYPE, PKG_ITEM_REDUC_CD, PKG_ITEM_REDUC_MEANING, CONFIG_FUNC_NAME_DESC FROM IGS_RC_I_ENTRY_STATS_CV WHERE INQ_ENTRY_STAT = :p_interest_type;
  • SELECT INQ_ENTRY_STAT, PKG_ITEM_REDUC_MEANING FROM IGS_RC_I_ENTRY_STATS_CV WHERE ENABLED_FLAG = 'Y' AND PKG_ITEM_REDUC_CD IS NOT NULL ORDER BY INQ_ENTRY_STAT;

Because the resolution joins are outer joins, codes without matching lookup rows still return, with the meaning column null; reports should therefore tolerate null meanings or explicitly filter on populated codes.