Search Results exam_level




Overview
Explore in AI Chat

Overview

The IGS_UC_MAP_EBL_QUAL table is a seeded reference table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, residing in the IGS (iGrants) schema. Its primary role is to maintain critical mapping information that links examination board details, examination levels, and qualification data. This table functions as a central lookup to standardize and convert external examination board and level (EBL) formats used by awarding bodies into a consistent internal format. By holding this seeded mapping data, it supports processes related to student qualifications, admissions, and credential management within the EBS ecosystem, ensuring accurate interpretation of external educational records.

Key Information Stored

The table's structure is designed to capture the essential attributes for mapping examination data. The key business columns include EXAM_BOARD_CODE, which identifies the originating examination board, and the pivotal EXAM_LEVEL column, which stores the code for the examination level (e.g., 'A' for Advanced Level). The AWARDING_BODY code specifies the organization granting the qualification. The EBL_FORMAT and CONV_EBL_FORMAT columns hold, respectively, the original external subject format and its converted, standardized internal equivalent. The CLOSED_IND column, accepting 'Y' or 'N', indicates whether a specific mapping record is active for use. The table is secured by a unique primary key index, IGS_UC_MAP_EBL_QUAL_PK, on the combination of EXAM_BOARD_CODE and EXAM_LEVEL, and includes standard WHO columns for auditing creation and modification history.

Common Use Cases and Queries

This table is primarily queried during the intake and processing of external qualification data. A common use case is validating and translating incoming student examination records against the seeded mappings to ensure consistency before data is posted to core student information tables. For reporting, it is used to enrich qualification data with standardized descriptions. A fundamental query to retrieve all active mapping records for a specific examination level, as hinted by the user's search for "exam_level", would be:

  • SELECT exam_board_code, ebl_format, exam_level, awarding_body, conv_ebl_format FROM igs.igs_uc_map_ebl_qual WHERE closed_ind = 'N' AND exam_level = :p_exam_level ORDER BY exam_board_code;

Another typical operational query involves joining this table to transactional data to fetch the converted EBL format for processing: SELECT map.conv_ebl_format FROM igs.igs_uc_map_ebl_qual map WHERE map.exam_board_code = :p_board_code AND map.exam_level = :p_level AND map.closed_ind = 'N';

Related Objects

Based on the provided dependency information, the IGS_UC_MAP_EBL_QUAL table does not reference other objects but is itself referenced by objects within the APPS schema. This indicates it is a foundational source table. Its data is likely accessed by various application forms, concurrent programs, and APIs within the IGS modules (such as iGrants or Student Management) that handle qualifications and admissions. While specific dependent object names are not listed, it is common for such a reference table to be utilized by validation logic in PL/SQL packages and by views that present a consolidated perspective of student qualification history.