Search Results igs_ad_rvgr_evaltr




Overview
Explore in AI Chat

Overview

The IGS_AD_RVGR_EVALTR table is a core data object within the Oracle E-Business Suite Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It serves as the central repository for managing the association between individual evaluators and application review profiles. Its primary role is to record which specific persons (evaluators) are assigned to perform reviews for defined application review groups, thereby facilitating the structured evaluation of student applications within the admissions process. This table is essential for configuring and executing the workflow of application assessment and ensuring the correct routing of applications to qualified personnel.

Key Information Stored

The table's structure is designed to link evaluators to review groups. The most critical columns include the primary key, REVGR_EVALUATOR_ID, which uniquely identifies each evaluator-record assignment. The APPL_REVPROF_REVGR_ID is a foreign key that links the record to a specific review group defined in the IGS_AD_APL_RPRF_RGR table. The PERSON_ID column is another foreign key that identifies the actual individual assigned as the evaluator by referencing the HZ_PARTIES table, which is the central repository for all person and party information in Oracle EBS. Together, these columns define the core relationship: which person evaluates applications for which review group.

Common Use Cases and Queries

This table is primarily accessed for administrative setup and operational reporting within the admissions lifecycle. Common scenarios include generating a list of all evaluators assigned to a particular application review profile for audit or workload distribution purposes. A typical query would join IGS_AD_RVGR_EVALTR with HZ_PARTIES to retrieve evaluator names and with IGS_AD_APL_RPRF_RGR for review group context. For example, to find all evaluators for a specific review group, one might use:

  • SELECT hp.party_name, ev.* FROM igs.igs_ad_rvgr_evaltr ev, hz_parties hp WHERE ev.person_id = hp.party_id AND ev.appl_revprof_revgr_id = :revgr_id;

This data is also critical for backend processes that automatically route applications to the next available or assigned evaluator based on the configured review profile rules.

Related Objects

The IGS_AD_RVGR_EVALTR table maintains defined relationships with other key EBS tables, as documented in its foreign key constraints. It is a child table that depends on data from two primary sources:

  • HZ_PARTIES: The relationship is established via the column IGS_AD_RVGR_EVALTR.PERSON_ID, which references HZ_PARTIES. This join provides the detailed identity information (name, contact details) for the assigned evaluator.
  • IGS_AD_APL_RPRF_RGR: The relationship is established via the column IGS_AD_RVGR_EVALTR.APPL_REVPROF_REVGR_ID, which references IGS_AD_APL_RPRF_RGR. This join provides the context of the specific application review group to which the evaluator is assigned.

These relationships ensure data integrity, linking evaluators to valid parties and existing review profiles within the system.