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.

  • Table: IGS_PS_COO_AD_UNIT_S 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_COO_AD_UNIT_S,  object_name:IGS_PS_COO_AD_UNIT_S,  status:VALID,  product: IGS - Student System ,  description: This entity describes the admission categories assigned to a program offering option unit set. ,  implementation_dba_data: IGS.IGS_PS_COO_AD_UNIT_S , 

  • View: IGS_PS_OFR_PAT_UNITSET_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PS_OFR_PAT_UNITSET_V,  object_name:IGS_PS_OFR_PAT_UNITSET_V,  status:VALID,  product: IGS - Student System ,  description: This view describes the offering pattern of a program offering option. It also describes a unit-set, being a logical sub-grouping of program. ,  implementation_dba_data: APPS.IGS_PS_OFR_PAT_UNITSET_V , 

  • Table: IGS_PS_OF_OPT_AD_CAT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_OF_OPT_AD_CAT,  object_name:IGS_PS_OF_OPT_AD_CAT,  status:VALID,  product: IGS - Student System ,  description: This entity describes the set of admission categories, which may enroll in the particular program offering option. ,  implementation_dba_data: IGS.IGS_PS_OF_OPT_AD_CAT , 

  • Table: IGS_EN_UNIT_SET_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_EN_UNIT_SET_ALL,  object_name:IGS_EN_UNIT_SET_ALL,  status:VALID,  product: IGS - Student System ,  description: This field describes a unit-set, being a logical sub-grouping of course. e.g. Major, Minor, Stream, Strand. A unit-set is typically related to the rules which govern its completion via the Rules Sub-system. ,  implementation_dba_data: IGS.IGS_EN_UNIT_SET_ALL ,