Search Results cal_start_dt




Overview
Explore in AI Chat

Overview

APPS.IGS_PS_SCH_USEC_INT is an Oracle E-Business Suite view that exposes scheduling and enrollment data associated with instructional use (schedule use) records. It is defined as a simple projection over a single base table, IGS_PS_SCH_USEC_INT_ALL, and carriers the same rows while presenting the columns under stable, friendly aliases. Because the view exposes a ROWID pseudo-column as ROW_ID, it is updatable through the standard Oracle Forms / OAF mechanism, allowing consumers to query and, where authorized, modify the underlying instructional-use rows through this interface.

In the ETRM (Enterprise Teaching and Research Management) data model, this view serves as a reporting and integration surface for the student-scheduling subsystem. It consolidates calendar context, unit offering information, section scheduling, and enrollment metrics into a single denormalized structure, which simplifies ad-hoc reporting and inbound/outbound interface processing for student records.

Underlying Base Objects

Per the documented view text, the sole base object is IGS_PS_SCH_USEC_INT_ALL. The view performs no joins, unions, or aggregations; every column in the view maps one-to-one to a column of the base table, with tab.rowid surfaced as ROW_ID. Because the _ALL suffix denotes a multi-organization table, the view is partitioned by the ORG_ID column, which is included in the projection. Querying the view without an ORG_ID predicate in a multi-org-enabled session will expose rows across operating units, so ORG_ID filtering (or a Multi-Org secured session) is essential for correct results.

Key Columns

Common Use Cases and Queries

Typical uses include enrollment capacity reporting, calendar-window scheduling exports, and reconciliation of interface-loaded schedule records. Because the view mirrors the base table exactly, most queries filter on CAL_START_DT, ORG_ID, and enrollment status columns.

  • Retrieve active schedules within a date range for a given operating unit:
SELECT int_usec_id, unit_cd, unit_title, cal_start_dt, cal_end_dt,
       enrollment_maximum, enrollment_actual
FROM   apps.igs_ps_sch_usec_int
WHERE  org_id = :p_org_id
AND    cal_start_dt BETWEEN :p_from AND :p_to
ORDER  BY cal_start_dt, unit_cd;
  • Identify interface rows not yet processed:
SELECT int_usec_id, transaction_id, import_done_flag, abort_flag
FROM   apps.igs_ps_sch_usec_int
WHERE  org_id = :p_org_id
AND    NVL(import_done_flag,'N') = 'N';

Because updatable ROWID semantics are preserved, the view can also be the target of controlled DML through supported forms; however, direct SQL updates are discouraged in favour of the application's public APIs to maintain referential and business-rule integrity.