Search Results unit_set_admitted

Overview

The IGS_AD_KEY_ACAD_IND_V view is a denormalized reporting object within the Oracle EBS Student System (IGS) product family, owned by the APPS schema and shipped with a status of VALID across release lines 12.1.1 and 12.2.2. Its purpose is to expose admissions applicant data together with the applicant's academic index and related academic history attributes in a single, flattened projection. The view combines admission application headers, program (course) version details, institution reference data, transcript metrics, and nominated unit set information. The name itself reflects its principal functional intent: "KEY_ACAD_IND" denotes the academic index, a key admissions scoring or ranking measure used to evaluate applicants.

Unlike transactional base tables, this view is not a storage object. It is a read-only construct intended primarily for reporting, admissions decision support, personalized applicant communications, and downstream ETL/integration into admissions dashboards. Because it joins multiple base objects with outer joins, it allows consumers to retrieve academic index values even where certain academic history or transcript records may be missing.

Underlying Base Objects

The view text documents the following referenced base objects joined to produce its result set:

• IGS_AD_PS_APPL_INST — program application instance; primary driving source for applicant, application, and admitted course details.
• IGS_AD_APPL — admission application entity; contributes admission application status.
• IGS_AD_ACAD_HISTORY_V — academic history view; provides institution code, recalculated institutional GPA, and current institution flag.
• IGS_OR_INSTITUTION — institution reference table; supplies the institution name.
• IGS_AD_TRANSCRIPT — transcript data; supplies rank in class, entered GPA, and core curriculum value.
• IGS_AD_UNIT_SETS — applicant unit set preferences; supplies the first-choice unit set.
• IGS_PS_VER — program (course) version; supplies the program title for the admitted course.

Joins to IGS_AD_ACAD_HISTORY_V, IGS_OR_INSTITUTION, IGS_AD_TRANSCRIPT, and IGS_AD_UNIT_SETS are outer joins, and the unit set join is further constrained to the highest-ranking preference via US.RANK(+) = 1. The current-institution filter uses NVL(ACAD.CURRENT_INST(+), 'N') = 'Y'.

Key Columns

• PERSON_ID / ADMISSION_APPL_NUMBER / SEQUENCE_NUMBER — uniquely identify the applicant and application line.
• PROGRAM_ADMITTED / PROGRAM_TITLE — admitted course code and its descriptive title.
• ACADEMIC_INDEX — the central metric exposed by the view, sourced from IGS_AD_PS_APPL_INST.ACADEMIC_INDEX.
• PREDICTED_GPA — the projected grade point average recorded on the application.
• INST_GRADE_POINT_AVERAGE / GRADE_POINT_AVERAGE — institutional and entered GPAs from academic history and transcript respectively.
• RANK_IN_CLASS / CORE_CURRICULUM_VALUE — transcript-derived admissions indicators.
• ADM_OUTCOME_STATUS / ADM_APPL_STATUS — outcome and application status codes.
• FIRST_CHOICE_UNIT_SET — highest-ranked unit set preference.
• Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and REQUEST_ID for audit and concurrency.

Common Use Cases and Queries

Typical uses include admissions scoring reviews, applicant decision dashboards, and analytics comparing academic index against rank and GPA.

• Retrieve academic index and GPA indicators for a specific applicant:

SELECT person_id, admission_appl_number, academic_index,
       grade_point_average, rank_in_class
FROM   apps.igs_ad_key_acad_ind_v
WHERE  person_id = :p_person_id;

• Rank applicants admitted to a program by academic index:

SELECT program_admitted, admission_appl_number, academic_index
FROM   apps.igs_ad_key_acad_ind_v
WHERE  program_admitted = :p_course_cd
ORDER BY academic_index DESC;

• Report institutional GPA and core curriculum values by institution, filtering only current institution records.
• Feed downstream ETL or OBIEE/BIP reports that require a single flattened admissions academic indicator dataset.

Because the view performs outer joins and applies the RANK(+)=1 and current-institution predicates, consumers should expect one row per applicant/application/nominated-course sequence combination and should not treat it as a normalized source for updates.