Search Results igs_ad_rating_scales




Overview
Explore in AI Chat

Overview

The IGS_AD_RATING_SCALES table is a core data object within the Oracle E-Business Suite Student System (IGS) module, specifically supporting the Admissions functionality. Its primary role is to serve as the master repository for predefined rating scales used by application evaluators during the admissions process. These standardized scales provide a consistent framework for assessing and scoring applicant qualifications, interview performance, or other evaluation criteria, ensuring objective and comparable ratings across different applications and evaluators. The table is fundamental to the structured evaluation workflows in Oracle EBS Releases 12.1.1 and 12.2.2.

Key Information Stored

While the provided metadata does not list individual columns, the table's structure is defined by its primary and foreign key relationships. The central column is RATING_SCALE_ID, which serves as the unique identifier (primary key) for each distinct rating scale record. Based on its described purpose, the table likely stores descriptive attributes for each scale, such as a scale name, description, status (active/inactive), and potentially the scale type (e.g., numeric, descriptive). The actual discrete values or labels that constitute the scale (e.g., "1 - Poor", "2 - Fair", "3 - Good") are stored in the related child table, IGS_AD_RS_VALUES, which references this master table via the RATING_SCALE_ID foreign key.

Common Use Cases and Queries

This table is central to configuring and executing application reviews. Common operational and reporting scenarios include setting up evaluation criteria for an admission process category, allowing evaluators to select a rating from a dropdown list when scoring an application, and generating reports on average applicant ratings. Administrators may query this table to manage active scales. Sample SQL patterns include retrieving all scales for setup purposes or joining to evaluation records for analysis.

  • Setup and Maintenance: Querying all active rating scales to assign one to a specific admissions process or evaluation category.
  • Evaluation Data Integrity: Joining IGS_AD_APPL_EVAL to IGS_AD_RATING_SCALES to validate that all evaluations use a currently valid scale.
  • Reporting and Analytics: Aggregating evaluation scores by linking application evaluations through IGS_AD_APPL_EVAL to the master scale definition for consistent reporting labels.

Related Objects

The IGS_AD_RATING_SCALES table has several key dependencies within the Admissions module, as documented by its foreign key relationships. It is referenced as a parent table by the following objects:

  • IGS_AD_APPL_EVAL: Links individual application evaluation records to a specific rating scale via the RATING_SCALE_ID column.
  • IGS_AD_PRCS_CAT_ALL: Associates an admission process category with a default rating scale for evaluations via the RATING_SCALE_ID column.
  • IGS_AD_APL_RVPF_RSL: References the rating scale, likely for results or rules related to application review profiles, via the RATING_SCALE_ID column.
  • IGS_AD_RS_VALUES: The critical child table that stores the individual permissible values (e.g., "Excellent", "Good", "Average") for each master rating scale, linked by RATING_SCALE_ID.