Search Results igs_rc_i_e_chartyp_pk




Overview
Explore in AI Chat

Overview

The table IGS_RC_I_E_CHARTYP is a data dictionary object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically belonging to the IGS (Student System) product family. As per the official ETRM documentation, its primary function is to describe the characteristics of an enquirer to the institution. This table served as a master reference for classifying the different types of attributes or traits that could be associated with prospective students or general inquiries. It is critical to note that the ETRM explicitly marks the IGS Student System module as "Obsolete," indicating this table and its related functionality are part of a legacy codebase that may no longer be actively developed or implemented in newer installations. Furthermore, the provided metadata states "Not implemented in this database," suggesting that while the table definition exists in the data dictionary, it may not be populated or used in a standard deployment.

Key Information Stored

Based on the documented structure, the table's design centers on a single primary key column that defines the characteristic type. The most critical data element is ENQUIRY_CHARACTERISTIC_TYPE. This column acts as the unique identifier (Primary Key: IGS_RC_I_E_CHARTYP_PK) for each valid characteristic classification. While the ETRM excerpt does not list additional columns, such a master table would typically contain descriptive columns like a meaning or description field, enable/disable flags, and who columns (CREATION_DATE, CREATED_BY, etc.) for auditing. The core business data stored would be the controlled list of codes (e.g., 'SOURCE_OF_INTEREST', 'INQUIRY_METHOD', 'PROGRAM_INTEREST_AREA') used to categorize and analyze enquirer profiles.

Common Use Cases and Queries

In an operational context, this table would be used to maintain the list of valid enquirer characteristics for application setup and data validation. Common use cases included configuring the types of information captured during the inquiry process and generating reports segmented by enquirer characteristics. Sample SQL would involve querying the master list or joining to transactional data. For example, a basic query to retrieve all active characteristic types would be: SELECT enquiry_characteristic_type FROM igs_rc_i_e_chartyp WHERE enabled_flag = 'Y' ORDER BY 1;. In reporting, a join to related transactional tables would enable analysis: SELECT e.enquiry_characteristic_type, COUNT(*) FROM igs_rc_i_a_chartyp a, igs_rc_i_e_chartyp e WHERE a.enquiry_characteristic_type = e.enquiry_characteristic_type GROUP BY e.enquiry_characteristic_type;.

Related Objects

The ETRM documentation confirms a direct foreign key relationship from the table IGS_RC_I_A_CHARTYP to this master table. This relationship is defined as follows:

  • Referencing Table: IGS_RC_I_A_CHARTYP
  • Foreign Key Column: IGS_RC_I_A_CHARTYP.ENQUIRY_CHARACTERISTIC_TYPE
  • References: IGS_RC_I_E_CHARTYP.ENQUIRY_CHARACTERISTIC_TYPE (Primary Key)
This indicates that IGS_RC_I_A_CHARTYP is a transactional or assignment table that stores specific instances of characteristics assigned to actual enquirer records, with its ENQUIRY_CHARACTERISTIC_TYPE column validated against the master list defined in IGS_RC_I_E_CHARTYP.