Search Results igs_en_su_attempt_h




Overview
Explore in AI Chat

Overview

IGS_EN_SU_ATTEMPT_H is an Oracle E-Business Suite view owned by the APPS schema within the IGS (Student System) product family. It exposes historical student unit attempt records, providing a reporting and integration layer over the underlying attempt history table. The view implements the "student unit attempt" concept for historical data, which is distinct from the current, transactional attempt data. In the ETRM 12.1.1 and 12.2.2 documentation, the object carries a VALID status, confirming it is a supported and active database object.

The view is important because it enforces multi-organization (multi-tenant/ORG_ID) security at the database level. Its defining WHERE clause uses USERENV('CLIENT_INFO') to derive the active organization context and filters rows to match that value, defaulting to -99 when no context exists. This makes the view the preferred access path for reports and concurrent programs that must respect the current operating unit or organization.

Underlying Base Objects

Per the ETRM metadata, the view is defined over a single base object: IGS_EN_SU_ATTEMPT_H_ALL. The _ALL suffix denotes the underlying table that stores records across all organizations, with ORG_ID as the partitioning/discriminating key. No other referenced base objects are documented in the ETRM record, though the view's column list indicates denormalized attributes (such as AUS_DESCRIPTION, ALTERNATIVE_TITLE, and ELO_DESCRIPTION) that are likely sourced directly from the _ALL table rather than joined at query time.

The relationship is therefore one of controlled projection: IGS_EN_SU_ATTEMPT_H_ALL holds the complete historical dataset, while IGS_EN_SU_ATTEMPT_H presents an organization-filtered subset. The view also synthesizes a ROW_ID column from the table's ROWID, and aliases UOO_ID explicitly, providing stable identifiers for downstream use.

Key Columns

Common Use Cases and Queries

Typical scenarios include extracting discontinued unit attempts with their reasons, reconciling historical enrollment against the current attempt table, and feeding student-record integrations. Because the view is organization-filtered, queries executed under a defined CLIENT_INFO context return only the relevant organization's data.

Sample query returning discontinuation detail:

  • SELECT person_id, course_cd, unit_cd, version_number, discontinued_dt, dcnt_reason_cd
  • FROM apps.igs_en_su_attempt_h
  • WHERE dcnt_reason_cd IS NOT NULL
  • AND discontinued_dt BETWEEN :start_date AND :end_date;

A second common pattern aggregates attempts per organization:

  • SELECT org_id, unit_cd, COUNT(*) attempt_count
  • FROM apps.igs_en_su_attempt_h
  • WHERE unit_attempt_status = :status
  • GROUP BY org_id, unit_cd;

When using this view, note that the security predicate cannot be bypassed without altering the session context; callers requiring cross-organization data must query IGS_EN_SU_ATTEMPT_H_ALL directly, subject to appropriate privileges.