Search Results hierarchy_meaning




Overview
Explore in AI Chat

Overview

IGS_AD_INQ_ENTRY_STAT_V is a supplementary view owned by the APPS schema in Oracle E-Business Suite, registered under FND Design Data as IGS.IGS_AD_INQ_ENTRY_STAT_V. It belongs to the Student Systems / Admissions (IGS) product family and presents enquiry entry status configuration data in a denormalized, form-friendly format. The view exists primarily to simplify Forms coding within the Admissions enquiry entry setup screens, joining coded values to their translated meanings so that the form layer does not need to perform independent lookups against FND_LOOKUPS or related reference tables.

Oracle explicitly warns that this is a supplementary view intended for form support and does not recommend querying or altering data through it, noting that its structure may change dramatically in subsequent minor or major releases. Consequently, it should be treated as a read-only convenience object rather than a stable integration interface. In EBS 12.1.1 and 12.2.2 the view remains VALID and is defined in the APPS schema with public synonym conventions typical of IGS objects.

Underlying Base Objects

The ETRM metadata for this view documents no referenced base objects, which is consistent with the abbreviated metadata captured for supplementary views in the 12.2.2 repository. Based on the column set and naming conventions, the view is constructed over the enquiry entry status entity (IGS_AD_INQ_ENTRY_STAT) and its associated lookup and validation sources. Coded columns such as ENQUIRY_SOURCE_TYPE, ACTIVITY_SOURCE_CD, HIERARCHY_CD, PROG_CODE_REDUC_CD, UNIT_SET_REDUC_CD, and PKG_ITEM_REDUC_CD are paired with "_MEANING" or "_DESCRIPTION" columns, indicating joins to lookup views or reference tables that resolve codes to user-facing text.

The presence of INSTITUTION_TYPE, TEST_SOURCE, TEST_SOURCE_ID, IMP_SOURCE_TYPE_ID, and IMP_SOURCE_TYPE suggests linkages to admission test source and import source configuration. The ROW_ID column is a ROWID pseudo-column exposed for Forms row identification, while CONFIGURABILITY_FUNC_NAME and CONFIG_FUNC_NAME_DESC support configurable enquiry entry status behavior. The authoritative column list is the view source: ROW_ID, INQ_ENTRY_STAT_ID, INQ_ENTRY_STAT, INQ_ENTRY_STAT_DESCRIPTION, ENQUIRY_SOURCE_TYPE, ENQ_SOURCE_DESCRIPTION, ACTIVITY_SOURCE_CD, ACTIVITY_SOURCE_MEANING, INSTITUTION_TYPE, TEST_SOURCE, TEST_SOURCE_ID, IMP_SOURCE_TYPE_ID, IMP_SOURCE_TYPE, EMAIL_LINK, HIERARCHY_CD, HIERARCHY_MEANING, PROG_CODE_REDUC_CD, PROG_CODE_REDUC_MEANING, UNIT_SET_REDUC_CD, UNIT_SET_REDUC_MEANING, PKG_ITEM_REDUC_CD, PKG_ITEM_REDUC_MEANING, CLOSED_IND, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, CONFIGURABILITY_FUNC_NAME, and CONFIG_FUNC_NAME_DESC.

Key Columns

  • INQ_ENTRY_STAT_ID / INQ_ENTRY_STAT / INQ_ENTRY_STAT_DESCRIPTION — Primary identifier, code, and description of the enquiry entry status record.
  • HIERARCHY_CD / HIERARCHY_MEANING — The hierarchy code and its resolved meaning; this is the column pair most commonly surfaced when users search for "hierarchy_meaning" against this view.
  • ENQUIRY_SOURCE_TYPE / ENQ_SOURCE_DESCRIPTION — Enquiry source classification and its descriptive text.
  • ACTIVITY_SOURCE_CD / ACTIVITY_SOURCE_MEANING — Activity source code and translated meaning.
  • PROG_CODE_REDUC_CD, UNIT_SET_REDUC_CD, PKG_ITEM_REDUC_CD and their _MEANING counterparts — Reduction rules applied to program codes, unit sets, and package items.
  • CLOSED_IND — Indicates whether the enquiry entry status is closed.
  • Who columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN for audit tracking.

Common Use Cases and Queries

Typical usage includes validating enquiry entry status setup during implementation, verifying that hierarchy and reduction rule translations resolve correctly, and supporting Forms personalization or diagnostic queries. A basic query retrieving hierarchy meaning is:

SELECT INQ_ENTRY_STAT, INQ_ENTRY_STAT_DESCRIPTION, HIERARCHY_CD, HIERARCHY_MEANING FROM APPS.IGS_AD_INQ_ENTRY_STAT_V WHERE CLOSED_IND = 'N';

To isolate reduction rules for a specific enquiry status:

SELECT INQ_ENTRY_STAT, PROG_CODE_REDUC_MEANING, UNIT_SET_REDUC_MEANING, PKG_ITEM_REDUC_MEANING FROM APPS.IGS_AD_INQ_ENTRY_STAT_V WHERE INQ_ENTRY_STAT = :status;

Because the view is documented as unstable, custom reports should prefer the underlying base tables and lookup views where the same information is required for long-term integration.