Search Results unit_section_end_date




Overview
Explore in AI Chat

Overview

The view APPS.IGS_PS_UNIT_OFR_OPT belongs to the Oracle E-Business Suite Student System (IGS) schema family, specifically the module concerned with unit offerings and optional unit configurations within an academic calendar. It presents a denormalized, reporting-friendly projection of the underlying unit offering option data, exposing section-level attributes such as start and end dates, quota, grading schema, contact details, and enrollment counters. In release 12.1.1 and 12.2.2, this view serves as a read-only integration and reporting surface for concurrent programs, OAF pages, and external extracts that require a consolidated picture of offered unit sections without navigating the normalized hierarchical tables.

The view is particularly significant because it surfaces the column unit_section_start_date, the attribute most frequently queried by users investigating when a specific unit section becomes active. This column pairs with unit_section_end_date to define the effective teaching window for each offering option.

Underlying Base Objects

The ETRM documentation for this view does not enumerate a formal list of referenced base objects; the metadata states that no base objects are documented. The view text is presented as a preformatted SELECT that aliases its source as tab, indicating it is defined over a single driving query rather than a multi-table join exposed to the dictionary. Because the selected columns carry the unit_cd, version_number, cal_type, ci_sequence_number, location_cd, and uoo_id identifiers, the underlying source is functionally the unit offering option entity in the IGS schema, commonly understood to derive from IGS_PS_UNIT_OFR_OPT style base data. The presence of OWF-style audit and program columns (created_by, creation_date, last_updated_by, last_update_date, last_update_login, request_id, program_application_id, program_id, program_update_date) confirms the view is layered over an audited base table, with org_id enabling Multi-Org (MOAC) filtering.

Key Columns

  • unit_cd, version_number, cal_type, ci_sequence_number – the composite business key identifying the unit version and calendar instance.
  • uoo_id – the unique surrogate identifier for the unit offering option row.
  • unit_section_start_date / unit_section_end_date – the effective date window for the section.
  • unit_section_status – current lifecycle status of the section.
  • offered_ind, ivrs_available_ind – flags indicating whether the unit is actively offered and available through IVRS.
  • unit_quota, unit_quota_reserved_places, reserved_seating_allowed – capacity and restricted-seat controls.
  • enrollment_actual, waitlist_actual – live enrollment and waitlist counters.
  • grading_schema_cd, gs_version_number, grading_schema_prcdnce_ind – grading configuration references.
  • call_number, location_cd, unit_class, unit_contact – scheduling and delivery attributes.
  • org_id – operating unit context for MOAC security.

Common Use Cases and Queries

The most frequent scenario is locating sections by their start date, which explains the search term associated with this object. A representative query follows:

SELECT unit_cd, version_number, cal_type, unit_section_start_date, unit_section_end_date, unit_section_status, enrollment_actual FROM apps.igs_ps_unit_ofr_opt WHERE unit_cd = :unit_cd AND unit_section_start_date >= :from_date ORDER BY unit_section_start_date;

Other common uses include capacity reporting (comparing unit_quota against enrollment_actual), availability checks filtered on offered_ind and ss_enrol_ind, and date-driven extracts for term rollover. All queries should respect org_id to comply with Multi-Org access rules.