Search Results appl_rev_profile_id




Overview
Explore in AI Chat

Overview

The IGS_AD_APL_RVPF_RSL table is a core data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Admissions (IGS) module. It functions as a junction table that stores the association between Application Review Profiles and the rating scales used to evaluate applicants. Its primary role is to define and persist the specific rating criteria—comprising both a rating type and a corresponding scale—that reviewers must apply when assessing an application within a given review profile. As per its storage classification, it is not a high-transaction table, indicating its data is relatively static once configured for a review process.

Key Information Stored

The table's structure centers on key identifiers that link critical components of the application review workflow. The primary columns and their purposes are:

Common Use Cases and Queries

This table is central to configuring and auditing the review process. A common operational use case involves querying all rating scales assigned to a specific Application Review Profile to validate setup or to generate review guidelines. For reporting, it is frequently joined to lookup tables to produce human-readable descriptions of the rating criteria. A sample query to retrieve the complete rating configuration for a profile would be:

SELECT arpr.APPL_REV_PROFILE_ID, arpr.RATING_TYPE_ID, rt.MEANING RATING_TYPE, arpr.RATING_SCALE_ID, rs.MEANING RATING_SCALE
FROM IGS.IGS_AD_APL_RVPF_RSL arpr,
     FND_LOOKUP_VALUES rt,
     FND_LOOKUP_VALUES rs
WHERE arpr.APPL_REV_PROFILE_ID = :PROFILE_ID
  AND rt.LOOKUP_TYPE = 'IGS_AD_RATING_TYPE'
  AND rt.LOOKUP_CODE = arpr.RATING_TYPE_ID
  AND rs.LOOKUP_TYPE = 'IGS_AD_RATING_SCALE'
  AND rs.LOOKUP_CODE = arpr.RATING_SCALE_ID;

Another critical pattern is finding all review profiles that utilize a specific RATING_TYPE_ID, which is essential for impact analysis before modifying a rating type definition.

Related Objects

Based on the provided metadata, the IGS_AD_APL_RVPF_RSL table is referenced by objects within the APPS schema. While specific foreign key relationships to parent tables are not explicitly detailed in the excerpt, logical relationships can be inferred from the column definitions. The table's design indicates it is a child table to at least three key entities:

  • Application Review Profile Table: Likely named IGS_AD_APL_REV_PROF or similar, via the APPL_REV_PROFILE_ID column.
  • Rating Type Lookup: The RATING_TYPE_ID references a code from a lookup (e.g., FND_LOOKUP_VALUES with LOOKUP_TYPE='IGS_AD_RATING_TYPE') or a dedicated ratings table.
  • Rating Scale Lookup: Similarly, RATING_SCALE_ID references a code from a related lookup (e.g., FND_LOOKUP_VALUES with LOOKUP_TYPE='IGS_AD_RATING_SCALE').

The unique index (IGS_AD_APL_RVPF_RSL_U1) on APPL_REVPROF_RTSCALE_ID enforces the primary key, while the non-unique index (IGS_AD_APL_RVPF_RSL_U2) on APPL_REV_PROFILE_ID, RATING_TYPE_ID, and RATING_SCALE_ID supports efficient queries and likely enforces a business rule preventing duplicate rating type assignments within a single profile.