Results for “igs_as_sua_inq_v”

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

Overview

IGS_AS_SUA_INQ_V is an Oracle E-Business Suite 12.1.1 / 12.2.2 view owned by the APPS schema within the IGS (Student System) product family. The naming convention resolves to a Student Unit Attempt (SUA) inquiry view; the trailing "_INQ_V" indicates it is designed as a read-only, inquiry-oriented projection of student unit attempt data. The ETRM metadata classifies the object as a VIEW with VALID status and describes its content as "- Retrofitted," meaning the object was carried forward from an earlier release line and reconciled into the 12.2.2 code line, where its documented base-object list is empty and no formal dependencies are registered.

Functionally, the view consolidates the enrollment and assessment attributes of a single student unit attempt into one wide row, enriching the stored base-table values with values derived at query time through stored PL/SQL functions. It is therefore best understood as a reporting and integration surface rather than a transactional object: it is queried for self-service and administrative inquiry screens, extracts, and third-party integrations that require a denormalized, ready-to-consume representation of student unit attempt state.

Underlying Base Objects

The documented view text drives the definition from the primary table IGS_EN_SU_ATTEMPT (aliased SUA), joined to IGS_PS_UNIT_OFR_OPT (UOO), the unit offering option, and to a unit version source (aliased UV, with SCA referenced for course version context) and a credit-point source (aliased CPS). Because the ETRM dependency registry documents no base objects for this view, the authoritative list must be taken from the stored view text rather than from the metadata registry. The joins supply offering and version context—alternative or short title, unit mode, repeatable indicator, and credit-point defaults—while the SUA table supplies the enrollment, calendar, location, status, and override columns.

Several columns are not stored but computed through IGS package functions: IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD and IGS_CA_GEN_001.CALP_GET_ALT_CD derive the academic and calendar period alternate codes; IGS_EN_GEN_014.ENRS_CLC_SUA_EFTSUT calculates the effective full-time student unit value; and IGS_IN_GEN_001.INQP_GET_SUA_ACHVD evaluates achievable credit points. Post-12.1.1 retrofitting means any customer extension or custom report must verify the underlying table and function signatures against the target release, since the view text is release-sensitive.

Key Columns

• PERSON_ID, COURSE_CD, UNIT_CD, VERSION_NUMBER — the student and the unit version being attempted; the concatenation UNIT_CD || '.' || VERSION_NUMBER yields the standard unit-version display key.
• Title columns — the NVL of SUA.ALTERNATIVE_TITLE over UV.SHORT_TITLE, plus the composed calendar alternate code string.
• CAL_TYPE, CI_SEQUENCE_NUMBER — teaching calendar and calendar instance identifying the teaching period.
• LOCATION_CD, UNIT_CLASS, UNIT_MODE — delivery attributes of the attempt.
• CI_START_DT, CI_END_DT, ENROLLED_DT, DISCONTINUED_DT, RULE_WAIVED_DT — lifecycle dates for the attempt.
• UNIT_ATTEMPT_STATUS, ADMINISTRATIVE_UNIT_STATUS, NO_ASSESSMENT_IND — status and assessment flags.
• Credit columns — enrolled and achievable credit points, subject to SUA-level overrides before falling back to CPS or UV defaults.
• OVERIDE_EFTSU — the effective full-time student unit value derived by function call.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical usage includes student self-service inquiry of unit attempts, assessment and outcome monitoring, and extraction feeds for downstream reporting. Because the view invokes PL/SQL functions per row, queries should be filtered aggressively to avoid performance degradation.

To list all attempts for a student in a teaching period:

SELECT person_id, unit_cd, version_number, unit_attempt_status
FROM   apps.igs_as_sua_inq_v
WHERE  person_id = :p_person_id
AND    cal_type = :p_cal_type
AND    ci_sequence_number = :p_ci_seq;

To report achievable versus enrolled credit points for active attempts:

SELECT person_id, unit_cd, enrolled_credit_points, achievable_credit_points
FROM   apps.igs_as_sua_inq_v
WHERE  course_cd = :p_course_cd
AND    unit_attempt_status = 'ENROLLED';

Standard practice is to reference the view only through the APPS schema, to join it to person and course dimension views for descriptive attributes, and to test any custom query against both 12.1.1 and 12.2.2 because the retrofitted view text may differ between releases.