Search Results igs_ad_rvgr_inc_exc




Overview
Explore in AI Chat

Overview

The IGS_AD_RVGR_INC_EXC table is a data structure within the Oracle E-Business Suite, specifically belonging to the now-obsolete IGS (Student System) product. Its primary function is to store configuration rules that define inclusion or exclusion criteria for application review groups. In the context of admissions processing, these rules allow administrators to fine-tune which specific applications, based on attributes like postal codes or country, are assigned to a particular review group for evaluation. The table's status as "Not implemented in this database" in the provided metadata indicates it may be a legacy object from a reference data model or an earlier version, and its active use in a given EBS 12.1.1 or 12.2.2 instance should be verified.

Key Information Stored

The table centrally manages the definition of each inclusion/exclusion rule. Its primary key, REVGR_INCL_EXCL_ID, uniquely identifies each rule. The core data elements define the rule's scope and the values it acts upon. As per the description, these include a Start Value and End Value, which likely define a range (e.g., for applicant IDs or scores). It also stores geographic criteria through Country, Postal Start Value, and Postal End Value fields, enabling rules based on location. A critical foreign key column, APPL_REVPROF_REVGR_ID, links each rule to its parent application review profile review group in the IGS_AD_APL_RPRF_RGR table, establishing which group the rule governs.

Common Use Cases and Queries

The primary use case is configuring the automated assignment of applications to review queues or committees. For instance, an exclusion rule could be created to route all applications from a specific country (e.g., Country = 'US', Postal Start = '10000', Postal End = '19999') away from a general review group and toward a specialized one. Common queries would involve auditing these rules or troubleshooting application routing. A sample SQL to list all rules for a specific review group would be:

  • SELECT inc_exc.* FROM igs_ad_rvgr_inc_exc inc_exc WHERE inc_exc.appl_revprof_revgr_id = &REVIEW_GROUP_ID ORDER BY country, start_value;

Reporting use cases include analyzing the distribution of review workloads based on geographic or other defined criteria stored in this table.

Related Objects

The table has a documented, direct relationship with one other object in the Student System schema, as defined by its foreign key constraint.

  • IGS_AD_APL_RPRF_RGR (Table): This is the parent table referenced by IGS_AD_RVGR_INC_EXC. The relationship is maintained through the column IGS_AD_RVGR_INC_EXC.APPL_REVPROF_REVGR_ID, which must correspond to a valid primary key value in the IGS_AD_APL_RPRF_RGR table. This link ensures that every inclusion/exclusion rule is associated with a valid application review profile review group.