Search Results igs_ad_apl_rprf_rgr




Overview
Explore in AI Chat

Overview

The IGS_AD_APL_RPRF_RGR table is a core data structure within the Oracle E-Business Suite (EBS) Student System (IGS) module, versions 12.1.1 and 12.2.2. It serves as the master repository for Application Review Group definitions. This table is central to the application review and evaluation workflow, where institutions define logical groups of evaluators or review criteria to assess student applications. Its primary role is to generate unique Application Review Group IDs and store the associated metadata that defines each group, linking them to a specific Application Review Profile.

Key Information Stored

While the full column list is not provided in the metadata, the documented primary and unique keys, along with the description, identify the critical data elements. The table stores the system-generated surrogate key, APPL_REVPROF_REVGR_ID, which uniquely identifies each review group record. It also holds the business key, consisting of the REVIEW_GROUP_CD (a code for the group) and the APPL_REV_PROFILE_ID (linking to the parent review profile), which together must be unique as enforced by the IGS_AD_APL_RPRF_RGR_UK constraint. The REVIEW_GROUP_NAME is stored as a descriptive label. The APPL_REV_PROFILE_ID is a foreign key column that establishes the group's membership within a specific application review profile.

Common Use Cases and Queries

This table is primarily accessed during the setup and execution of application review processes. Administrators use it to create and maintain review groups. Common operational queries include listing all groups for a specific review profile or retrieving a group's details for assignment. A typical reporting query might join this table with the profile and application tables to analyze review workload distribution.

  • Setup Validation: SELECT revprof_revgr_cd, review_group_name FROM igs.igs_ad_apl_rprf_rgr WHERE appl_rev_profile_id = :profile_id ORDER BY 1;
  • Relationship Analysis: SELECT p.profile_name, r.revprof_revgr_cd, r.review_group_name FROM igs.igs_ad_apl_rev_prf_all p, igs.igs_ad_apl_rprf_rgr r WHERE p.appl_rev_profile_id = r.appl_rev_profile_id;

Related Objects

The IGS_AD_APL_RPRF_RGR table sits at the center of a key data model, with defined relationships to several other entities in the Student System.

  • Parent Reference: The table references IGS_AD_APL_REV_PRF_ALL via the foreign key column APPL_REV_PROFILE_ID. This links each review group to its parent Application Review Profile.
  • Child References: The table is referenced as a parent by several other tables using its primary key (APPL_REVPROF_REVGR_ID):
    • IGS_AD_APPL_ARP: Links individual applications to a specific review group for evaluation.
    • IGS_AD_RVGR_INC_EXC: Stores inclusion or exclusion rules (likely for reviewers or criteria) associated with the review group.
    • IGS_AD_RVGR_EVALTR: Associates evaluators or evaluation criteria with the review group.