Results for “class_schedule_exclusion_flag”

13 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_PS_USEC_REF_V is a reporting view within the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to expose the relationship between Unit Sections and the Unit Section Reference Code. In ETRM 12.2.2 the view is classified as part of the IGS - Student System, which is flagged as obsolete, and the metadata records "Not implemented in this database," meaning it does not exist as a deployed object in the reference environment even though its definition is preserved. The view acts as a denormalized read layer over the student unit-section reference data, joining the unit section reference entity to the unit subtitle entity so that consumers can retrieve reference-code attributes together with their associated subtitle text in a single query. Analysts and integrators searching on the column class_schedule_exclusion_flag typically reach this view because that flag is one of several exclusion indicators surfaced here rather than on the base table alone.

Underlying Base Objects

The documented view definition is a two-table outer join. The driving table is IGS_PS_USEC_REF (aliased USRF), which supplies the unit section reference identifier, the unit offering option identifier, short and long titles, the three exclusion flags, and the twenty descriptive flexfield attribute columns. The second table is IGS_PS_UNIT_SUBTITLE (aliased UVSB), which supplies the SUBTITLE value; it is joined on SUBTITLE_ID using an outer join (UVSB.SUBTITLE_ID(+) in Oracle syntax), so unit section reference rows are retained even when no matching subtitle row exists. The ROWID of IGS_PS_USEC_REF is exposed as ROW_ID, which allows the view to be used for row-level identification purposes. No additional base objects are documented for this view in the ETRM metadata.

Key Columns

Common Use Cases and Queries

Because the view couples exclusion flags with subtitle descriptions, it is typically used in student scheduling and registration reporting, and in integrations that must determine whether a unit section reference participates in class schedule generation. A representative query retrieving references excluded from class scheduling is:

SELECT usec.unit_section_reference_id, usec.uooid, usec.short_title,
usec.subtitle, usec.class_schedule_exclusion_flag,
usec.registration_exclusion_flag, usec.record_exclusion_flag
FROM igs_ps_usec_ref_v usec
WHERE usec.class_schedule_exclusion_flag = 'Y';

A second pattern reports the full exclusion profile per unit offering option, joining on UOO_ID to the unit offering option entity. Practitioners should verify object existence before relying on the view, since the ETRM metadata states it is not implemented in the documented database and the IGS product line is marked obsolete; equivalent functionality in supported releases is generally obtained directly from IGS_PS_USEC_REF joined to IGS_PS_UNIT_SUBTITLE.