Search Results igs_ps_coo_ad_unit_s




Overview
Explore in AI Chat

Overview

The table IGS_PS_COO_AD_UNIT_S is a core entity within the Oracle E-Business Suite Student System (IGS) module, specifically designed for managing program structures. It serves as a critical junction table that defines the relationship between a specific program offering option admission category and a unit set. Its primary role is to record which admission categories are permitted or required to enroll in particular unit sets for a given program offering option. This configuration enables institutions to enforce precise academic and administrative rules, linking a student's admission pathway directly to the specific groups of units (unit sets) they are authorized to undertake. It is important to note that the ETRM metadata explicitly marks the IGS - Student System as "Obsolete" and states this table is "Not implemented in this database," indicating it may be part of a legacy data model not deployed in standard Oracle EBS 12.1.1 or 12.2.2 instances.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies each valid admission category-to-unit set assignment. The key columns precisely reference the program offering option and the unit set. The COURSE_CD and CRV_VERSION_NUMBER identify the program (course) and its version. The CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, and ATTENDANCE_TYPE columns define the specific offering option of that program. The ADMISSION_CAT column specifies the applicable admission category within that offering option. Finally, the UNIT_SET_CD and US_VERSION_NUMBER columns identify the specific unit set that is linked to the aforementioned admission category. This design ensures that the relationship is scoped to a very granular academic context.

Common Use Cases and Queries

The primary use case for this table is to validate a student's enrollment in a unit set based on their admission parameters. A typical query would retrieve all unit sets available to a student in a specific program offering. For example, an application process might execute a query to list eligible unit sets: SELECT us.unit_set_cd FROM igs_ps_coo_ad_unit_s coo_us WHERE coo_us.course_cd = :p_course_cd AND coo_us.crv_version_number = :p_version AND ... AND coo_us.admission_cat = :p_adm_cat;. Conversely, administrative reporting would use this table to audit or document the admission rules configured for unit sets across the curriculum. Given its "not implemented" status, direct operational use in a live system is unlikely; its utility would be primarily for data analysis, migration planning, or understanding the legacy data model.

Related Objects

As documented in the foreign key relationships, IGS_PS_COO_AD_UNIT_S has two primary parent tables. It is a child of IGS_PS_OF_OPT_AD_CAT, which defines the valid admission categories for a program offering option. The join is performed on all columns that define the offering option and admission category (COURSE_CD, CRV_VERSION_NUMBER, CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, ATTENDANCE_TYPE, ADMISSION_CAT). It is also a child of IGS_EN_UNIT_SET_ALL, the master table for unit sets, joined on UNIT_SET_CD and US_VERSION_NUMBER. Therefore, this table sits at the intersection of these two key entities, enabling the many-to-many relationship between admission categories and unit sets within the context of a program offering.