Search Results igs_rc_i_a_itype




Overview
Explore in AI Chat

Overview

The IGS_RC_I_A_ITYPE table is a core data object within the Oracle E-Business Suite Student System (IGS). It functions as a junction table that explicitly links an enquiry or application to the specific types of information requested as part of that process. Its primary role is to define the information requirements for a given enquiry, enabling the system to track and manage what applicant data needs to be collected, processed, or reviewed. This table is essential for configuring and supporting detailed, structured admissions and recruitment workflows.

Key Information Stored

The table's structure centers on a composite primary key that uniquely identifies each information type request for a specific enquiry. The key columns are ENQUIRY_APPL_NUMBER, which identifies the application instance; PERSON_ID, which identifies the applicant; and INFO_TYPE_ID, which is a foreign key referencing the specific type of information requested. The INFO_TYPE_ID is the critical column that links to the master list of available information items, stored in the IGS_RC_I_PKG_ITEM table. This design allows a single enquiry to be associated with multiple, distinct information requirements.

Common Use Cases and Queries

A primary use case is generating reports or checklists detailing all data points required for a set of applications, such as for a specific academic program or intake period. Administrators can query this table to verify application completeness or to drive dynamic forms. A typical query would join IGS_RC_I_A_ITYPE to the main application header table (not explicitly listed but implied by the key structure) and to IGS_RC_I_PKG_ITEM to get the description of the information type. For example, to list all information types requested for a specific application, one might use: SELECT iri.info_type_id, irpi.item_name FROM igs_rc_i_a_itype iri, igs_rc_i_pkg_item irpi WHERE iri.info_type_id = irpi.info_type_id AND iri.enquiry_appl_number = [APPL_NUMBER] AND iri.person_id = [PERSON_ID];.

Related Objects

  • Primary Key: IGS_RC_I_A_ITYPE_PK on columns (ENQUIRY_APPL_NUMBER, PERSON_ID, INFO_TYPE_ID).
  • Foreign Key (References): The INFO_TYPE_ID column in IGS_RC_I_A_ITYPE is a foreign key that references the IGS_RC_I_PKG_ITEM table. This relationship ensures referential integrity, meaning every information type requested in an enquiry must be defined as a valid item in the package item master table.