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.
  • Table: IGS_AD_RVGR_INC_EXC 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AD_RVGR_INC_EXC,  object_name:IGS_AD_RVGR_INC_EXC,  status:VALID,  product: IGS - Student System ,  description: Table to record all Application Review Group Include Exclude related information. Here the Review Group Include Exclude Indicator IDs will be generated and information like Start Value, End Value, Country, Postal Start value, Postal End Val ,  implementation_dba_data: IGS.IGS_AD_RVGR_INC_EXC , 

  • View: IGS_AD_RVGR_INC_EXC_ALPHA_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_AD_RVGR_INC_EXC_ALPHA_V,  object_name:IGS_AD_RVGR_INC_EXC_ALPHA_V,  status:VALID,  product: IGS - Student System ,  description: View where all Application Review Group Include Exclude related information will be recorded for Alphabetical by surname review profile group. ,  implementation_dba_data: APPS.IGS_AD_RVGR_INC_EXC_ALPHA_V , 

  • View: IGS_AD_RVGR_INC_EXC_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_AD_RVGR_INC_EXC_V,  object_name:IGS_AD_RVGR_INC_EXC_V,  status:VALID,  product: IGS - Student System ,  description: View where all Application Review Group Include Exclude related information will be recorded. ,  implementation_dba_data: APPS.IGS_AD_RVGR_INC_EXC_V , 

  • View: IGSFV_APPL_REVIEW_GROUP_DETAIL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_APPL_REVIEW_GROUP_DETAIL,  object_name:IGSFV_APPL_REVIEW_GROUP_DETAIL,  status:VALID,  product: IGS - Student System ,  implementation_dba_data: APPS.IGSFV_APPL_REVIEW_GROUP_DETAIL , 

  • View: IGSBV_APPL_REVIEW_GROUP_DETAIL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSBV_APPL_REVIEW_GROUP_DETAIL,  object_name:IGSBV_APPL_REVIEW_GROUP_DETAIL,  status:VALID,  product: IGS - Student System ,  implementation_dba_data: APPS.IGSBV_APPL_REVIEW_GROUP_DETAIL , 

  • View: IGS_AD_RVGR_PROG_CD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_AD_RVGR_PROG_CD_V,  object_name:IGS_AD_RVGR_PROG_CD_V,  status:VALID,  product: IGS - Student System ,  description: View where all Application Review Group Include Exclude related information will be recorded for Program Of Study review profile group. ,  implementation_dba_data: APPS.IGS_AD_RVGR_PROG_CD_V , 

  • View: IGS_AD_RVGR_INC_EXC_ORG_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_AD_RVGR_INC_EXC_ORG_V,  object_name:IGS_AD_RVGR_INC_EXC_ORG_V,  status:VALID,  product: IGS - Student System ,  description: View where all Application Review Group Include Exclude related information will be recorded for Organization review profile group. ,  implementation_dba_data: APPS.IGS_AD_RVGR_INC_EXC_ORG_V , 

  • Table: IGS_AD_APL_RPRF_RGR 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AD_APL_RPRF_RGR,  object_name:IGS_AD_APL_RPRF_RGR,  status:VALID,  product: IGS - Student System ,  description: Table where the Application Review Group Code related information will be recorded. Here the Application Review Group IDs will be generated and information like Review Group Code, Review Group Name will be stored. This is not expected to b ,  implementation_dba_data: IGS.IGS_AD_APL_RPRF_RGR ,