Search Results prog_code_reduc_cd




Overview
Explore in AI Chat

Overview

IGS.IGS_AD_I_ENTRY_STATS is a transactional configuration table within the Oracle E-Business Suite Advanced Admissions and Recruitment (IGS) product family. It stores inquiry entry statuses: discrete states that characterize where an enquiry (prospective applicant record) sits within the admissions funnel before it becomes a formal application. The table acts as a controlled reference set used throughout the admissions subsystem to classify and drive enquiry processing, reporting, and downstream conversions.

Within the ETRM documentation this object is explicitly flagged as Obsolete. Organizations running a current 12.1.1 or 12.2.2 instance should treat it as a legacy artifact inherited from earlier admissions releases; new configuration should generally be modeled against supported replacement structures. The table remains VALID at the database level and continues to be physically present in the APPS_TS_TX_DATA tablespace with a PCTFREE of 10.

Applying a heuristic Data Vault classification, the mined FK structure places this object as a hub. It carries a single surrogate/natural business key (INQ_ENTRY_STAT_ID) that other admissions tables reference, with the remaining attributes behaving as descriptive context. This classification should be read as a modeling suggestion for integration or warehouse design rather than as a statement of EBS internal architecture.

Key Information Stored

The table contains twenty documented columns. The most significant are:

Common Use Cases and Queries

The principal use case is inquiry-funnel reporting: joining entry statuses to enquiries to count prospects in each stage. A typical lookup retrieves statuses filtered by source or institution type:

  • SELECT INQ_ENTRY_STAT_ID, INQ_ENTRY_STAT, DESCRIPTION FROM IGS.IGS_AD_I_ENTRY_STATS WHERE CLOSED_IND = 'N';
  • SELECT ... WHERE ENQUIRY_SOURCE_TYPE = :source AND INSTITUTION_TYPE = :inst_type;
  • SELECT ... WHERE TEST_SOURCE_ID = :test_source_id; — the pattern implied by the user's search on test_source_id.

Status records are consumed when enrolling enquiries into programs, unit sets, packages, and test types, and when converting enquiries to applications through IGS_IN_ENQUIRY_APPL_ALL. Given the obsolete status, reporting should primarily use existing data rather than extending this configuration.

Related Objects

The table participates in a small, well-defined FK cluster. Foreign keys reference:

Tables that reference this hub through INQ_ENTRY_STAT_ID include IGS_AD_ENT_ORG_UNITS, IGS_AD_ENT_PKG_ITEMS, IGS_AD_ENT_INQ_PROGS, IGS_AD_ENT_TEST_TYPS, IGS_AD_ENT_INQ_USET, IGS_AD_SS_REGIONS, and IGS_IN_ENQUIRY_APPL_ALL. These downstream relationships confirm the table's role as a central status reference driving enquiry enrolment and application conversion.