Search Results igs_gr_honours_level

Overview

The IGS_GR_HONOURS_LEVEL view is a reporting and integration object within the Oracle E-Business Suite IGS – Student System product family. In the ETRM 12.2.2 metadata, this product is flagged as Obsolete, which means it is no longer actively implemented in current EBS installations and is retained only for historical reference or backward compatibility with earlier releases such as 12.1.1. The view presents honours classification levels — the graded distinctions such as First Class, Upper Second, and Lower Second — assigned to student awards. Its principal role is to expose a secure, operating-unit-filtered projection of the underlying honours level data so that reports, Concurrent Programs, and external integrations can retrieve honour classifications without directly querying the base table.

As a view, it carries no independent storage; it is a transient query layer. The documentation explicitly records that it is not implemented in this database, meaning the object may exist in legacy customer instances but is absent from the reference environment against which the ETRM metadata was captured.

Underlying Base Objects

The view is defined over a single referenced base object: IGS_GR_HONOURS_LEVEL_ALL. No other tables, synonyms, or additional objects are documented as contributing to the definition. The _ALL suffix on the base table indicates a multi-organization (multi-tenant) table that stores records across all operating units, whereas the view applies a filter to return only the rows relevant to the current session.

The filtering clause compares TAB.ORG_ID against a value derived from the USERENV('CLIENT_INFO') session attribute, using SUBSTRB and DECODE to extract the first ten bytes of client information. When no client information is present (first character is a space), a literal value of -99 is substituted. This is a classic Oracle EBS multi-org security pattern that restricts visibility according to the operating unit context established via FND_CLIENT_INFO or equivalent initialization.

Key Columns

• ROW_ID — Derived from TAB.ROWID, providing the physical row identifier used for direct-row addressing on the base table.
• ORG_ID — The operating unit identifier that governs multi-org partitioning and access control.
• HONOURS_LEVEL — The institution-defined code or name for the honours classification (for example, a degree with honours distinction).
• DESCRIPTION — The descriptive text accompanying the honours level code.
• GOVT_HONOURS_LEVEL — The government or statutory equivalent classification, used for external regulatory reporting.
• RANK — The ordinal ranking of the honours level, allowing levels to be ordered or compared.
• CLOSED_IND — A flag indicating whether the honours level is closed and therefore unavailable for new assignments.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS WHO columns providing audit and change-tracking information.

Common Use Cases and Queries

Typical uses include populating reports of student award classifications, validating honours levels during award conferral, and mapping internal classifications to government equivalents. A representative query follows:

SELECT honours_level, description, govt_honours_level, rank
FROM   igs_gr_honours_level
WHERE  closed_ind = 'N'
ORDER BY rank;

Because the view enforces the multi-org ORG_ID predicate, results are automatically scoped to the operating unit established in the session, making it suitable for use in Oracle Reports, OAF pages, and PL/SQL APIs without additional security filtering. Where the object is absent (as documented for the reference database), equivalent data should be sourced from the base table IGS_GR_HONOURS_LEVEL_ALL with explicit operating-unit handling.