Search Results igs_rc_i_ent_stats




Overview
Explore in AI Chat

Overview

The IGS_RC_I_ENT_STATS table is a data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically belonging to the now-obsolete Student System (IGS) module. Its primary function is to serve as a master table for storing distinct inquiry entry statuses. In the context of student lifecycle management, an inquiry represents a prospective student's initial contact or expression of interest. This table would have been central to categorizing and tracking the various stages or states an inquiry record could occupy during its processing within the recruitment and admissions cycle. Its designation as "Not implemented in this database" in the provided metadata suggests it may represent a legacy or template structure not deployed in all instances, a common occurrence with the retired IGS module.

Key Information Stored

The core data stored in IGS_RC_I_ENT_STATS revolves around defining unique statuses for inquiries. The primary identifier is the INQ_ENTRY_STAT_ID column, which serves as the primary key. The table's structure, as indicated by its foreign keys, is designed to integrate with other system components. It links to institutional types (INSTITUTION_TYPE referencing IGS_OR_ORG_INST_TYPE_ALL), import source types (IMP_SOURCE_TYPE_ID referencing IGS_PE_SRC_TYPES_ALL), and marketing interest types (INTEREST_TYPE_ID referencing AS_INTEREST_TYPES_B). This design implies that an inquiry entry status could be contextualized or filtered based on the institution, the source of the inquiry data, and the prospective student's area of interest.

Common Use Cases and Queries

This table would have been queried to support operational reporting and process management in student recruitment. Common use cases include generating lists of inquiries filtered by their current status, configuring valid status transitions in the application UI, and analyzing inquiry pipeline metrics. A typical reporting query might join this table to related inquiry transaction tables to count inquiries per status.

SELECT stat.INQ_ENTRY_STAT_ID, stat.INSTITUTION_TYPE, COUNT(inq.inquiry_id)
FROM IGS_RC_I_ENT_STATS stat
LEFT JOIN IGS_RC_I_E_ORGUNITS inq ON stat.INQ_ENTRY_STAT_ID = inq.INQ_ENTRY_STAT_ID
GROUP BY stat.INQ_ENTRY_STAT_ID, stat.INSTITUTION_TYPE;

Another common pattern would involve retrieving the valid statuses for a given institution or interest type to populate application list of values (LOVs).

Related Objects

The IGS_RC_I_ENT_STATS table has defined relationships with several other tables in the obsolete IGS module, forming a part of the inquiry data model. It is referenced as a foreign key by the following tables:

  • IGS_RC_I_E_ORGUNITS: Likely stores organizational unit-specific details for an inquiry.
  • IGS_RC_I_E_TESTTYPS: Likely associates inquiry records with specific test types.
  • IGS_RC_I_PKG_REDUCT: Likely manages package or fee reductions related to an inquiry status.
It also references master tables for institution type (IGS_OR_ORG_INST_TYPE_ALL), source types (IGS_PE_SRC_TYPES_ALL), and interest types (AS_INTEREST_TYPES_B).