Search Results igs_ad_apl_rev_prf_all




Overview
Explore in AI Chat

Overview

The table IGS_AD_APL_REV_PRF_ALL is a core data repository within the Oracle E-Business Suite's now-obsolete Student System (IGS). It serves as the master table for defining and storing Application Review Profiles. These profiles are configuration entities that govern the review process for student applications, acting as a template for the workflow and requirements an application must undergo. The table's role is to centrally manage the definition of these profiles, including their validity periods and key procedural flags. As an `_ALL` table, it is designed to support a multi-organization architecture (Multi-Org), storing data partitioned by the `ORG_ID` column. The documentation explicitly notes this table was "Not implemented in this database," indicating it may be a reference or legacy structure in the specified EBS versions (12.1.1 / 12.2.2).

Key Information Stored

The table's primary function is to generate and record unique Application Review Profile identifiers and their associated metadata. Based on the provided description and key structure, critical columns include:

  • APPL_REV_PROFILE_ID: The system-generated primary key (PK) uniquely identifying each review profile.
  • REVIEW_PROFILE_NAME: The descriptive name of the review profile, which, combined with `ORG_ID`, forms a unique key (UK1).
  • ORG_ID: The Multi-Org identifier, segregating data by operating unit and ensuring the uniqueness of the profile name within an organization.
  • START_DATE and END_DATE: Define the active period during which the review profile is valid for use.
  • A column (implied by the description) indicating whether program approval is required, a key business rule flag for the application review process.

Common Use Cases and Queries

This table is central to administrative setup and reporting for the application review lifecycle. Common operational scenarios include retrieving all active profiles for a given organization or identifying which profiles are linked to specific application outcomes. For reporting, one might join this table to its related child tables to analyze review workflow volumes or profile effectiveness. A typical query pattern would involve filtering by `ORG_ID` and the current date to find valid profiles:

SELECT review_profile_name, start_date, end_date
FROM igs_ad_apl_rev_prf_all
WHERE org_id = :p_org_id
AND SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE);

Another critical use case is data validation, ensuring that applications (`IGS_AD_APPL_ARP`) are associated with a valid, existing `APPL_REV_PROFILE_ID` from this master table.

Related Objects

The IGS_AD_APL_REV_PRF_ALL table is a parent entity with several documented foreign key relationships. The primary key `APPL_REV_PROFILE_ID` is referenced by the following tables, forming the structural backbone of the review configuration:

  • IGS_AD_APPL_ARP: Links via `APPL_REV_PROFILE_ID`. This likely associates individual student applications to a specific review profile.
  • IGS_AD_APL_RPRF_RGR: Links via `APPL_REV_PROFILE_ID`. This table probably defines the review groups or reviewers assigned to a profile.
  • IGS_AD_APL_RVPF_RSL: Links via `APPL_REV_PROFILE_ID`. This table is expected to store the possible review results or outcomes defined for a profile.

These relationships indicate that the profile acts as a central hub, controlling the assignment, process, and potential resolutions for application reviews within the system.