Results for “igs_ps_unit_lvl_all_u1”

6 results




Overview
Explore in AI Chat

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

Overview

IGS.IGS_PS_UNIT_LVL_ALL is a transactional table in the Oracle E-Business Suite student system (IGS) schema that describes the level of a unit (program unit) within a particular university program type. It provides a mechanism for overriding the default unit level defined at the unit level itself, allowing different year levels to be assigned to the same unit when it is undertaken in programs of different types. The table resides in the APPS_TS_TX_DATA tablespace with PCT Free 10, and is designated within FND Design Data as IGS.IGS_PS_UNIT_LVL_ALL. It carries a STATUS of VALID and is fully registered against the EBS 12.1.1 and 12.2.2 data models.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign key structure is link. This suggests the table functions primarily as an associative entity that resolves relationships between units, unit versions, programs, and program types rather than acting as an independent hub of business keys.

Key Information Stored

The primary key is defined as IGS_PS_UNIT_LVL_PK over (UNIT_CD, VERSION_NUMBER, COURSE_CD, COURSE_VERSION_NUMBER). This composite key is mirrored by the unique index IGS_PS_UNIT_LVL_ALL_U1, which captures the same four columns and serves as the business-key candidate for record uniqueness.

  • UNIT_CD (VARCHAR2(10)) — Code of the unit for which the level is specified.
  • VERSION_NUMBER (NUMBER) — Version identifier that uniquely distinguishes each version of a unit.
  • COURSE_CD (VARCHAR2) — Program code for which the unit level override applies.
  • COURSE_VERSION_NUMBER (NUMBER) — Program version number associated with the override.
  • COURSE_TYPE (VARCHAR2(10)) — Program type enabling different year-level definitions per program type. Documented as obsoleted.
  • UNIT_LEVEL (VARCHAR2) — The unit level assigned when the unit is undertaken in a program of the specified type.
  • WAM_WEIGHTING (NUMBER) — Weighting of the program unit level for Weighted Average Mark calculations.
  • ORG_ID (NUMBER(15)) — Operating unit identifier supporting multi-org security.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.

Two non-unique indexes support alternate access paths: IGS_PS_UNIT_LVL_ALL_N1 on UNIT_LEVEL and IGS_PS_UNIT_LVL_ALL_N2 on COURSE_TYPE.

Common Use Cases and Queries

Typical usage centers on resolving the effective unit level for a student's enrolment, computing weighted average marks across program units, and reporting unit-level distributions. A common query pattern retrieves overrides for a given unit:

  • SELECT unit_cd, version_number, course_cd, course_version_number, unit_level, wam_weighting FROM igs_ps_unit_lvl_all WHERE unit_cd = :unit AND org_id = :org.
  • Joining to IGS_PS_UNIT_LEVEL_ALL on UNIT_LEVEL to retrieve level descriptions for reporting.
  • Aggregating WAM_WEIGHTING for weighted average mark computation in academic progression reporting.
  • Filtering by UNIT_LEVEL (index N1) or COURSE_TYPE (index N2) for administrative listings of units at a given level or program type.

Related Objects

The table participates in several referential relationships through its foreign keys:

  • IGS_PS_UNIT_VER_ALL — joined on UNIT_CD (and VERSION_NUMBER) to obtain unit version details.
  • IGS_PS_VER_ALL — joined on COURSE_CD to obtain the program version record.
  • IGS_PS_TYPE_ALL — joined on COURSE_TYPE to resolve program type definitions.
  • IGS_PS_UNIT_LEVEL_ALL — joined on UNIT_LEVEL to resolve level descriptions.
  • Related program-unit and enrolment tables reference units by UNIT_CD/VERSION_NUMBER, so this table commonly appears in joins supporting academic record and WAM processing reports.