Results for “user_return_subclass”

50+ results




Overview
Explore in AI Chat

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

Overview

IGS_HE_USR_RTN_CLAS is a table within the IGS (Student System) product schema of Oracle E-Business Suite, available in both 12.1.1 and 12.2.2. It holds user-defined return classes, which function as sub-classifications of the seeded system return classes. In the Oracle Student System, return classes are used to categorize the outcome or disposition of submitted records — for example, the reason a submission or record is returned for correction. The system return classes provide the fixed, Oracle-delivered category set, while IGS_HE_USR_RTN_CLAS lets institutions extend that model with their own institution-specific sub-classes. This allows finer-grained reporting and workflow routing without modifying seeded data.

From a data-modeling perspective, the heuristic Data Vault classification for this object is hub-leaning. This is a modeling suggestion derived from the foreign-key structure: the table has a single-column primary key (USER_RETURN_SUBCLASS) and one outbound reference to IGS_HE_SYS_RTN_CLAS, which is characteristic of a hub entity whose business key is stable and referenced by dependent tables. It is best treated as the authoritative registry of user-defined return sub-classes rather than as a transactional or link object.

Key Information Stored

The table contains 13 documented columns. The most significant are:

  • USER_RETURN_SUBCLASS — The business key and primary key column (enforced by IGS_HE_USR_RTN_CLAS_PK and also uniquely indexed by IGS_HE_USR_RTN_CLAS_U1/U2). It is the user-defined identifier for the sub-class and the value referenced by dependent tables.
  • SYSTEM_RETURN_CLASS_TYPE — The foreign key to IGS_HE_SYS_RTN_CLAS. It ties each user-defined sub-class back to the Oracle-seeded system return class it extends.
  • USR_RTN_CLAS_ID — A surrogate column carrying a unique index (IGS_HE_USR_RTN_CLAS_U1); it provides an alternate unique identifier distinct from the business key.
  • DESCRIPTION — The descriptive text of the user-defined return sub-class, used in list-of-values and reporting.
  • RECORD_ID and REC_ID_SEG1/SEG2/SEG3 — Record identification and segmented key columns supporting the Student System's record-keying scheme.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS WHO columns providing audit and concurrency information.

Note that the surrogate key (USR_RTN_CLAS_ID) and the business key (USER_RETURN_SUBCLASS) are distinct; joins from dependent tables use the business key, while the surrogate is available for internal uniqueness.

Common Use Cases and Queries

Typical uses include building validation lists, reporting returned submissions by sub-class, and reconciling user-defined classes against their system parents.

  • List user-defined sub-classes for a given system return class: SELECT USER_RETURN_SUBCLASS, DESCRIPTION FROM IGS_HE_USR_RTN_CLAS WHERE SYSTEM_RETURN_CLASS_TYPE = :sys_class;
  • Join to the system class to present the full hierarchy: SELECT u.USER_RETURN_SUBCLASS, u.DESCRIPTION, s.SYSTEM_RETURN_CLASS_TYPE FROM IGS_HE_USR_RTN_CLAS u JOIN IGS_HE_SYS_RTN_CLAS s ON u.SYSTEM_RETURN_CLASS_TYPE = s.SYSTEM_RETURN_CLASS_TYPE;
  • Report returned submissions by user sub-class by joining to IGS_HE_SUBMSN_RETURN on USER_RETURN_SUBCLASS.

Related Objects

  • IGS_HE_SYS_RTN_CLAS — Joined on SYSTEM_RETURN_CLASS_TYPE; the parent system return class table.
  • IGS_HE_SUBMSN_RETURN — References IGS_HE_USR_RTN_CLAS.USER_RETURN_SUBCLASS; stores returned submissions/records.
  • IGS_HE_USR_RT_CL_FLD — References IGS_HE_USR_RTN_CLAS.USER_RETURN_SUBCLASS; holds user return class field-level configuration.
  • IGS_HE_USR_RTN_CLAS_PK / _U1 / _U2 — Primary key and unique index constraints governing the table's identity.