Search Results igs_he_usr_rt_cl_fld




Overview
Explore in AI Chat

Overview

The IGS_HE_USR_RT_CL_FLD table is a core data structure within the Oracle E-Business Suite (EBS) Student System (IGS) module. It functions as a configuration table, specifically designed to support the creation of user-defined return classes for regulatory or institutional reporting. Its primary role is to store the specific data fields that a user selects to include within a custom return subclass. These user-defined fields are typically a curated subset of the broader set of fields available in the system-defined return class, allowing institutions to tailor their data extracts to meet precise external reporting requirements or internal analytical needs.

Key Information Stored

The table's structure is defined by its composite primary key, which enforces uniqueness for each field within a user-defined subclass. The key columns are USER_RETURN_SUBCLASS, which identifies the parent user-defined return class, and FIELD_NUMBER, which specifies the sequential identifier for an individual field included in that class. While the provided metadata does not list all columns, the table's purpose implies it likely contains columns to manage the field's display order, source mapping, or active status within the subclass. The data stored here is essentially a mapping between a custom report template (the user return subclass) and the discrete data elements from the Student System that populate it.

Common Use Cases and Queries

The primary use case is the generation of custom regulatory returns or institutional reports. Administrators use front-end forms to define a return class and select fields from a master list; this table persists those selections. A common technical operation is querying all fields configured for a specific return subclass to drive a data extraction program or validate a report definition. A sample SQL pattern to retrieve this configuration would be:

  • SELECT * FROM igs.igs_he_usr_rt_cl_fld WHERE user_return_subclass = '<SUBCLASS_CODE>' ORDER BY field_number;

This table is also critical for impact analysis when underlying system fields are modified, as reports or interfaces dependent on those fields can be identified by querying this table for the specific FIELD_NUMBER.

Related Objects

The table maintains a strict dependency relationship with the parent definition table for user return classes. As documented in the foreign key metadata:

  • IGS_HE_USR_RTN_CLAS: This is the primary related table. The column IGS_HE_USR_RT_CL_FLD.USER_RETURN_SUBCLASS is a foreign key referencing the IGS_HE_USR_RTN_CLAS table. This ensures that every field configuration record is linked to a valid, pre-defined user return subclass. Any join between these tables would typically use USER_RETURN_SUBCLASS as the key column.

While not explicitly listed in the provided excerpt, this table is logically a child of the system return class field definitions (likely a table such as IGS_HE_SYS_RT_CL_FLD), from which the selectable FIELD_NUMBER values are derived.