Results for “igs_ad_apl_rev_prf_v”

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

Overview

IGS_AD_APL_REV_PRF_V is a VALID database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the IGS (Student System) product family. It exposes the master definition data for Application Review Profiles — the configuration records that govern how admissions applications are routed to evaluators and reviewers. The view consolidates the descriptive attributes of each review profile, including its name, effective period, evaluator headcount limits, program approval requirements, evaluation sequencing rules, and review profile grouping, into a single queryable surface suitable for reporting, forms, and integration logic.

In the admissions workflow, a review profile determines the operational behavior applied when an application enters the evaluation stage. Because these settings are reference data referenced by transactional admissions records, the view serves as a stable join point for reports that must resolve a profile identifier to a human-readable name, an active date window, or a behavioral flag. It is available in both EBS 12.1.1 and 12.2.2, with the same column set documented in ETRM 12.2.2.

Underlying Base Objects

The ETRM metadata documents a single referenced base object for this view: the table IGS_AD_APL_REV_PRF. The view is defined as a direct projection over that table, aliased RP, with no joins to other base tables. All primary columns are passed through unchanged from the underlying profile table, and the profile identifier APPL_REV_PROFILE_ID originates from the base table where those IDs are generated.

Two correlated scalar subqueries enrich the output. The first resolves APPL_REV_PROFILE_GR_CD against IGS_LOOKUP_VALUES for lookup type IGS_APPL_REVIEW_PROFILE_GROUP, and the second conditionally resolves SITE_USE_CODE against FND_LOOKUP_VALUES for lookup type PARTY_SITE_USE_CODE, restricted to VIEW_APPLICATION_ID 222, SECURITY_GROUP_ID 0, and the session language. Consequently, while only one base table is documented, the view functionally depends on the IGS and FND lookup value views, and translated values follow the runtime language environment.

Key Columns

• APPL_REV_PROFILE_ID — Primary identifier for the Application Review Profile; the key used by downstream admissions evaluations.
• REVIEW_PROFILE_NAME — User-facing name of the profile.
• START_DATE / END_DATE — Effective window during which the profile may be applied.
• MIN_EVALUATOR / MAX_EVALUATOR — Bounds on the number of evaluators assigned under the profile.
• PROG_APPROVAL_REQUIRED — Flag indicating whether program-level approval is mandatory.
• SEQUENTIAL_CONCURRENT_IND — Indicates whether evaluations proceed sequentially or concurrently.
• APPL_REV_PROFILE_GR_CD / ARP_GR_CODE_MEANING — Lookup code for the profile group and its resolved meaning via IGS_LOOKUP_VALUES.
• SITE_USE_CODE / SITE_USE_CODE_MEANING — Party site use classification and its resolved meaning (NULL when the code is NULL).
• CLOSED_IND — Indicates whether the profile is closed to further use.
• ROW_ID, ORG_ID — Surrogate row identifier and operating unit context.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns.

Common Use Cases and Queries

Typical uses include validating which review profiles are currently active, listing evaluator capacity limits, auditing closed profiles, and driving admissions configuration reports. The following query returns all open profiles effective on a given date with decoded group meanings:

• SELECT appl_rev_profile_id, review_profile_name, start_date, end_date, min_evaluator, max_evaluator, prost_approval_required, arp_gr_code_meaning FROM igs_ad_apl_rev_prf_v WHERE closed_ind = 'N' AND TRUNC(SYSDATE) BETWEEN start_date AND NVL(end_date, TRUNC(SYSDATE)) ORDER BY review_profile_name;
• SELECT review_profile_name, prog_approval_required, sequential_concurrent_ind, site_use_code_meaning FROM igs_ad_apl_rev_prf_v WHERE org_id = :p_org_id ORDER BY creation_date DESC; (note: replace the substituted prost_approval_required token with the actual column name PROG_APPROVAL_REQUIRED.)

Because the lookup meanings are externalized and language-sensitive, reports should join or read the meaning columns rather than hard-coding code values. As the view performs no aggregation, it can be freely joined to application, evaluation, and program tables on APPL_REV_PROFILE_ID.