Search Results igs_in_enq_char_type




Overview
Explore in AI Chat

Overview

The IGS_IN_ENQ_CHAR_TYPE table is a core data entity within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Student System) module. Its primary function is to define and store the distinct characteristics or classifications that can be assigned to an individual inquiring about the institution. These characteristics, such as 'School Leaver', 'Graduate', 'Domestic', or 'International', are used for statistical analysis and to enable the customization of information packages or communications sent to prospective students. It is critical to note that the official ETRM documentation explicitly marks this table as 'Obsolete'. This status indicates that while the table may exist in the database for backward compatibility, its use in new development is discouraged, and it may be targeted for removal in a future release.

Key Information Stored

The table's structure is centered on a code that uniquely identifies each enquirer characteristic type. Based on the provided metadata, the primary and most significant column is ENQUIRY_CHARACTERISTIC_TYPE. This column serves as the unique identifier (Primary Key) for each characteristic record. While the specific data type and length are not detailed in the excerpt, it is typically a VARCHAR2 field holding a short, meaningful code. The table likely contains other standard descriptive columns common to IGS setup tables, such as a description field, effective dates, and who-columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE), though these are not explicitly listed in the provided documentation.

Common Use Cases and Queries

Given its obsolete status, active transactional use of this table in new processes is not recommended. However, it may be referenced in historical data analysis, legacy reports, or data migration validations. Common interactions would involve querying the list of valid characteristics or joining to related application data. A typical query to retrieve all defined characteristic types would be: SELECT enquiry_characteristic_type FROM igs.igs_in_enq_char_type WHERE SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE);. For reporting on historical applications linked to these characteristics, a join would be necessary: SELECT appl.*, char_type.* FROM igs_in_appl_char_typ appl, igs_in_enq_char_type char_type WHERE appl.enquiry_characteristic_type = char_type.enquiry_characteristic_type;.

Related Objects

The table maintains a direct foreign key relationship, which is crucial for understanding its integration within the Student System data model. The documented relationship is as follows:

  • Referencing Table: IGS_IN_APPL_CHAR_TYP
  • Foreign Key Column: IGS_IN_APPL_CHAR_TYP.ENQUIRY_CHARACTERISTIC_TYPE
  • Joins to: IGS_IN_ENQ_CHAR_TYPE.ENQUIRY_CHARACTERISTIC_TYPE

This relationship signifies that the IGS_IN_APPL_CHAR_TYP table, which stores characteristic information for specific applications, uses the codes defined in IGS_IN_ENQ_CHAR_TYPE as a validation source. Any characteristic assigned to an application must exist as a valid type in this master table.