Results for “non_std_usec_flag”

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

Overview

IGS_SS_USEC_V is a reporting view within the Oracle E-Business Suite Student System (IGS) module, labeled "Obsolete" in the ETRM documentation for releases 12.1.1 and 12.2.2, but historically central to self-service enrollment functionality. It consolidates Unit Section (USEC) data that is exposed to self-service applications such as Student Self-Service and faculty-facing class rosters. Rather than requiring those applications to join numerous staging tables directly, the view presents a single denormalized result set combining unit version details, unit offering options, teaching calendar instances, and waitlist configuration. The view's declared purpose is to "store the Unit Sections for self service applications," and the ETRM implementation notes state that it is "Not implemented in this database" in the reference environment, meaning the view definition is documented but may be deployed conditionally depending on the institution's configuration.

Underlying Base Objects

The view is defined over five base objects via a join of the unit and offering model:

• IGS_PS_UNIT_VER (alias A) — the unit version master, supplying title, status, and enrollment defaults.
• IGS_PS_UNIT_OFR_OPT (alias B) — the unit offering option/unit section record, supplying calendar type, call number, and self-service indicator flags.
• IGS_CA_INST (alias C) — the calendar instance, supplying teaching period start/end dates and description.
• IGS_PS_USEC_LIM_WLST (alias D, outer-joined) — waitlist and enrollment limits at the unit offering option level.
• IGS_PS_UNIT_OFR_PAT (alias E) — unit offering patterns, filtered by DELETE_FLAG = 'N', providing fallback waitlist limits.

The joins are driven by UNIT_CD and VERSION_NUMBER between A, B, and E; by CAL_TYPE and CI_SEQUENCE_NUMBER between B, C, and E; and by UOO_ID between B and D. ETRM lists no referenced base objects in its structured metadata, though the embedded view text clearly identifies the five tables above.

Key Columns

• UNIT_CD, VERSION_NUMBER — identify the academic unit and curriculum version.
• UOO_ID, CAL_TYPE, CI_SEQUENCE_NUMBER, CALL_NUMBER — identify the specific unit section and its teaching calendar.
• UNIT_STATUS, UNIT_SECTION_STATUS, UNIT_CLASS — lifecycle and classification of the unit and section.
• SS_DISPLAY_IND, SS_ENROL_IND, AUDITABLE_IND, NON_STD_USEC_FLAG — self-service display, enrollment, audit, and non-standard section flags.
• ENROLLMENT_ACTUAL, WAITLIST_ACTUAL — live enrollment and waitlist counts.
• START_DATE, END_DATE, TEACH_CAL_DESCRIPTION — formatted teaching period dates and calendar description.
• ENROLLMENT_MINIMUM, ENROLLMENT_MAXIMUM, MAX_STUDENTS_PER_WAITLIST — limits resolved via NVL chains from the waitlist and pattern tables, with the function IGS_SS_ENR_DETAILS.GET_MAX_STD_WAIT_ORG_LEVEL applied as the final fallback.

Common Use Cases and Queries

This view is typically queried by self-service enrollment pages, waitlist management reports, and enrollment dashboard extracts. A basic listing of open sections for a calendar follows:

SELECT unit_cd, version_number, call_number, title,
       start_date, end_date, enrollment_actual,
       enrollment_maximum, ss_enrol_ind
FROM   igs_ss_usec_v
WHERE  cal_type = 'SEM-1'
AND    unit_section_status = 'ACTIVE'
ORDER BY unit_cd, call_number;

Administrators may also audit waitlist capacity resolution or verify which sections are exposed to students:

SELECT call_number, max_students_per_waitlist,
       waitlist_actual, ss_display_ind
FROM   igs_ss_usec_v
WHERE  ss_display_ind = 'Y'
AND    waitlist_actual > 0;

Because the view is marked obsolete and not implemented in the reference database, developers should confirm deployment status against the target instance and generally prefer the underlying IGS_PS_UNIT_OFR_OPT and IGS_CA_INST joins for new development.