Search Results igs_ps_of_opt_ad_cat




Overview
Explore in AI Chat

Overview

The table IGS_PS_OF_OPT_AD_CAT is a core entity within the Oracle E-Business Suite Student System (IGS) module. It functions as a cross-reference or junction table that defines the valid relationships between specific program offering options and the admission categories permitted to enroll in them. In the context of academic program management, a program offering option (e.g., a specific major, location, and attendance mode for a degree) can have restrictions or allowances on which types of applicants (defined by their admission category, such as "Freshman," "Transfer," or "International") are eligible. This table enforces those business rules, ensuring that student applications and enrollments align with institutional policies. Its role is critical for maintaining data integrity in the student lifecycle from admission through enrollment.

Key Information Stored

The table's structure is primarily composed of foreign key columns that uniquely identify a program offering option and an admission category. The primary key is a composite of the following fields, which together enforce uniqueness for each valid combination:

An additional column, COO_ID, is also referenced as a foreign key, providing an alternative identifier for the program offering option.

Common Use Cases and Queries

This table is central to admission and enrollment validation processes. A common use case is during the application submission, where the system must verify if an applicant's selected admission category is valid for their chosen program offering. Administrators also use this data to generate reports on enrollment eligibility rules or to maintain the configuration of program offerings. A typical query would retrieve all admission categories allowed for a specific program offering:

SELECT admission_cat FROM igs.igs_ps_of_opt_ad_cat WHERE course_cd = 'BSC' AND version_number = 1 AND cal_type = 'SEMESTER' AND location_cd = 'MAIN';

Conversely, to find all offering options open to a particular admission category like 'TRANSFER':

SELECT course_cd, version_number, cal_type, location_cd FROM igs.igs_ps_of_opt_ad_cat WHERE admission_cat = 'TRANSFER';

Related Objects

IGS_PS_OF_OPT_AD_CAT is intrinsically linked to several key master tables via foreign key relationships, as documented in the ETRM:

  • IGS_PS_OFR_OPT_ALL: The master table for Program Offering Options. The relationship is defined through the composite key (COURSE_CD, VERSION_NUMBER, CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, ATTENDANCE_TYPE) and also via the COO_ID column. This ensures every record in IGS_PS_OF_OPT_AD_CAT points to a valid, existing offering.
  • IGS_AD_CAT_ALL: The master table for Admission Categories. The ADMISSION_CAT column references this table, ensuring only defined admission categories are used.
  • IGS_PS_COO_AD_UNIT_S: This table, which likely manages admission unit sets for offering options, references IGS_PS_OF_OPT_AD_CAT. The join uses the same composite key columns (COURSE_CD, CRV_VERSION_NUMBER, CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, ATTENDANCE_TYPE, ADMISSION_CAT), indicating a dependent relationship where admission unit rules are scoped to specific offering-option-and-category combinations.