Search Results igs_gr_honours_level_all

Overview

The IGS_GR_HONOURS_LEVEL_ALL table is a core data entity within the Oracle E-Business Suite Student System (IGS) module. It functions as a master reference table that stores user-defined classifications for the level of honors awarded to a student upon graduation. Its primary role is to provide a standardized set of honors levels, such as First Class Honors or Second Class Honors, which can be assigned to student graduand records. A critical aspect of this table is its designed mapping to the official DEET (Department of Education, Employment and Training) level of honors, facilitating compliance and reporting to governmental education bodies. As a multi-organization table (indicated by the "_ALL" suffix), it supports the definition of honors levels across different operating units within a single installation.

Key Information Stored

The table's structure is centered on the honors level code and its descriptive attributes. While the full column list is not detailed in the provided metadata, the primary key and foreign key relationships indicate essential data points. The central column is HONOURS_LEVEL, which serves as the unique identifier (primary key) for each honors classification. Typical columns in such a reference table would include a descriptive name (e.g., HONOURS_LEVEL_NAME), an effective date range (START_DATE, END_DATE), and a mapping field to the corresponding DEET honors code. The table likely also contains standard Oracle EBS audit columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY to track data maintenance.

Common Use Cases and Queries

This table is primarily used in processes related to student graduation and academic reporting. Common operational and reporting scenarios include assigning an honors level to a student's graduation record, generating official academic transcripts, and submitting statutory returns to education departments. Administrators may query this table to maintain the valid list of honors classifications. A typical SQL pattern involves joining to the graduand table to list graduates with a specific honors level:

• SELECT g.person_id, g.program_cd, h.honours_level, h.description FROM igs_gr_graduand_all g, igs_gr_honours_level_all h WHERE g.honours_level = h.honours_level AND h.honours_level = 'FIRST';

Another frequent use case is validating that a student's awarded honors correctly maps to the required DEET standard for external reporting.

Related Objects

The IGS_GR_HONOURS_LEVEL_ALL table is referenced by key transactional tables in the Student System, establishing its role as a parent reference entity. The documented foreign key relationships are:

• IGS_GR_GRADUAND_ALL: This table stores details about students who are eligible or have graduated. Its HONOURS_LEVEL column references IGS_GR_HONOURS_LEVEL_ALL.HONOURS_LEVEL to record the specific honors awarded to a graduand.
• IGS_AD_TER_EDU: This table, part of the Admissions module, holds tertiary education history for applicants. Its HONOURS_LEVEL column references this table, allowing the system to record honors from prior qualifications.

These relationships ensure data integrity, enforcing that only predefined honors levels can be recorded against a student's academic record, both for current graduation and historical education.