Search Results appl_rev_profile_id




Overview
Explore in AI Chat

Overview

The IGS_AD_APL_RPRF_RGR table is a core data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Oracle Student Management) module. It functions as the master table for storing Application Review Group definitions. Each record represents a distinct review group, which is a logical collection of reviewers or evaluation criteria used in the assessment of student applications. The table is classified as a 'CLASS3' table, indicating it is not expected to be a high-transaction volume entity but rather a reference table for configuration data. Its primary role is to establish and maintain the groups that facilitate the structured review process within the admissions lifecycle.

Key Information Stored

The table's structure is designed to uniquely identify and describe each review group within the context of a broader Application Review Profile. The key columns include:

  • APPL_REVPROF_REVGR_ID (NUMBER 15): The primary key and unique system-generated identifier for a review group record.
  • APPL_REV_PROFILE_ID (NUMBER 15): A mandatory foreign key linking the group to its parent Application Review Profile (IGS_AD_APL_REV_PRF_ALL). This defines the profile under which this group is active.
  • REVPROF_REVGR_CD (VARCHAR2 30): The unique code for the review group, used for identification and reporting.
  • REVPROF_REVGR_NAME (VARCHAR2 80): The descriptive name of the review group.
  • Standard WHO Columns (CREATED_BY, CREATION_DATE, etc.): Audit columns tracking the record's creation and last update details.

The unique constraint IGS_AD_APL_RPRF_RGR_U2 on APPL_REV_PROFILE_ID and REVPROF_REVGR_CD ensures that group codes are unique within a given review profile.

Common Use Cases and Queries

This table is central to configuring and querying the application review workflow. Common operational and reporting scenarios include listing all review groups for a specific profile, troubleshooting application routing, and auditing setup data. A fundamental query to retrieve all groups for a known Application Review Profile ID (the user's search parameter, `appl_rev_profile_id`) is:

SELECT REVPROF_REVGR_CD, REVPROF_REVGR_NAME, CREATION_DATE, LAST_UPDATED_BY
FROM IGS.IGS_AD_APL_RPRF_RGR
WHERE APPL_REV_PROFILE_ID = :p_profile_id
ORDER BY REVPROF_REVGR_CD;

For integration or data migration purposes, a complete extract of the table's core data can be performed using the documented query pattern:
SELECT APPL_REVPROF_REVGR_ID, APPL_REV_PROFILE_ID, REVPROF_REVGR_CD, REVPROF_REVGR_NAME, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN FROM IGS.IGS_AD_APL_RPRF_RGR;

Related Objects

The IGS_AD_APL_RPRF_RGR table sits at the center of a key relationship hierarchy within the Admissions module, as defined by its foreign key constraints:

  • Parent Reference: The table references IGS_AD_APL_REV_PRF_ALL via the APPL_REV_PROFILE_ID column, linking each group to its controlling review profile.
  • Child References: The table's primary key (APPL_REVPROF_REVGR_ID) is referenced by several other tables, defining its critical role in the application review process:
    • IGS_AD_APPL_ARP: Links individual applications to a specific review group for assessment.
    • IGS_AD_RVGR_INC_EXC: Likely stores inclusion or exclusion rules for members or items within a review group.
    • IGS_AD_RVGR_EVALTR: Likely associates evaluators or evaluation criteria with a specific review group.

These relationships confirm that IGS_AD_APL_RPRF_RGR is a configuration master table, whose identifiers are used to associate applications, rules, and reviewers throughout the operational review process.