Results for “revprof_revgr_cd”

26 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_AD_APL_RPRF_RGR is a transactional table in the Oracle EBS IGS (Student System) product family. Per ETRM metadata it is documented as obsolete and is not implemented in the reference 12.1.1 database. The table stores information related to Application Review Group Codes. Rows in this table are created when application review group identifiers are generated, and each row holds attributes such as the review group code and review group name for a given application review profile. In functional terms, the table acts as the child that links an application review profile to the review groups configured against it, and it serves as the parent for the evaluator, include/exclude, and application-level review group assignments.

The ETRM metadata describes the primary key as IGS_AD_APL_RPRF_RGR_PK, defined on the column APPL_REVPROF_REVGR_ID. A unique index, IGS_AD_APL_RPRF_RGR_UK (also documented as IGS_AD_APL_RPRF_RGR_U1), is defined on REVPROF_REVGR_CD together with APPL_REV_PROFILE_ID. The heuristic Data Vault classification derived from the foreign key structure is hub-leaning. As a modeling suggestion, this indicates the table behaves largely as a hub of the APPL_REVPROF_REVGR_ID business key, with the profile relationship acting as a link to IGS_AD_APL_REV_PRF_ALL and with descriptive attributes such as code and name serving as satellite-style content. The documented physical schema contains 9 columns under owner IGS.

Key Information Stored

The most significant columns documented for this table are:

  • APPL_REVPROF_REVGR_ID — the surrogate primary key (IGS_AD_APL_RPRF_RGR_PK) and the column referenced by all child foreign keys. It uniquely identifies an application review profile review group assignment.
  • APPL_REV_PROFILE_ID — foreign key to IGS_AD_APL_REV_PRF_ALL; identifies the application review profile to which the review group belongs.
  • REVPROF_REVGR_CD — the review group code. Together with APPL_REV_PROFILE_ID it forms the documented unique business key (IGS_AD_APL_RPRF_RGR_UK / U1), preventing duplicate review group codes within a profile.
  • REVPROF_REVGR_NAME — the descriptive name of the review group.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS WHO columns capturing audit and concurrency information.

The distinction between the surrogate key and the business key is important: APPL_REVPROF_REVGR_ID is generated by the application and is used for referential integrity, while REVPROF_REVGR_CD plus APPL_REV_PROFILE_ID represent the natural identifier visible to end users.

Common Use Cases and Queries

Typical reporting and integration scenarios resolve review group configuration against application review profiles and downstream evaluation assignments.

  • Listing all review groups for a given application review profile:
SELECT r.APPL_REVPROF_REVGR_ID,
       r.REVPROF_REVGR_CD,
       r.REVPROF_REVGR_NAME
  FROM IGS_AD_APL_RPRF_RGR r
 WHERE r.APPL_REV_PROFILE_ID = :profile_id;
  • Joining to the profile header to obtain profile context:
SELECT p.APPL_REV_PROFILE_ID,
       r.REVPROF_REVGR_CD,
       r.REVPROF_REVGR_NAME
  FROM IGS_AD_APL_RPRF_RGR r,
       IGS_AD_APL_REV_PRF_ALL p
 WHERE r.APPL_REV_PROFILE_ID = p.APPL_REV_PROFILE_ID;
  • Locating a review group by its business key:
SELECT APPL_REVPROF_REVGR_ID
  FROM IGS_AD_APL_RPRF_RGR
 WHERE APPL_REV_PROFILE_ID = :profile_id
   AND REVPROF_REVGR_CD = :rg_code;

Related Objects

The table participates in a defined set of parent and child relationships:

  • IGS_AD_APL_REV_PRF_ALL — parent table joined on IGS_AD_APL_RPRF_RGR.APPL_REV_PROFILE_ID. Provides the application review profile header.
  • IGS_AD_APPL_ARP — child table referencing APPL_REVPROF_REVGR_ID; stores application-level review group assignments.
  • IGS_AD_RVGR_INC_EXC — child table referencing APPL_REVPROF_REVGR_ID; stores include/exclude rules per review group.
  • IGS_AD_RVGR_EVALTR — child table referencing APPL_REVPROF_REVGR_ID; stores evaluator assignments per review group.

Because the object is not implemented in the reference database and is flagged obsolete in ETRM, joins against these related tables should be validated against the target environment before use in production reporting.