Search Results revgr_evaluator_id




Overview
Explore in AI Chat

Overview

The IGS_AD_RVGR_EVALTR table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Admissions (IGS) module. It functions as the master repository for storing information about evaluators assigned to application review groups. The table's primary role is to manage the assignment of specific individuals (evaluators) to review groups defined within an Application Review Profile, which governs the evaluation process for applications. It is designed as a 'CLASS3' table, indicating it is not subject to high-volume transactional updates but is critical for configuration and operational data. The system uses this table to generate unique Review Group Evaluator IDs and to maintain the relationship between evaluators, their review groups, and the sequence or concurrency of their evaluations.

Key Information Stored

The table's columns capture the essential attributes for managing review group evaluators. The primary identifier, REVGR_EVALUATOR_ID, is a system-generated unique key. The APPL_REVPROF_REVGR_ID foreign key links the evaluator to a specific review group within a review profile. The evaluator's identity is stored via both PERSON_ID (linking to the HZ_PARTIES table) and PERSON_NUMBER. Critical business logic is controlled by the EVALUATION_SEQUENCE column, which dictates the order for sequential evaluations and is null for concurrent processes, and the PROGRAM_APPROVER_IND flag ('Y'/'N'), which designates if the evaluator also holds program approval authority. Standard WHO columns (CREATED_BY, CREATION_DATE, etc.) are present for auditing.

Common Use Cases and Queries

This table is central to configuring and reporting on the application evaluation workflow. Common operational scenarios include assigning staff to review groups, determining the evaluation order for sequential reviews, and identifying which evaluators are authorized for final program approval. A typical query to list all evaluators for a specific review group, including their sequence and approval authority, would be:

  • SELECT revgr_evaluator_id, person_number, evaluation_sequence, program_approver_ind FROM igs.igs_ad_rvgr_evaltr WHERE appl_revprof_revgr_id = :rev_group_id ORDER BY evaluation_sequence;

For integration or data validation, a join to the parties table is frequently used to get the evaluator's full name: SELECT eval.person_number, party.party_name, eval.evaluation_sequence FROM igs.igs_ad_rvgr_evaltr eval, hz_parties party WHERE eval.person_id = party.party_id AND eval.appl_revprof_revgr_id = :rev_group_id;

Related Objects

The IGS_AD_RVGR_EVALTR table maintains defined relationships with other key EBS entities. Its primary key is enforced by the unique index IGS_AD_RVGR_EVALTR_PK on the REVGR_EVALUATOR_ID column. It references two primary parent tables via foreign key constraints:

  • HZ_PARTIES: The PERSON_ID column references HZ_PARTIES.PARTY_ID, linking the evaluator record to the Trading Community Architecture's master person/party definition.
  • IGS_AD_APL_RPRF_RGR: The APPL_REVPROF_REVGR_ID column references the IGS_AD_APL_RPRF_RGR table, which defines the review groups within an Application Review Profile. This establishes the evaluator's assignment to a specific group.

These relationships ensure referential integrity and are critical for any joins performed in custom reports, interfaces, or extensions involving the application evaluation process.