Search Results igs_in_applinfo_type_pk

Overview

The IGS_IN_APPLINFO_TYPE table is a core data entity within the Oracle E-Business Suite (EBS) Student System (IGS) module. It functions as a junction table designed to record the specific types of information requested by an applicant during an enquiry or application process. Its primary role is to establish a many-to-many relationship between an applicant's enquiry record and the predefined catalogue of information types available. A critical note from the official documentation is that this entity is marked as Obsolete. This status indicates that while the table may exist in the database schema for backward compatibility, its associated business logic is likely deprecated, and it should not be used for new development in versions 12.1.1 or 12.2.2.

Key Information Stored

The table's structure is defined by a composite primary key, which uniquely identifies each record by linking an applicant's enquiry to a specific information type. The key columns are PERSON_ID, which stores the unique identifier for the applicant; ENQUIRY_APPL_NUMBER, which identifies the specific enquiry or application instance; and ENQUIRY_INFORMATION_TYPE, a code that references the type of information requested. The ENQUIRY_INFORMATION_TYPE column is also the sole foreign key in the table, enforcing referential integrity by linking to the master list of valid information types defined elsewhere in the system.

Common Use Cases and Queries

Given its obsolete status, direct operational use of this table in new interfaces or processes is not recommended. Its primary use case in a contemporary EBS environment would be for historical data analysis or supporting legacy data extracts. For instance, an administrator might need to generate a report of all information types requested for a specific applicant's historical enquiries. A sample query for such a legacy report would join this table to the applicant and information type master tables.

SELECT appl.person_id,
       appl.enquiry_appl_number,
       appl.enquiry_information_type,
       info_type.description
FROM igs.igs_in_applinfo_type appl
JOIN igs.igs_in_enq_info_type info_type
  ON appl.enquiry_information_type = info_type.enquiry_information_type
WHERE appl.person_id = :p_person_id;

Related Objects

The table maintains defined relationships with other entities in the Student System schema, as per the provided metadata. The primary key constraint IGS_IN_APPLINFO_TYPE_PK ensures uniqueness on the combination of its three key columns. For foreign key relationships, the table references one primary object:

• IGS_IN_ENQ_INFO_TYPE: This is the master table for enquiry information types. The column IGS_IN_APPLINFO_TYPE.ENQUIRY_INFORMATION_TYPE is a foreign key that references this table, validating that the type recorded against an applicant's enquiry exists in the master list.

The metadata also indicates a second, incomplete foreign key reference ("Table: IGS_IN_APPLINFO_TYPE.ENQUIRY_INFORMATION_TYPE → %"), which suggests a potential circular or self-referential relationship that is not fully documented in the excerpt provided.