Search Results dir_enrollment




Overview
Explore in AI Chat

Overview

IGS_PS_UNIT_OFR_OPT_SV is a database view in the Oracle EBS Student System (IGS) schema, owned by APPS and exposed for reporting and integration against the higher-education product family. Its name follows the IGS convention for "unit offering option" selectable views, and it presents a denormalized picture of the unit offering option (UOO) records that drive enrollment, section scheduling, and grading configuration for a given academic unit offering. The view is registered in ETRM for releases 12.1.1 and 12.2.2 and is intended primarily as a read-only reporting surface rather than as a transaction entry object.

The view is a projection over the IGS_PS_UNIT_OFR_OPT_ALL base table, including a synthetic ROW_ID column derived from the physical ROWID. It exposes identity columns, calendar and version context, location and class attributes, quota and enrollment counters, financial-aid flags, grading schema bindings, and a set of indicator flags covering audit permission, attendance, reserved seating, special permission, and anonymous grading. The auditable_ind column that prompted the search is one of a family of indicator columns on the view and records whether the offering option may be audited by a student, with audit_permission_ind governing the associated permission behavior.

Underlying Base Objects

ETRM documents no referenced base objects for this view in the 12.2.2 metadata, but the view text itself is unambiguous: every column, including auditable_ind, is selected directly from IGS_PS_UNIT_OFR_OPT_ALL. There is no join, aggregation, or UNION in the definition; the view is a straight column projection with ROWID aliasing.

  • IGS_PS_UNIT_OFR_OPT_ALL — the single documented source object, holding unit offering option rows keyed by UOO_ID, unit code, version number, calendar type, and calendar instance sequence.
  • ROWID — aliased as ROW_ID to give consumers a stable physical row identifier for the underlying table row.
  • No other base tables, synonyms, or remote objects appear in the view text.

Because the view reads from the _ALL suffixed table, the base object is an org-stripped (non-MOAC) table in IGS, and ORG_ID is carried through as an ordinary column over which consumers must filter explicitly.

Key Columns

Common Use Cases and Queries

The view is typically used for enrollment analytics, audit-eligibility reporting, and integration extracts that need offering-level flags without touching the underlying table directly. A representative query lists units open for auditing within an organization:

  • Audit eligibility report — select unit_cd, version_number, location_cd, unit_section_status, auditable_ind, audit_permission_ind from apps.igs_ps_unit_ofr_opt_sv where auditable_ind = 'Y' and org_id = :p_org_id.
  • Capacity versus demand — select uoo_id, enrollment_actual, unit_quota, unit_quota_reserved_places from apps.igs_ps_unit_ofr_opt_sv where cal_type = :p_cal_type and ci_sequence_number = :p_seq.
  • Self-service visibility extract — select unit_cd, ss_enrol_ind, ss_display_ind, offered_ind from apps.igs_ps_unit_ofr_opt_sv where offered_ind = 'Y'.

Consumers should apply the standard EBS org filter, avoid relying on the synthetic ROW_ID for anything other than row identity, and treat indicator columns such as auditable_ind as Y/N or null flags whose authoritative meaning is defined in the IGS data model.