Search Results igs_en_gen_014




Overview
Explore in AI Chat

Overview

APPS.IGS_AS_SUA_INQ_V is a Student Unit Attempt (SUA) inquiry view within the Oracle E-Business Suite Student System (IGS) product family. It consolidates enrollment, academic period, unit offering, and assessment-related attributes into a single denormalized row per student unit attempt, allowing external reports, concurrent programs, and inquiry forms to retrieve assessment and enrollment information without issuing complex multi-table joins directly against the base transactional tables.

The view is significant in the context of the search term "igs_en_gen_014" because its SELECT list explicitly references the IGS_EN_GEN_014 package. Specifically, the view calls IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD to derive the academic period alternate code, and it invokes IGS_EN_GEN_014.enrs_clc_sua_eftsut to calculate the effective full-time student unit value (EFTSU) when no override is supplied. This makes IGS_EN_GEN_014 a runtime dependency of the view, not merely a referenced table.

Underlying Base Objects

The view is defined in the ETRM metadata as being built from the following documented base objects, joined together to produce the inquiry row:

  • IGS_EN_SU_ATTEMPT (alias SUA) — the primary source of student unit attempt records, supplying the main driving columns.
  • IGS_PS_UNIT_OFR_OPT (alias uoo) — the unit offering option, used for unit offering context.
  • IGS_PS_USEC_CPS (alias cps) — the unit section credit point source, providing enrolled and achievable credit point values used in NVL fallbacks.
  • IGS_EN_STDNT_PS_ATT (alias SCA) — the student program attempt, supplying the program version number used in the EFTSU calculation.
  • IGS_PS_UNIT_VER_ALL (alias UV) — the unit version, providing short title, repeatable indicator, and default credit point values.
  • IGS_AS_UNIT_CLASS (alias UC) — the unit class, supplying the unit mode.

The metadata lists no documented referenced base objects beyond the view text itself, so the relationships above are derived from the join and column aliases visible in the SELECT statement. IGS_EN_GEN_014 and IGS_CA_GEN_001 and IGS_IN_GEN_001 are also invoked as PL/SQL functions rather than joined tables.

Key Columns

Common Use Cases and Queries

The view is typically queried in student assessment and enrollment inquiries where EFTSU, credit points, and period codes must be resolved on the fly.

SELECT person_id, course_cd, unit_cd, version_number,
       unit_attempt_status, ci_start_dt, ci_end_dt
FROM   apps.igs_as_sua_inq_v
WHERE  person_id = :p_person_id
AND    ci_start_dt BETWEEN :p_from AND :p_to;

A second common pattern filters on unit mode and location for delivery reporting:

SELECT unit_cd, unit_mode, location_cd, unit_attempt_status
FROM   apps.igs_as_sua_inq_v
WHERE  course_cd = :p_course
AND    unit_mode = :p_mode;

Because the view invokes IGS_EN_GEN_014 at query time, wide queries returning EFTSU columns on large populations can incur PL/SQL execution overhead, so predicates on PERSON_ID or calendar instance sequence number should be applied whenever possible.