Results for “igs_ps_unit_lvl”

31 results




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

Overview

The IGS_PS_UNIT_LVL view belongs to the IGS – Student System product family, historically delivered as part of the Oracle Student System (formerly known as Oracle Student Administration / SIS). In Oracle EBS 12.1.1 and 12.2.2, this object is documented in the ETRM (E-Business Suite Technical Reference Manual) as obsolete, meaning it is retained for backward compatibility with legacy code and customizations but is not part of any supported functional flow. The view exposes programme/unit level configuration data — specifically the level attribute assigned to a unit version and its weighting toward the Weighted Average Mark (WAM) calculation.

Its primary role was to provide a multi-org secured, read-only projection of unit-level records so that forms, PL/SQL packages and reports could query unit level information without directly accessing the underlying _ALL table. Because it carries the standard ORG_ID predicate, it participates in the Multi-Org Access Control (MOAC) model used throughout EBS.

Underlying Base Objects

The ETRM metadata documents a single underlying base object: IGS_PS_UNIT_LVL_ALL. The view is a straight projection over that table, selecting all business columns plus ROWID as ROW_ID. No joins, aggregations, or lookups are defined in the view text, so it functions purely as a security-filtered synonym.

The _ALL table stores one row per combination of UNIT_CD, VERSION_NUMBER, COURSE_TYPE and COURSE_CD, together with the level and weighting attributes. The _ALL suffix indicates MOAC partitioning; the view applies the standard USERENV('CLIENT_INFO') decode to restrict rows to the operating unit currently set for the session.

Key Columns

  • ROW_ID – ROWID of the underlying IGS_PS_UNIT_LVL_ALL row; not a true primary key column, but usable for direct row addressing.
  • UNIT_CD – The unit (subject) code, the principal identifier of the unit for which the level is defined.
  • VERSION_NUMBER – Version of the unit; unit definitions are versioned, and the level applies to a specific version.
  • COURSE_TYPE – Classification of the parent course, used to distinguish programme structures (e.g. undergraduate, postgraduate).
  • UNIT_LEVEL – The academic level value assigned to the unit version; primary business attribute of this view.
  • WAM_WEIGHTING – Weighting factor contributed by the unit toward a student's Weighted Average Mark.
  • COURSE_CD / COURSE_VERSION_NUMBER – Parent course identifier and version to which the unit level record is linked.
  • ORG_ID – Operating unit that owns the record; drives MOAC filtering.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard EBS audit (Who) columns.

Common Use Cases and Queries

The view was typically referenced in custom reports, extensions and legacy concurrent programs that needed to determine a unit's level or its WAM weighting for a given version. Because the object is obsolete and (per ETRM) not implemented in all databases, any query should first confirm the object exists before referencing it in production code. A representative query is shown below.

  • Retrieving the level and weighting for a specific unit version.
  • Joining unit level data to student unit attempt or enrolment records for reporting.
  • Analysing unit weighting distributions across a course version.
SELECT unit_cd,
       version_number,
       course_cd,
       course_version_number,
       unit_level,
       wam_weighting,
       org_id
  FROM igs_ps_unit_lvl
 WHERE unit_cd = :p_unit_cd
   AND version_number = :p_version;

Because the view is obsolete and unfiltered beyond MOAC, it should be used only for read-only reporting. Any modifications to unit level data must be performed against IGS_PS_UNIT_LVL_ALL through supported APIs, not through this view.