Search Results igs_rc_is_info_req_pk

Overview

The IGS_RC_IS_INFO_REQ table is a core data structure within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically designed for the Recruiting and Admissions functionality. Its primary role is to act as a staging table that holds records for information requested by prospective students or applicants through the Self Service interface. This table facilitates the process where inquiries can request specific informational packages or items, effectively tracking these requests before they are processed or fulfilled by the institution. It serves as a critical link between an inquiry and the specific information materials offered by the institution.

Key Information Stored

While the full column list is not detailed in the provided metadata, the documented primary and foreign keys reveal the essential data points. The table's primary identifier is the INQ_INFO_REQ_ID column. The two critical foreign key columns define its relationships: INQ_INQ_ID links the request to a specific prospective student inquiry record in the IGS_RC_IS_INQUIRY table, and PACKAGE_ITEM_ID links the request to a specific informational package or item defined in the IGS_RC_I_PKG_ITEM table. Each record, therefore, represents a unique instance of an inquiry requesting a particular information item, storing relevant staging and status data pertinent to that request's lifecycle.

Common Use Cases and Queries

This table is central to managing prospect communications and tracking the distribution of recruitment materials. Common operational and reporting use cases include generating lists of pending information requests for fulfillment by the admissions office, analyzing the popularity of specific information packages to guide marketing efforts, and verifying that prospect inquiries have received all requested materials. A typical query would join IGS_RC_IS_INFO_REQ to the inquiry and package item tables to produce a detailed request report.

SELECT iir.inq_info_req_id,
       i.inquiry_number,
       pkg.item_name,
       iir.creation_date
FROM igs_rc_is_info_req iir,
     igs_rc_is_inquiry i,
     igs_rc_i_pkg_item pkg
WHERE iir.inq_inq_id = i.inq_inq_id
  AND iir.package_item_id = pkg.package_item_id
  AND iir.creation_date > SYSDATE - 30;

Related Objects

The IGS_RC_IS_INFO_REQ table has defined dependencies on two primary tables via foreign key constraints, forming the backbone of its data integrity.

• IGS_RC_IS_INQUIRY: This is the master inquiry table. The relationship is established via the column IGS_RC_IS_INFO_REQ.INQ_INQ_ID referencing IGS_RC_IS_INQUIRY. Every information request must be associated with a valid prospect inquiry.
• IGS_RC_I_PKG_ITEM: This table defines the catalog of available information packages or items (e.g., brochures, program guides). The relationship is established via the column IGS_RC_IS_INFO_REQ.PACKAGE_ITEM_ID referencing IGS_RC_I_PKG_ITEM. This links the request to the specific material being sought.

The table itself is identified by its primary key constraint, IGS_RC_IS_INFO_REQ_PK, on the INQ_INFO_REQ_ID column.