Search Results igs_ad_appl_eval_pk

Overview

The IGS_AD_APPL_EVAL table is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It functions as the central repository for managing the assignment and evaluation results of personnel tasked with reviewing and scoring student applications. The table's primary role is to maintain the relationship between an application, the assigned evaluator, and the qualitative or quantitative ratings they provide. This data is fundamental to the admissions workflow, enabling structured evaluation processes, tracking reviewer assignments, and consolidating assessment outcomes for decision-making.

Key Information Stored

The table stores the linkage between an application instance and its evaluators. The primary identifier is the APPL_EVAL_ID. Critical foreign key columns define its relationships: PERSON_ID, ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD, and SEQUENCE_NUMBER together link to a specific application record in IGS_AD_PS_APPL_INST_ALL. The EVALUATOR_ID column references the HZ_PARTIES table to identify the individual performing the evaluation. For storing assessment results, the table uses RATING_TYPE_ID (linking to IGS_AD_CODE_CLASSES for the rating category), RATING_SCALE_ID (linking to IGS_AD_RATING_SCALES for the defined scale), and RATING_VALUES_ID (linking to IGS_AD_RS_VALUES for the specific score or value selected from the scale).

Common Use Cases and Queries

A primary use case is generating reports on evaluator workload and application status. Administrators may query to find all applications assigned to a specific evaluator or to identify applications awaiting evaluation. Another critical scenario is compiling evaluation summaries for an admissions committee, which involves aggregating ratings from multiple evaluators per application. Common SQL patterns include joining to application and party details to produce readable reports.

• Listing all evaluators and their assigned applications: SELECT a.evaluator_id, p.party_name, i.* FROM igs_ad_appl_eval a JOIN igs_ad_ps_appl_inst_all i ON a.person_id=i.person_id AND a.admission_appl_number=i.admission_appl_number JOIN hz_parties p ON a.evaluator_id = p.party_id;
• Finding the average rating for a specific application: SELECT AVG(rv.numeric_value) FROM igs_ad_appl_eval a JOIN igs_ad_rs_values rv ON a.rating_values_id = rv.rating_values_id WHERE a.admission_appl_number = 1001;

Related Objects

The IGS_AD_APPL_EVAL table is centrally connected to several key objects via documented foreign key relationships, primarily serving as the child table.

• IGS_AD_PS_APPL_INST_ALL: The primary parent table. The join is on the composite key (PERSON_ID, ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD, SEQUENCE_NUMBER). This links the evaluation to the specific application instance.
• HZ_PARTIES: Links via EVALUATOR_ID to identify the person or entity acting as the evaluator.
• IGS_AD_CODE_CLASSES: Links via RATING_TYPE_ID to classify the type of rating being recorded.
• IGS_AD_RATING_SCALES: Links via RATING_SCALE_ID to reference the master definition of the evaluation scale used.
• IGS_AD_RS_VALUES: Links via RATING_VALUES_ID to the specific score or value assigned from the referenced rating scale.