Results for “igs_he_sys_rtn_clas”

26 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGS_HE_SYS_RTN_CLAS table belongs to the IGS (Student System) product family within Oracle E-Business Suite. It stores the predefined Return Classes available to the higher-education student system, specifically the categories Student Return, Module Return, and Combined Return. These classifications are used by the student records functionality to determine the return type that applies to a given student, module, or combined academic scenario — most commonly in the context of statutory or institutional return reporting, enrolment returns, and related regulatory submissions.

The table is flagged as obsolete in the documented ETRM metadata, and the implementation note states that it is "Not implemented in this database." Consequently, in a typical Oracle EBS 12.1.1 or 12.2.2 environment, the object may be absent from the physical schema or may exist only as a legacy remnant. It should be regarded as a reference table describing a controlled vocabulary rather than a transactional entity.

From a heuristic Data Vault modelling perspective, the table is classified as hub-leaning. Physically, a hub represents a distinct business concept identified by a business key. Here, the unique index IGS_HE_SYS_RTN_CLAS_U1 on SYSTEM_RETURN_CLASS_TYPE, together with the primary key constraint IGS_HE_SYS_RTN_CLAS_PK, strongly implies a candidate hub keyed by the return class type.

Key Information Stored

The documented physical schema comprises eight columns. The most significant are:

  • SYSTEM_RETURN_CLASS_TYPE — The business key and unique identifier for each return class. This is enforced by the unique index IGS_HE_SYS_RTN_CLAS_U1 and forms the PK column of IGS_HE_SYS_RTN_CLAS_PK. It holds the code distinguishing Student Return, Module Return, and Combined Return.
  • SYSTEM_RETURN_CLASS_RECID — A surrogate/record identifier associated with the return class. In EBS record-ID conventions this typically acts as an internal, system-generated reference.
  • DESCRIPTION — A human-readable description of the return class.
  • CREATED_BY, CREATION_DATE — Standard WHO audit columns recording the creating user and creation timestamp.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns capturing the last modifying user, update timestamp, and login context.

The unique index on SYSTEM_RETURN_CLASS_TYPE is the key business-key candidate, while SYSTEM_RETURN_CLASS_RECID serves as the surrogate reference. The distinction matters for downstream joins, where the FK relationships reference SYSTEM_RETURN_CLASS_TYPE rather than the surrogate.

Common Use Cases and Queries

Because this table supplies reference values for return classification, reporting and validation queries most often resolve the return class type against its dependents. A typical lookup to enumerate available return classes is:

  • SELECT SYSTEM_RETURN_CLASS_TYPE, DESCRIPTION FROM IGS_HE_SYS_RTN_CLAS ORDER BY SYSTEM_RETURN_CLASS_TYPE;
  • Resolving field-level configuration: join to IGS_HE_SYS_RT_CL_FLD on SYSTEM_RETURN_CLASS_TYPE to see which fields each return class exposes.
  • Resolving user-defined overrides: join to IGS_HE_USR_RTN_CLAS on SYSTEM_RETURN_CLASS_TYPE to compare system return classes with any user-defined counterparts.

Reporting scenarios include validating that all configured return classes in downstream clinical or submission tables resolve to a predefined value. A common integrity check is a LEFT JOIN from the dependent table back to IGS_HE_SYS_RTN_CLAS on SYSTEM_RETURN_CLASS_TYPE, filtering for NULLs to identify orphaned references. Given the obsolete status, extraction queries should be guarded with existence checks against ALL_TABLES before execution in 12.1.1 or 12.2.2.

Related Objects

The documented foreign key structure identifies two dependent tables that reference this object on SYSTEM_RETURN_CLASS_TYPE:

  • IGS_HE_SYS_RT_CL_FLD — References IGS_HE_SYS_RTN_CLAS via IGS_HE_SYS_RT_CL_FLD.SYSTEM_RETURN_CLASS_TYPE. This table holds the field definitions associated with each system return class.
  • IGS_HE_USR_RTN_CLAS — References IGS_HE_SYS_RTN_CLAS via IGS_HE_USR_RTN_CLAS.SYSTEM_RETURN_CLASS_TYPE. This table holds user-defined return class definitions that build upon the predefined system values.

Both relationships confirm the hub-leaning classification: the return class type acts as a shared business key consumed by field-level and user-level satellite-style tables. The primary key constraint IGS_HE_SYS_RTN_CLAS_PK enforces uniqueness on SYSTEM_RETURN_CLASS_TYPE, ensuring referential integrity for these dependents. No additional views or APIs are documented in the supplied metadata, and any reliance on this object should account for its obsolete, potentially unimplemented state in EBS 12.1.1 and 12.2.2.