Search Results igs_ad_appl_arp_n1

Overview

The IGS_AD_APPL_ARP table is a core transactional data store within the Oracle E-Business Suite (EBS) Admissions (IGS) module, specifically for releases 12.1.1 and 12.2.2. It functions as the central repository for linking an applicant's specific course application instance to configured Application Review Profiles and their associated Review Groups. The table's primary role is to manage the workflow and assignment of reviews during the admissions process, recording which review criteria and reviewer groups are applicable to each submitted application. As documented, it is classified as a 'high transaction' table, indicating it is subject to frequent inserts and updates during active admission cycles.

Key Information Stored

The table stores the relationship between an application and its review configuration. The key columns include the unique identifier APPL_ARP_ID, which serves as the primary key. The table links to the applicant and their specific application via PERSON_ID, ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD, and SEQUENCE_NUMBER. The core functional links are established through APPL_REV_PROFILE_ID, which references the master review profile, and APPL_REVPROF_REVGR_ID, which references the specific review group assigned. Standard EBS Concurrent Program tracking columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID) are also present to audit system-generated changes.

Common Use Cases and Queries

This table is central to admissions review operations. Common use cases include generating lists of applications assigned to a particular reviewer or review group, auditing the review profile assignment history for an application, and supporting reports on review workflow status. A typical query would join this table to application and person details to see the review setup for specific applicants.

• Finding Review Assignments for an Application: SELECT arp.* FROM igs.igs_ad_appl_arp arp WHERE arp.person_id = :p_person_id AND arp.admission_appl_number = :p_app_number;
• Listing Applications for a Review Group: SELECT a.person_id, a.admission_appl_number FROM igs.igs_ad_appl_arp a WHERE a.appl_revprof_revgr_id = :p_review_group_id;
• Auditing Profile Usage: Reports often aggregate data from this table by APPL_REV_PROFILE_ID to count how many applications are using each configured review profile.

Related Objects

The IGS_AD_APPL_ARP table is a junction point within the Admissions schema, maintaining critical foreign key relationships to master and transactional tables.

• Primary Key: IGS_AD_APPL_ARP_PK on the APPL_ARP_ID column.
• Foreign Keys (References):
  • APPL_REV_PROFILE_ID references IGS_AD_APL_REV_PRF_ALL (Application Review Profile master).
  • APPL_REVPROF_REVGR_ID references IGS_AD_APL_RPRF_RGR (Application Review Profile Review Group).
  • PERSON_ID, ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD, SEQUENCE_NUMBER collectively reference IGS_AD_PS_APPL_INST_ALL (the detailed admission application instance).

The defined indexes, particularly IGS_AD_APPL_ARP_N1 through N3, are optimized for queries filtering on the foreign key columns and the composite application identifier, supporting the high-transaction nature of this table.