Search Results igs_ad_apl_rvpf_rsl




Overview
Explore in AI Chat

Overview

The table IGS_AD_APL_RVPF_RSL is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS), specifically designed for the admissions process. As indicated by its description, this table serves as a repository for all rating scale information associated with an Application Review Profile. An Application Review Profile defines the criteria and workflow for evaluating a student's application. This table, therefore, establishes the specific rating types (e.g., academic merit, interview score) and the corresponding scales (e.g., 1-5, A-F) that reviewers must use when assessing applications under a given profile. Its role is to enforce standardized, quantifiable evaluation metrics within the admissions review cycle. It is critical to note that the IGS module is marked as "Obsolete" in the provided ETRM, indicating it is a legacy component that may be subject to de-support or replacement in future EBS releases.

Key Information Stored

The table's structure is defined by its primary and foreign key relationships, which highlight the critical data points it stores. The primary business key is a composite of APPL_REV_PROFILE_ID, RATING_TYPE_ID, and RATING_SCALE_ID, ensuring a unique combination of review profile, rating category, and scale. A surrogate primary key, APPL_REVPROF_RTSCALE_ID, is also present for internal system use. The essential columns are:

  • APPL_REV_PROFILE_ID: Foreign key linking to the parent Application Review Profile (IGS_AD_APL_REV_PRF_ALL).
  • RATING_TYPE_ID: Foreign key identifying the category or type of rating being applied (e.g., from IGS_AD_CODE_CLASSES).
  • RATING_SCALE_ID: Foreign key defining the specific scale of values permissible for this rating type within the profile (e.g., from IGS_AD_RATING_SCALES).

Together, these columns create a rule set dictating how different aspects of an application are to be scored during the review process.

Common Use Cases and Queries

This table is central to configuring and auditing the application review workflow. A primary use case is the setup of a new review profile, where an administrator would insert records into this table to define the scoring matrix for that profile. For reporting, it is frequently joined to its parent tables to generate documentation of review criteria or to validate data integrity. A common diagnostic query would verify all rating scales assigned to a specific profile:

SELECT prf.profile_name, cc.meaning rating_type, rs.scale_code
FROM igs_ad_apl_rvpf_rsl rsl,
igs_ad_apl_rev_prf_all prf,
igs_ad_code_classes cc,
igs_ad_rating_scales rs
WHERE rsl.appl_rev_profile_id = prf.appl_rev_profile_id
AND rsl.rating_type_id = cc.code_id
AND rsl.rating_scale_id = rs.rating_scale_id
AND prf.appl_rev_profile_id = :profile_id;

Another critical use case involves data validation during the application review itself, where the system would reference this table to ensure a reviewer's input conforms to the allowed rating type and scale.

Related Objects

IGS_AD_APL_RVPF_RSL is a child table with defined foreign key dependencies to three key master tables in the Student System, as documented in the ETRM:

  • IGS_AD_APL_REV_PRF_ALL: The parent Application Review Profile table. Joined via IGS_AD_APL_RVPF_RSL.APPL_REV_PROFILE_ID.
  • IGS_AD_CODE_CLASSES: A code lookup table for defining the rating type/category. Joined via IGS_AD_APL_RVPF_RSL.RATING_TYPE_ID.
  • IGS_AD_RATING_SCALES: The master table defining available rating scales (e.g., numeric ranges, letter grades). Joined via IGS_AD_APL_RVPF_RSL.RATING_SCALE_ID.

These relationships are fundamental; any reporting or process involving application review ratings will typically require joins to these tables to resolve ID values into meaningful descriptions. The table itself may be referenced by application review transactional data tables (not listed in the provided excerpt) that store the actual scores assigned by reviewers.