Results for “igs_ad_appl_arp”

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

Overview

The IGS_AD_APPL_ARP table resides in the IGS (Student System) schema of Oracle E-Business Suite and stores Application Review Profile information associated with an admission application instance. Each row captures the review profile or review group assigned to a specific applicant application, forming the operational record that drives admissions review routing and evaluation within the Oracle Student System. The table is documented as a high-transaction object, reflecting the volume of review profile assignments generated across admissions cycles.

From a Data Vault modeling perspective, the FK structure suggests this object behaves as a link — it associates an applicant application instance with a review profile and review group, rather than acting as a standalone hub or descriptive satellite. This classification is heuristic and should be treated as a modeling suggestion rather than a documented fact.

Key Information Stored

The table contains 16 documented columns. The most significant are:

• APPL_ARP_ID — the surrogate primary key, defined by the unique index/pk constraint IGS_AD_APPL_ARP_PK. No separate business-key unique index is documented beyond this.
• PERSON_ID — the applicant identifier, part of the composite link to the application instance.
• ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD, SEQUENCE_NUMBER — together with PERSON_ID, form the composite reference to the application instance in IGS_AD_PS_APPL_INST_ALL.
• APPL_REV_PROFILE_ID — the review profile assigned to the application, referencing IGS_AD_APL_REV_PRF_ALL.
• APPL_REVPROF_REVGR_ID — the review group tied to the review profile, referencing IGS_AD_APL_RPRF_RGR.
• PROGRAM_APPLICATION_ID, PROGRAM_ID — program-level application linkage.
• REQUEST_ID — the concurrent request that created or updated the row.
• PROGRAM_UPDATE_DATE, CREATION_DATE, LAST_UPDATE_DATE — date tracking for program, creation, and last modification.
• CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard EBS WHO columns for auditability.

Common Use Cases and Queries

Typical usage includes retrieving the review profile and review group assigned to an applicant, auditing review routing, and reconciling review profile assignments by concurrent request. A representative query joins the table to the application instance:

• SELECT arp.appl_arp_id, arp.person_id, arp.admission_appl_number, arp.appl_rev_profile_id, arp.appl_revprof_revgr_id FROM igs.igs_ad_appl_arp arp WHERE arp.person_id = :person_id AND arp.admission_appl_number = :appl_number;
• Join to IGS_AD_PS_APPL_INST_ALL on PERSON_ID, ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD, SEQUENCE_NUMBER to obtain application details.
• Join to IGS_AD_APL_REV_PRF_ALL on APPL_REV_PROFILE_ID for profile descriptions, and to IGS_AD_APL_RPRF_RGR on APPL_REVPROF_REVGR_ID for review group detail.

The REQUEST_ID and WHO columns support audit and job-reconciliation reporting.

Related Objects

• IGS_AD_PS_APPL_INST_ALL — parent application instance; joined via PERSON_ID, ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD, SEQUENCE_NUMBER.
• IGS_AD_APL_REV_PRF_ALL — review profile definition; joined via APPL_REV_PROFILE_ID.
• IGS_AD_APL_RPRF_RGR — review profile/review group relationship; joined via APPL_REVPROF_REVGR_ID.
• IGS_AD_APPL_ARP_PK — the unique constraint/index on APPL_ARP_ID.