Search Results igs_in_applinfo_type_u1

Overview

The IGS_IN_APPLINFO_TYPE table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically under the IGS (iGrants) product family. It serves as a junction table designed to associate an individual's enquiry or application with specific types of information requested during that process. The table's primary role is to categorize and track the subject matter of enquiries, such as requests for details on travel, accommodation, or fees, linking them to the relevant person and application number. It is critical to note that the provided ETRM documentation explicitly marks this table as "Obsolete." This status indicates that while the table may exist in the database for backward compatibility, its associated business logic is likely deprecated, and its use in new customizations or integrations is strongly discouraged.

Key Information Stored

The table stores a composite record keyed by three mandatory columns, alongside standard audit columns. The primary data elements define the relationship between an applicant, their specific enquiry instance, and the category of information sought.

• PERSON_ID (NUMBER): Uniquely identifies the individual who made the enquiry.
• ENQUIRY_APPL_NUMBER (NUMBER): Identifies the specific enquiry instance made by the person.
• ENQUIRY_INFORMATION_TYPE (VARCHAR2): A code representing the user-defined category of information requested (e.g., 'TRAVEL', 'ACCOMM', 'FEES'). This column is a foreign key to a lookup table defining valid types.
• Standard WHO Columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN for tracking record authorship and modifications.

Common Use Cases and Queries

Given its obsolete status, primary use cases involve historical reporting, data migration validation, or supporting legacy interfaces. A typical analytical query would involve joining to person and enquiry header tables to report on the frequency of different enquiry types.

Sample Query: Retrieve All Enquiry Information Types for a Specific Person

SELECT person_id, enquiry_appl_number, enquiry_information_type, creation_date
FROM igs.igs_in_applinfo_type
WHERE person_id = :p_person_id
ORDER BY enquiry_appl_number, creation_date;

Sample Query: Aggregate Count of Enquiries by Information Type

SELECT enquiry_information_type, COUNT(*) AS enquiry_count
FROM igs.igs_in_applinfo_type
GROUP BY enquiry_information_type
ORDER BY enquiry_count DESC;

Related Objects

The table's integrity is maintained through defined key relationships with other objects in the IGS schema. The primary key ensures uniqueness for each combination of person, application, and information type.

• Primary Key: IGS_IN_APPLINFO_TYPE_PK on (PERSON_ID, ENQUIRY_APPL_NUMBER, ENQUIRY_INFORMATION_TYPE).
• Foreign Key Relationship: The ENQUIRY_INFORMATION_TYPE column references a lookup table, likely named IGS_IN_ENQ_INFO_TYPE, which holds the valid set of descriptive codes for enquiry categories. This enforces referential integrity for the type code.
• Indexes: Two indexes support performance:
  • IGS_IN_APPLINFO_TYPE_U1: Unique index on the primary key columns.
  • IGS_IN_APPLINFO_TYPE_N1: Non-unique index on ENQUIRY_INFORMATION_TYPE for efficient filtering by type.