Search Results ref_code_type

Overview

The IGS_UC_EXAM_SCORES table is a core reference table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (presumably an institution-specific or vertical application) product family. Its primary function is to serve as a lookup and mapping repository for examination scoring data. The table establishes a definitive link between examination levels, their corresponding grade scores, and associated point values. It plays a critical role in standardizing and maintaining the integrity of examination result data across the application by enforcing relationships through foreign key constraints to the central reference codes table.

Key Information Stored

The table stores the mapping between an examination level and its permissible scores. Key columns include the unique identifier (EXAM_SCORES_ID), the examination level (EXAM_LEVEL), and the associated POINTS and GRADES. A structurally critical column is REF_CODE_TYPE, which is documented as always containing the value 'EL'. This fixed value explicitly links each record to the IGS_UC_REF_CODES table, where 'EL' in the CODE_TYPE column designates the reference data domain for "Examination Level." This design ensures that the EXAM_LEVEL values stored in IGS_UC_EXAM_SCORES are valid and controlled entries from the master reference codes table. The table also includes standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditability.

Common Use Cases and Queries

This table is central to processes involving the validation, reporting, and calculation based on examination results. Common use cases include validating applicant or student exam entries against a predefined list of acceptable levels and grades, and translating raw grade scores into standardized point values for aggregation or comparison (e.g., in admissions scoring models). A typical query to retrieve the full mapping of exam levels to their scores would leverage the relationship with IGS_UC_REF_CODES to include the meaning of the code.

SELECT esc.EXAM_LEVEL,
       rcv.MEANING AS EXAM_LEVEL_MEANING,
       esc.GRADES,
       esc.POINTS
FROM IGS.IGS_UC_EXAM_SCORES esc,
     IGS.IGS_UC_REF_CODES rcv
WHERE esc.EXAM_LEVEL = rcv.CODE
  AND rcv.CODE_TYPE = 'EL'
  AND esc.REF_CODE_TYPE = rcv.CODE_TYPE
ORDER BY esc.EXAM_LEVEL;

Another common pattern is to find the point value for a specific exam level and grade, which is essential for automated score calculation routines within the application.

Related Objects

The table's integrity is maintained through defined relationships with other database objects. Its primary key, IGS_UC_EXAM_SCORES_PK, is on the EXAM_SCORES_ID column. Most significantly, it has a foreign key relationship where its REF_CODE_TYPE column references the IGS_UC_REF_CODES table. As documented, REF_CODE_TYPE is always 'EL', creating a precise link to the examination level domain within the reference codes. The ETRM also indicates that the table is referenced by an object in the APPS schema named IGS_UC_EXAM_SCORES, which is likely a public synonym or a view that provides a centralized access point for application logic. This structure ensures that examination score data is controlled, referentially intact, and accessible to the broader EBS application modules.