Search Results cal_end_dt




Overview
Explore in AI Chat

Overview

IGS_PS_SCH_USEC_INT is an Oracle E-Business Suite interface view owned by the APPS schema within the IGS (Student System) product family. Its documented purpose is to capture Scheduler Interface Unit Section data, exposing the denormalized rows that feed or reflect the interface between external scheduling processes and the student system's unit section records. The view is defined over the underlying table IGS_PS_SCH_USEC_INT_ALL, filtering and projecting only the columns that the scheduler import interface requires. In EBS 12.1.1 and 12.2.2 the object carries a VALID status and is classified strictly as a VIEW, meaning it stores no data of its own and inherits all edition and row-level security behavior from its base table.

Because the view selects TAB.ROWID as ROW_ID, it is updateable under Oracle's standard key-preserved rules, which allows interface programs to resolve a row back to its physical base record for subsequent DML. This makes it a practical integration surface rather than a pure reporting construct.

Underlying Base Objects

The documented view text references a single base object, IGS_PS_SCH_USEC_INT_ALL. No other referenced base objects are documented in the ETRM metadata. The view is therefore a thin projection: every column is a straight pass-through from the _ALL table, with no joins, unions, or computed expressions. Practitioners should note that when metadata lists the base object as IGS_PS_SCH_USEC_INT_ALL, the corresponding translated, secured, or operating-unit-filtered variant (the non _ALL name) may reside in the same schema; however, only the _ALL table is documented here, and no synonyms or additional dependencies are recorded.

Key Columns

The view exposes 33 columns. The most significant for the user's search term and general use are:

Common Use Cases and Queries

Typical scenarios include auditing imported scheduler sections, reconciling interface rows against the base table, and reporting sections by their end date to identify expiring or closed offerings. A representative query filtered on the searched column follows.

  • List sections ending within a range: 
    SELECT int_usec_id, unit_cd, version_number,
       unit_section_start_date, unit_section_end_date,
       unit_section_status
FROM   apps.igs_ps_sch_usec_int
WHERE  unit_section_end_date BETWEEN :start_date AND :end_date
AND    org_id = :org_id;
  • Detect unconsumed interface rows: 
    SELECT int_usec_id, unit_cd, import_done_flag, abort_flag
FROM   apps.igs_ps_sch_usec_int
WHERE  NVL(import_done_flag,'N') = 'N'
AND    NVL(abort_flag,'N') = 'N';
  • Validate calendar alignment: 
    SELECT int_usec_id, unit_section_end_date, cal_end_dt
FROM   apps.igs_ps_sch_usec_int
WHERE  unit_section_end_date > cal_end_dt;

All queries should be schema-qualified with APPS and constrained by ORG_ID where operating unit security is enforced.