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;
- Enumerating evaluators or include/exclude rules attached to a review group through IGS_AD_RVGR_EVALTR and IGS_AD_RVGR_INC_EXC.
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.
-
Table where the Application Review Group Code related information will be recorded. Here the Application Review Group IDs will be generated and information like Review Group Code, Review Group Name will be stored. This is not expected to b
-
View: IGS_AD_APL_RPRF_RGR_V 12.1.1
View where the Application Review Group Code related information will be recorded.
APPS.IGS_AD_APL_RPRF_RGR_V·↳ IGS_AD_APL_RPRF_RGR·Explore IGS module →
-
View: IGS_AD_APR_RVGR_V 12.1.1
View where the Application Review Group Code related information will be recorded.
APPS.IGS_AD_APR_RVGR_V·↳ IGS_AD_APL_REV_PRF_V·↳ IGS_AD_APL_RPRF_RGR·Explore IGS module →
-
View: IGS_AD_APPL_ARP_V 12.1.1
View which contains the details of Review Profile, Review Profile Group and Application Details.
APPS.IGS_AD_APPL_ARP_V·↳ IGS_AD_APL_REV_PRF_V·↳ IGS_AD_APL_RPRF_RGR·↳ IGS_AD_APPL_ARP·Explore IGS module →
-
View: IGS_AD_APR_RVGR_V 12.2.2
View where the Application Review Group Code related information will be recorded.
Not implemented in this database·Explore IGS module →
-
VIEW: APPS.IGS_AD_APR_RVGR_V 12.1.1
-
VIEW: APPS.IGS_AD_APPL_ARP_V 12.1.1
-
View: IGS_AD_APL_RPRF_RGR_V 12.2.2
View where the Application Review Group Code related information will be recorded.
Not implemented in this database·Explore IGS module →
-
Table: IGS_AD_APL_RPRF_RGR 12.2.2
Table where the Application Review Group Code related information will be recorded. Here the Application Review Group IDs will be generated and information like Review Group Code, Review Group Name will be stored. This is not expected to b
Not implemented in this database·Explore IGS module →
-
View: IGS_AD_APPL_ARP_V 12.2.2
View which contains the details of Review Profile, Review Profile Group and Application Details.
Not implemented in this database·Explore IGS module →
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.