Search Results program_rank_set

Overview

The view IGSBV_AD_ADM_PS_APPL belongs to the IGS — Student System product family within Oracle E-Business Suite. It exposes admission application program information, presenting a combined, read-only picture of an applicant's admission application together with the associated party and person profile details. In the context of Oracle EBS 12.1.1 and 12.2.2, this object is documented as part of the IGS module, which is flagged as Obsolete in the ETRM repository. The view is not implemented in the reference database, meaning that it exists as documented metadata rather than as a deployed object in that instance.

The view is defined WITH READ ONLY, so it is intended purely for query, reporting, and integration consumption rather than for data maintenance. A user searching for transfer_program_code reaches this view because it exposes the column TRANSFER_PROGRAM_CODE (described as TRANSFER_PROGRAM_CODE in the view text and TRANSFER_PROGRAM_CODE in the column list), which records the program to which an applicant is transferring in the admission application context.

Underlying Base Objects

The view text defines a three-table join:

• IGS_AD_PS_APPL_ALL — the primary admission application program table, aliased APA, supplying application-level attributes such as admission application number, nominated course, transfer course, basis for admission, and rank information.
• HZ_PARTIES — aliased P, supplying the party number and joining on APA.PERSON_ID = P.PARTY_ID.
• HZ_PERSON_PROFILES — aliased PP, supplying the formatted person name and joining on P.PARTY_ID = PP.PARTY_ID.

The person profile join includes an outer-join condition (PP.CONTENT_SOURCE_TYPE (+) = 'USER_ENTERED') and a date-effective filter restricting rows to the currently effective profile (SYSDATE BETWEEN PP.EFFECTIVE_START_DATE AND NVL(PP.EFFECTIVE_END_DATE, SYSDATE)). The documented ETRM metadata records no referenced base objects explicitly, but the embedded view text supplies the above dependencies.

Key Columns

• PERSON_ID — the party identifier of the applicant, the principal join key.
• PARTY_NUMBER — the HZ party number for the applicant.
• PERSON_NAME — the formatted applicant name derived from the person profile.
• ADMISSION_APPL_NUMBER — the admission application number.
• NOMINATED_COURSE_CD — the nominated program or course code on the application.
• TRANSFER_COURSE_CD — the transfer program code, the column associated with the user's search term transfer_program_code.
• BASIS_FOR_ADMISSION_TYPE and BASIS_FOR_ADMISSION_CODE — the admission basis classification.
• COURSE_RANK_SET and COURSE_RANK_SCHEDULE — ranking set and schedule attributes for the application.
• _LA:APA.REQ_FOR_RECONSIDERATION_IND and _LA:APA.REQ_FOR_ADV_STANDING_IND — lookup-decoded indicators (YES/NO) for reconsideration and advanced standing requests, resolved through IGS_LOOKUP_VALUES.
• CREATED_BY / CREATION_DATE / LAST_UPDATED_BY / LAST_UPDATE_DATE — standard audit columns.

Common Use Cases and Queries

Typical usage includes admission reporting, applicant transfer-program analysis, and integration extracts feeding downstream student systems. A representative query retrieving transfer program information for an applicant is:

• SELECT person_id, party_number, person_name, admission_appl_number, transfer_course_cd
• FROM igsbv_ad_adm_ps_appl
• WHERE person_id = :p_person_id;

A second common pattern filters applicants by nominated versus transfer program:

• SELECT admission_appl_number, nominated_course_cd, transfer_course_cd
• FROM igsbv_ad_adm_ps_appl
• WHERE transfer_course_cd IS NOT NULL;

Because the object is read-only, these queries are safe for concurrent reporting. Given the IGS module's obsolete status, deployments on 12.1.1 or 12.2.2 should confirm whether the view is actually implemented before relying on it in production integrations.