Search Results unit_set_id




Overview
Explore in AI Chat

Overview

The IGS_AD_UNIT_SETS table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Admissions (IGS) module. It functions as a transactional repository for storing an applicant's ranked preferences for academic unit sets during the admission application process. A unit set typically represents a major, minor, specialization, or other defined academic plan within a nominated course of study. This table enables institutions to capture and process an applicant's desired academic paths in a prioritized order, which is critical for application evaluation, offer management, and enrollment planning. Its status as VALID confirms it is an active, supported table within the application's data model.

Key Information Stored

The table stores a combination of application identifiers, unit set details, ranking, and standard audit columns. The primary unique identifier is the UNIT_SET_ID, a system-generated sequence number. Key business columns include PERSON_ID (linking to the party in HZ_PARTIES), ADMISSION_APPL_NUMBER, and NOMINATED_COURSE_CD to uniquely identify the specific application. The academic preference is defined by UNIT_SET_CD and its VERSION_NUMBER. The RANK column holds the numerical priority (e.g., 1 for first choice) assigned by the applicant to this unit set. The table also includes standard EBS "Who" columns (CREATED_BY, CREATION_DATE, etc.) and concurrent program request identifiers for tracking data provenance.

Common Use Cases and Queries

This table is central to reporting and processes involving applicant preferences. Common use cases include generating reports on the popularity of specific unit sets, managing conditional offers based on unit set availability, and validating application completeness. A typical query retrieves all ranked unit sets for a specific application to understand an applicant's academic intentions.

  • Retrieve Applicant's Ranked Unit Sets:
    SELECT unit_set_cd, version_number, rank FROM igs.igs_ad_unit_sets WHERE person_id = :p_person_id AND admission_appl_number = :p_appl_number ORDER BY rank;
  • Report on Unit Set Demand for a Course:
    SELECT unit_set_cd, version_number, COUNT(*) AS applicant_count FROM igs.igs_ad_unit_sets WHERE nominated_course_cd = :p_course_cd GROUP BY unit_set_cd, version_number ORDER BY applicant_count DESC;

Related Objects

Based on the column metadata, IGS_AD_UNIT_SETS has defined relationships with other core EBS tables. The PERSON_ID column is a foreign key to HZ_PARTIES, linking applicant data to the Trading Community Architecture (TCA) foundation. The table's primary non-unique index (IGS_AD_UNIT_SETS_U1) on UNIT_SET_ID facilitates performance for lookups using this key. A second composite index (IGS_AD_UNIT_SETS_U2) on PERSON_ID, ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD, SEQUENCE_NUMBER, UNIT_SET_CD, and VERSION_NUMBER supports efficient queries that retrieve specific unit set records within the context of a full application. This table is likely referenced by other Admissions module tables and forms that manage application details and offers.