Search Results igs_ps_unit_ofr_opt_sv




Overview
Explore in AI Chat

Overview

IGS_PS_UNIT_OFR_OPT_SV is a secured (security-enabled) view within the Oracle EBS Student System (IGS) product family. Its documented purpose is to expose data from the base table IGS_PS_UNIT_OFR_OPT_ALL, which stores unit offering option records — the schedulable, enrollable "unit offering options" that represent a specific delivery of a unit of study (a class section) within a calendar and teaching period. The "_SV" suffix denotes a secured view, indicating that row-level Oracle Application Object Library (AOL) / HR security predicates are applied at the view layer so that only the offering options a user is authorised to see are returned. This makes the view the preferred access path for reporting, self-service student functionality, and integration extracts, rather than querying the all-table directly.

In ETRM 12.2.2 the object owner is not documented and no referenced base objects are listed in the extracted metadata. In 12.1.1 and 12.2.2 the view exists as a database object in deployments where the Student System (IGS) module is installed, but the supplied metadata records the object as not implemented in the current database.

Underlying Base Objects

The view text is a straightforward column projection over a single base object. The documented definition is:

  • Base table: IGS_PS_UNIT_OFR_OPT_ALL (the "_ALL" table holding unit offering option records across operating units/orgs).
  • The view adds no joins in the extracted text; it selects the full column list and assigns ROWID an alias of ROW_ID.
  • Because it is a secured view, Oracle injects security predicates onto the query inside the view definition (typically restricting rows by organisation/operating unit and other security context) when the view is accessed.

Since the ETRM metadata states "Referenced base objects: none documented," the only confirmed dependency is the base table named in the view text itself.

Key Columns

The view exposes the full column set of the base table, including the surrogate key and the column referenced by the user's search, SUP_UOO_ID. Significant columns include:

Common Use Cases and Queries

Typical use is reporting or extraction of unit offering options subject to the caller's security profile. Because the view adds a ROW_ID alias, it is also convenient for tools that require a stable pseudo-key.

  • List offering options for a unit and period:
SELECT uoo_id, unit_cd, version_number, cal_type,
       ci_sequence_number, unit_section_status
FROM   igs_ps_unit_ofr_opt_sv
WHERE  unit_cd = :unit_cd
AND    cal_type = :cal_type;
  • Retrieve subordinate options related to a parent (uses the searched column):
SELECT uoo_id, sup_uoo_id, relation_type, default_enroll_flag
FROM   igs_ps_unit_ofr_opt_sv
WHERE  sup_uoo_id = :sup_uoo_id;
  • Check capacity against enrolment for an offering option:
SELECT uoo_id, unit_quota, enrollment_actual, waitlist_actual
FROM   igs_ps_unit_ofr_opt_sv
WHERE  offered_ind = 'Y'
AND    ss_enrol_ind = 'Y';

Queries against this view automatically inherit the security restrictions applied by the secured view layer, so results vary by the operating unit and responsibility context of the accessing user.