Search Results igs_he_sys_rtn_clas




Overview
Explore in AI Chat

Overview

The IGS_HE_SYS_RTN_CLAS table is a core reference table within the now-obsolete Oracle Student System (IGS) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. Its primary role is to serve as a master repository for predefined return class types used in statutory reporting. Specifically, it defines the fundamental categories of data returns, such as Student Return and Module Return, which are mandated by external bodies like higher education funding councils or government agencies. This table acts as a system-level control, ensuring consistency and standardization in how different types of institutional returns are structured and processed across the application.

Key Information Stored

The table's structure is intentionally simple, designed to hold a controlled list of valid return class types. The central and primary key column is SYSTEM_RETURN_CLASS_TYPE. This column stores the unique, predefined code that identifies each type of system return class, such as 'STUDENT', 'MODULE', or 'COMBINED'. While the provided ETRM metadata does not list additional columns, tables of this nature in the IGS module often include descriptive columns (e.g., DESCRIPTION) and standard WHO columns for tracking creation and modification dates. The integrity of this reference data is critical, as the SYSTEM_RETURN_CLASS_TYPE value is propagated to dependent transactional and configuration tables.

Common Use Cases and Queries

The primary use case for this table is to validate and constrain user-defined return configurations. When an administrator sets up a new user-defined return class, the application validates it against a valid system class type from this table. Common queries involve listing all available system return classes for setup screens or validating a specific type. For instance, a query to retrieve all predefined classes would be: SELECT system_return_class_type FROM igs_he_sys_rtn_clas ORDER BY 1;. In reporting scenarios, this table is typically joined to user-defined class tables to generate master lists of all configured returns, categorized by their system type, which is essential for audit and compliance reporting.

Related Objects

The IGS_HE_SYS_RTN_CLAS table has defined relationships with two key configuration tables, as documented by its foreign keys. These relationships enforce referential integrity, ensuring that user-defined configurations are based on valid system types.

  • IGS_HE_SYS_RT_CL_FLD: This table likely defines the specific fields or data elements required for each system return class type. It references IGS_HE_SYS_RTN_CLAS via the column IGS_HE_SYS_RT_CL_FLD.SYSTEM_RETURN_CLASS_TYPE, joining on the primary key.
  • IGS_HE_USR_RTN_CLAS: This table stores the institution-specific, user-defined return classes (e.g., "2023-24 Undergraduate Student Return"). Each user-defined class must be associated with a predefined system type. It references IGS_HE_SYS_RTN_CLAS via the column IGS_HE_USR_RTN_CLAS.SYSTEM_RETURN_CLASS_TYPE.
Together, these objects form a hierarchy where IGS_HE_SYS_RTN_CLAS provides the top-level taxonomy, which is elaborated by IGS_HE_SYS_RT_CL_FLD and instantiated by IGS_HE_USR_RTN_CLAS.