Results for “unit_class_description”

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

Overview

The IGSFV_STUDENT_UNIT_ATTEMPTS view is a reporting and integration object within the IGS – Student System product family of Oracle E-Business Suite, available in both 12.1.1 and 12.2.2. It presents a denormalized, ready-to-query representation of a student's attempt at studying a particular unit offered by the university. Rather than forcing downstream reports, extracts, or integrations to join more than twenty base tables manually, the view encapsulates that join logic and exposes a single flat row per student unit attempt.

Because it consolidates person, course, unit, class, administrative status, grading, and reservation data, the view is well suited to operational reporting, student-record extracts, and interface development. It is owned by the APPS schema and is documented as VALID in the ETRM metadata. Note that although the search term "reserve_level" is not itself a column of this view, the underlying reservation information surfaces here through the RSV_LEVEL column, which is why the object frequently appears in results for that search term.

Underlying Base Objects

The ETRM metadata for 12.2.2 lists no separately documented referenced base objects, but the view text itself reveals the full dependency list. The driving table is IGS_EN_SU_ATTEMPT_ALL (aliased SUA), which holds the student unit attempt record. It is joined to a substantial set of supporting entities, including:

• HZ_PARTIES (HP1, HP2, HP3) — person and party identification.
• IGS_EN_STDNT_PS_ATT_ALL (SCA) — student program attempt context.
• IGS_PS_VER_ALL (CRV) and IGS_PS_UNIT_VER_ALL (UV, UV1) — course and unit version definitions.
• IGS_CA_INST_ALL (CA) — calendar instance / teaching period.
• IGS_AD_LOCATION_ALL (LOC1, LOC2) — location descriptions.
• IGS_AS_UNIT_CLASS_ALL (UCL), IGS_AD_ADM_UNIT_STAT_ALL (AUS), IGS_EN_DCNT_REASONCD_ALL (DR), IGS_AS_GRD_SCHEMA (GS), IGS_EN_METHOD_TYPE (EM).
• IGS_PS_RSV_EXT (RSE) — reservation extension data supplying PRIORITY_ID, PREFERENCE_ID, and RSV_LEVEL.

Collectively these joins transform normalized enrollment data into a single descriptive row.

Key Columns

Identity and context are provided by PERSON_ID, COURSE_CD, UNIT_CD, VERSION_NUMBER, CAL_TYPE, and CI_SEQUENCE_NUMBER. Timing is captured by CI_START_DT, CI_END_DT, and ENROLLED_DT. Status and outcome columns include UNIT_ATTEMPT_STATUS, ADMINISTRATIVE_UNIT_STATUS, DISCONTINUED_DT, NO_ASSESSMENT_IND, GRADING_SCHEMA_CODE, and FAILED_UNIT_RULE. Credit and load overrides appear as OVERRIDE_ENROLLED_CP, OVERRIDE_EFTSU, OVERRIDE_ACHIEVABLE_CP, and OVERRIDE_OUTCOME_DUE_DT. Reservation detail is exposed through RSV_SEAT_EXT_ID, PRIORITY_ID, PREFERENCE_ID, and RSV_LEVEL. Descriptive fields such as TITLE, DESCRIPTION, PARTY_NAME, and PARTY_NUMBER are supplied from the joined reference tables.

Common Use Cases and Queries

Typical uses include student enrollment reporting, transcript and achievement extracts, reservation/priority analysis, and feeding external student systems. A representative query for reservation reporting follows:

• SELECT person_id, party_number, unit_cd, unit_attempt_status, rsv_level, priority_id, preference_id FROM igsfv_student_unit_attempts WHERE rsv_level IS NOT NULL;
• SELECT person_id, unit_cd, enrolled_dt, override_eftsu, administrative_unit_status FROM igsfv_student_unit_attempts WHERE unit_attempt_status = 'ENROLLED';

Because the view performs the heavy joining, reports can filter and project against it directly with minimal SQL.