Search Results igs_he_submsn_return




Overview
Explore in AI Chat

Overview

The IGS_HE_SUBMSN_RETURN table is a core data structure within the Oracle E-Business Suite (EBS) Student System (IGS), specifically designed to manage statutory data submissions. Its primary function is to define and store the specific data returns (or reports) that are configured for a given submission entity. A submission typically corresponds to a mandatory data collection exercise for a regulatory body, such as the Higher Education Statistics Agency (HESA) in the UK or similar organizations globally. This table acts as a junction, linking a high-level submission definition to the detailed, user-defined return specifications that must be generated and submitted as part of that exercise. Its role is critical for ensuring that the correct set of returns is accurately associated with each submission cycle in releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies each configured return within a submission. The key columns are SUBMISSION_NAME, which references the parent submission header; USER_RETURN_SUBCLASS, which categorizes the type of return; and RETURN_NAME, which is the specific identifier for the return instance. While the provided metadata does not list non-key columns, the table's purpose implies it likely holds configuration flags or control attributes for each return, such as status indicators, processing sequence, or versioning information. The integrity of the data is enforced through foreign key relationships to the submission header (IGS_HE_SUBMSN_HEADER) and the user return class definition table (IGS_HE_USR_RTN_CLAS).

Common Use Cases and Queries

This table is central to setup and operational reporting for statutory submissions. A common administrative use case is querying all returns defined for an upcoming submission to verify configuration completeness. For example:
SELECT submission_name, user_return_subclass, return_name FROM igs.igs_he_submsn_return WHERE submission_name = 'HESA_STUDENT_2023';
During submission processing, the system references this table to determine which return programs or extracts must be executed. Technical consultants often join this table with related detail tables (e.g., IGS_HE_SUB_RTN_QUAL for qualification rules) to analyze or debug the full return definition. Reporting use cases include generating audit trails of all returns associated with historical submissions for compliance purposes.

Related Objects

The IGS_HE_SUBMSN_RETURN table is a pivotal reference point within the submission architecture. It has a direct parent-child relationship with IGS_HE_SUBMSN_HEADER. Crucially, it is referenced as a foreign key by several key detail tables that define the specific parameters for each return, including IGS_HE_SUB_RTN_CAL (for calendar rules), IGS_HE_SUB_RTN_QUAL (for qualification rules), and IGS_HE_EXT_RUN_DTLS (which likely stores execution details for external runs of the return). This network of relationships positions IGS_HE_SUBMSN_RETURN as the central hub connecting the submission definition to the granular rules and runtime logs that govern each individual data return.