Search Results igs_in_enq_src_type_pk

Overview

The IGS_IN_ENQ_SRC_TYPE table is a foundational data entity within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. Its primary function is to define and store the distinct categories or sources from which prospective student enquiries originate, such as "newspaper advertising" or "school liaison activity." This table acts as a reference or lookup table, enabling the systematic classification of enquiry data captured elsewhere in the system. A critical piece of information from the official ETRM documentation is that this entity is explicitly marked as "Obsolete." This status indicates that while the table may still exist in the database schema for backward compatibility, its use in new implementations or processes is deprecated, and it may have been superseded by other data models or tables in later releases of the application.

Key Information Stored

Based on the provided metadata, the table's structure is centered around a primary key column that defines the enquiry source type. While a full column list is not provided, the documented constraints reveal the core data element.

• ENQUIRY_SOURCE_TYPE: This is the table's primary key column, as defined by the constraint IGS_IN_ENQ_SRC_TYPE_PK. It stores the unique code or identifier for each valid source of enquiry (e.g., 'NEWS', 'SCHOOL'). This column is the target for foreign key relationships from other transactional tables.

The table's purpose is to maintain a controlled list of these source types, ensuring data integrity and consistency in reporting and analysis of student recruitment channels.

Common Use Cases and Queries

Despite its obsolete status, the table's primary historical use case was to support reporting and analysis on the effectiveness of different student recruitment and marketing initiatives. Administrators could analyze enquiry volumes by source to allocate resources effectively. A typical query would join this reference table to transactional data to produce a meaningful report.

Sample Query Pattern:
SELECT stat.*, src_type.ENQUIRY_SOURCE_TYPE
FROM IGS_AD_I_ENTRY_STATS stat,
IGS_IN_ENQ_SRC_TYPE src_type
WHERE stat.ENQUIRY_SOURCE_TYPE = src_type.ENQUIRY_SOURCE_TYPE
AND stat.ENQUIRY_DATE BETWEEN :P_START_DATE AND :P_END_DATE;
This query retrieves entry statistics data alongside the descriptive source type. Given the obsolete status, new customizations or reports should verify if an alternative, active table is recommended by Oracle.

Related Objects

The documented foreign key relationship explicitly defines how this table integrates with the broader Student System schema. The primary related object is:

• IGS_AD_I_ENTRY_STATS: This is a transactional or statistical table that records individual enquiry or entry statistics. It contains a foreign key column, IGS_AD_I_ENTRY_STATS.ENQUIRY_SOURCE_TYPE, which references the primary key IGS_IN_ENQ_SRC_TYPE.ENQUIRY_SOURCE_TYPE. This relationship ensures that every enquiry source recorded in the entry statistics table is a valid type defined in the IGS_IN_ENQ_SRC_TYPE lookup table.

This relationship is crucial for understanding data flow; the IGS_IN_ENQ_SRC_TYPE table provides the domain of valid values for the source type attribute stored in the IGS_AD_I_ENTRY_STATS table.