Results for “igs_as_su_setatmpt_h”

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

Overview

IGS_AS_SU_SETATMPT_H is a view in the Oracle E-Business Suite Student System (IGS) module that exposes unit set attempt history records. Its purpose is to present the historical, versioned record of a student's attempt at a unit set — a grouping of units (courses) that a student selects, is enrolled in, or completes as a logical academic container. Because it is a history ("_H") view, each row represents a point-in-time or versioned state of a unit set attempt record, retaining the audit trail of changes through history start and end dates and a version number.

In Oracle EBS 12.1.1 and 12.2.2, this object belongs to the obsolete Student System product line. ETRM categorises the product as "IGS - Student System (Obsolete)" and the implementation record explicitly states "Not implemented in this database." This indicates the view is documented for reference only and is not shipped or compiled in the target instance. Where deployed historically, it served reporting and integration needs: surfacing unit set attempt history for student progression analysis, enrolment audits, results processing, and downstream extracts to data warehouses or regulatory reporting.

Underlying Base Objects

The view is defined over a single underlying base object, IGS_AS_SU_SETATMPT_H_ALL, which is the multi-organisation (MOAC-enabled) history table for unit set attempts. The view supplies a select-list projection of that table's columns and applies a Multi-Org security predicate. No other base objects are documented in the supplied ETRM metadata ("Referenced base objects: none documented"), so the relationship is a straightforward one-to-one projection from the _ALL table.

The critical structural element is the ORG_ID filter, which uses the traditional client_info-based operating unit mechanism:

• NVL(TAB.ORG_ID, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'), 1, 1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'), 1, 10))), -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'), 1, 1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'), 1, 10))), -99)

This predicate restricts rows to the operating unit currently set in the session's CLIENT_INFO, defaulting to -99. It enforces operating unit isolation, meaning queries return only the attempt history belonging to the active organisation context.

Key Columns

The view exposes the following columns, each projecting an identically named column from the base table:

• ROW_ID — Row identifier derived from the base table ROWID.
• PERSON_ID, COURSE_CD, UNIT_SET_CD, SEQUENCE_NUMBER — Core identity of the student and the unit set attempt being tracked.
• PARENT_UNIT_SET_CD, PARENT_SEQUENCE_NUMBER — The user's search term parent_unit_set_cd maps directly to this column. It identifies the parent unit set when the attempt record is nested within a higher-level unit set hierarchy, enabling hierarchical reporting of unit set structures.
• HIST_START_DT, HIST_END_DT, HIST_WHO — History dating columns recording the validity window and the user who effected the change.
• US_VERSION_NUMBER — Version number of the unit set attempt record, supporting the history/versioning model.
• SELECTION_DT, STUDENT_CONFIRMED_IND — When the student selected the unit set and whether the student confirmed it.
• END_DT, VOLUNTARY_END_IND, PRIMARY_SET_IND — Attempt end date, whether the end was voluntary, and whether this is the primary set.
• AUTHORISED_PERSON_ID, AUTHORISED_ON, OVERRIDE_TITLE — Authorisation details and any overridden title for the set.
• RQRMNTS_COMPLETE_IND, RQRMNTS_COMPLETE_DT, S_COMPLETED_SOURCE_TYPE — Requirement completion status, date, and source type.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns.
• ORG_ID, CATALOG_CAL_TYPE, CATALOG_SEQ_NUM — Operating unit and the catalogue calendar/sequence identifying the academic catalogue context.

Common Use Cases and Queries

Typical uses include tracing unit set attempt history for a student, examining hierarchical unit set nesting via PARENT_UNIT_SET_CD, and audit reporting on who changed attempt records and when. A representative query:

SELECT person_id, unit_set_cd, parent_unit_set_cd,
       sequence_number, us_version_number,
       hist_start_dt, hist_end_dt, org_id
FROM   igs_as_su_setatmpt_h
WHERE  person_id = :person_id
ORDER  BY unit_set_cd, us_version_number, hist_start_dt;

To traverse the parent/child hierarchy, a self-join on the parent column is used:

SELECT c.unit_set_cd child_set, c.parent_unit_set_cd parent_set,
       p.unit_set_cd parent_desc
FROM   igs_as_su_setatmpt_h c, igs_as_su_setatmpt_h p
WHERE  c.parent_unit_set_cd = p.unit_set_cd
AND    c.person_id = :person_id;

Because the product is obsolete and the view is "Not implemented" per ETRM, these queries apply only to legacy instances where the underlying IGS_AS_SU_SETATMPT_H_ALL table exists. In current 12.1.1/12.2.2 environments the object may be absent, so it should be treated as reference documentation rather than an actively supported integration point.