Search Results igs_ad_appl_eval_n4

Overview

The IGS_AD_APPL_EVAL table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Admissions (IGS) module. It functions as the central repository for managing the assignment and outcomes of evaluators tasked with reviewing student admission applications. The table's primary role is to track which evaluator (person) is assigned to a specific application, record the evaluation results—including ratings and comments—and log the timeline of the assignment and evaluation process. This data is critical for automating and auditing the application review workflow, ensuring accountability, and supporting decision-making for admissions committees.

Key Information Stored

The table stores a comprehensive set of attributes for each evaluator-application assignment. Key columns include a unique system identifier (APPL_EVAL_ID) and the composite foreign key linking to a specific application instance (PERSON_ID, ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD, SEQUENCE_NUMBER). Crucially for the user's search, the EVALUATOR_ID column stores the person ID of the assigned evaluator. The table captures the method of assignment (ASSIGN_TYPE), relevant dates (ASSIGN_DATE, EVALUATION_DATE), and the evaluation results through foreign keys to rating lookup tables (RATING_TYPE_ID, RATING_VALUES_ID) and free-text comments (RATING_NOTES).

Common Use Cases and Queries

A primary use case is generating reports on evaluator workload or performance, such as listing all applications assigned to a specific evaluator. The existence of a non-unique index (IGS_AD_APPL_EVAL_N4) on the EVALUATOR_ID column alongside the application key columns indicates this is a common query pattern for performance optimization.

• Find all evaluations by a specific evaluator:
  SELECT * FROM igs.igs_ad_appl_eval WHERE evaluator_id = <person_id>;
• List pending evaluations (assigned but not completed):
  SELECT evaluator_id, person_id, admission_appl_number FROM igs.igs_ad_appl_eval WHERE evaluation_date IS NULL;
• Report on evaluation ratings and comments for an application:
  SELECT eval.evaluator_id, eval.rating_notes, eval.evaluation_date FROM igs.igs_ad_appl_eval eval WHERE eval.person_id = <applicant_id> AND eval.admission_appl_number = <app_number>;

Related Objects

The table maintains several key relationships within the Admissions schema, primarily through foreign key constraints inferred from its indexed columns. The primary key (APPL_EVAL_ID) is enforced by the IGS_AD_APPL_EVAL_PK index. The table is intricately linked to the main application entity, likely a table such as IGS_AD_APPL, via the composite columns (PERSON_ID, ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD, SEQUENCE_NUMBER). It references code lookup tables for ratings: IGS_AD_CODE_CLASSES (for RATING_TYPE_ID where code type is 'RATING_TYPE') and a presumed table for RATING_VALUES_ID. The EVALUATOR_ID and PERSON_ID columns are foreign keys to the person master table (e.g., PER_ALL_PEOPLE_F). The non-unique indexes (N1, N2, N3, N4, U2) document these relationships and optimize joins for queries involving evaluators, applications, and rating types.