Search Results igs_rc_i_pkg_reduct

Overview

The table IGS_RC_I_PKG_REDUCT is a core data structure within the Oracle E-Business Suite's Student System (IGS) module, specifically for the Recruitment functionality. It serves as a junction table designed to store and manage reduction relationships. Its primary role is to define and enforce business rules that link a specific recruitment package item to permissible combinations of an inquiry's entry status, program of interest, and unit set of interest. This table is essential for configuring conditional logic within the recruitment process, ensuring that only relevant package items are presented or applied based on an inquiry's specific attributes.

Key Information Stored

The table's structure is defined by its primary and foreign key relationships, which dictate the critical data points it holds. The primary key, PKG_ITEM_REDUCT_ID, is a unique identifier for each reduction rule record. The table's core purpose is realized through its foreign key columns: PACKAGE_ITEM_ID links to the specific item in a recruitment package (IGS_RC_I_PKG_ITEM). The reduction conditions are defined by INQ_ENTRY_STAT_ID (referencing IGS_RC_I_ENT_STATS for the inquiry's entry status), INQ_PROG_ID, and INQ_USET_ID (both referencing AS_INTEREST_CODES_B for the program and unit set interest codes, respectively). These columns collectively store the rule that associates a package item with a particular inquiry profile.

Common Use Cases and Queries

A primary use case is the dynamic determination of applicable package items during the inquiry or application lifecycle. For instance, when an inquiry's status is updated or a program interest is selected, the system queries this table to find which package items should be activated or considered. A common reporting need is to audit all reduction rules associated with a specific recruitment package. A sample SQL pattern to retrieve all reduction rules for a given package item would be:

• SELECT pr.pkg_item_reduct_id, pr.package_item_id, pi.item_name, es.entry_status_code, ic_prog.interest_code AS program_interest, ic_uset.interest_code AS uset_interest
• FROM igs_rc_i_pkg_reduct pr
• JOIN igs_rc_i_pkg_item pi ON pr.package_item_id = pi.package_item_id
• LEFT JOIN igs_rc_i_ent_stats es ON pr.inq_entry_stat_id = es.inq_entry_stat_id
• LEFT JOIN as_interest_codes_b ic_prog ON pr.inq_prog_id = ic_prog.interest_code_id
• LEFT JOIN as_interest_codes_b ic_uset ON pr.inq_uset_id = ic_uset.interest_code_id
• WHERE pr.package_item_id = :p_package_item_id;

Related Objects

The IGS_RC_I_PKG_REDUCT table is centrally connected to several key entities in the Recruitment schema, as documented by its foreign key constraints. It is a child table of IGS_RC_I_PKG_ITEM, linking each reduction rule to a parent package item via the PACKAGE_ITEM_ID column. It references IGS_RC_I_ENT_STATS through the INQ_ENTRY_STAT_ID column to tie rules to specific inquiry entry statuses. Furthermore, it references the AS_INTEREST_CODES_B table twice: once via INQ_PROG_ID to link to an academic program of interest, and again via INQ_USET_ID to link to a unit set (major/plan) of interest. These relationships are fundamental for enforcing data integrity and enabling the complex joins required for recruitment business logic.