Search Results igs_ps_ofr_opt_all




Overview
Explore in AI Chat

Overview

The IGS_PS_OFR_OPT_ALL table is a core data entity within the Oracle E-Business Suite Student System (IGS) in releases 12.1.1 and 12.2.2. It serves as a junction table that defines the specific configuration options available for a given program offering. A program offering (IGS_PS_OFR_ALL) defines when and where a specific version of a program (course) is available. This table further refines that offering by detailing the permissible combinations of attendance mode (e.g., full-time, part-time), attendance type (e.g., on-campus, distance), and location. Its primary role is to establish the valid enrollment paths for students, forming a critical link between the structural definition of a program and the operational details of student admissions and enrollment.

Key Information Stored

The table stores a composite key that uniquely identifies each offering option, linking it to its parent offering and defining its specific characteristics. The primary key columns are COURSE_CD, VERSION_NUMBER, CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, and ATTENDANCE_TYPE. A surrogate key, COO_ID, provides a unique identifier for the record and is used as a foreign key by related child entities. Other significant columns include ENR_OFFICER_PERSON_ID, which links to the HZ_PARTIES table to designate a responsible enrollment officer for that specific option. The table's structure ensures that each distinct combination of location, attendance mode, and type for a program offering is a discrete entity for administrative and transactional purposes.

Common Use Cases and Queries

This table is central to processes involving program availability, application handling, and enrollment setup. A common use case is generating a list of all available enrollment options for a prospective student inquiring about a specific program. Administrators use this data to manage application cycles and define which options are open for admission. Typical reporting queries involve joining this table with the program offering (IGS_PS_OFR_ALL) and reference code tables for attendance modes and types to produce human-readable catalogs. For technical operations, a frequent query pattern is to retrieve the COO_ID for a specific offering combination to serve as a key for downstream processes in admissions or unit set management.

  • Retrieve all offering options for a specific program: SELECT * FROM igs_ps_ofr_opt_all WHERE course_cd = '<CODE>' AND version_number = <VERSION>;
  • Find the COO_ID for a precise offering configuration: SELECT coo_id FROM igs_ps_ofr_opt_all WHERE course_cd='...' AND version_number=... AND cal_type='...' AND location_cd='...' AND attendance_mode='...' AND attendance_type='...';

Related Objects

The IGS_PS_OFR_OPT_ALL table sits at the center of a detailed relationship network, primarily as the parent table for entities storing additional option-specific data. As documented, its primary foreign key relationship is with IGS_PS_OFR_ALL, defining the base offering. It references lookup tables for ATTENDANCE_MODE (IGS_EN_ATD_MODE_ALL) and ATTENDANCE_TYPE (IGS_EN_ATD_TYPE_ALL), and location details (IGS_AD_LOCATION_ALL). Crucially, it is the parent table for several key child entities:

These relationships underscore the table's function as a master definition for all configurable aspects of a program offering.