Results for “unconf_sua”

3 results




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

Overview

APPS.IGS_EN_SS_SCHEDULE_DISP_V is a Student System (SS) self-service display view within the Oracle E-Business Suite higher education data model. It exposes a consolidated, denormalized rowset combining a student's course attempt context (person, program, version) with derived term, attendance mode, location, and eligibility attributes. The view is principally consumed by the Student Self-Service schedule and enrolment pages, which render a student's confirmed and unconfirmed enrolment activity for a given teaching period. Because it wraps several PL/SQL API calls (IGS_EN_SPA_TERMS_API, Igs_En_Elgbl_Program, Igs_En_Prc_Load, Igs_Ss_Enr_Details), it presents business logic results rather than raw column data, making it suitable for direct page rendering and lightweight reporting rather than bulk extraction.

Underlying Base Objects

The ETRM metadata documents no explicit base objects for this view; the derivation is instead visible through the defining query text. The principal driving object is sca, an alias over the student course attempt record (a Student Course Attempt / IGS_EN_STUDENT_CRS_ATT-style source) supplying person_id, course_cd, and version_number. Programme version data is joined through pv (programme version), returning course_type as the career. Calendar context is supplied by ci1 (the term), cir (calendar instance relationship, resolving sub- and super-calendar hierarchies), and ci2 (the academic period description). The unconf_sua flag is derived from a correlated subquery against IGS_EN_SU_ATTEMPT joined to IGS_CA_LOAD_TO_TEACH_V, which maps the load calendar instance to its corresponding teaching instance.

Key Columns

Common Use Cases and Queries

The view is typically queried per student for schedule display. A representative query filtering to unconfirmed unit attempts is:

  • SELECT person_id, program_cd, career, term_description, unconf_sua FROM apps.igs_en_ss_schedule_disp_v WHERE person_id = :p_person AND unconf_sua = 'Y';
  • Term-level reporting: SELECT program_cd, academic_description, start_dt, get_spat_att_mode_desc FROM apps.igs_en_ss_schedule_disp_v WHERE person_id = :p_person ORDER BY start_dt;
  • Confirming attendance mode and location for a schedule: select the _DESC attendance columns alongside TERM_DESCRIPTION.

Because the view invokes multiple API functions per row, queries should remain narrowly filtered by PERSON_ID to avoid performance degradation. For set-based reporting, materialising the results into a table is preferable to repeatedly calling the view.