Search Results sub_rtn_cal_id

Overview

The IGS.IGS_HE_SUB_RTN_CAL table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Higher Education (HE) product family. This table serves as a configuration and mapping repository for statutory reporting submissions. Its primary role is to define and store the specific academic calendars that must be considered when generating a particular data submission return for a government or regulatory body. By linking a submission return definition to one or more academic calendar instances, it ensures that student and institutional data is extracted from the correct time periods, which is a critical requirement for accurate compliance reporting in the education sector.

Key Information Stored

The table stores the linkage between a submission definition and the academic calendars it encompasses. Key columns include the composite unique identifier (SUB_RTN_CAL_ID) and the defining parameters of the submission itself: SUBMISSION_NAME, USER_RETURN_SUBCLASS, and RETURN_NAME. The connection to the academic calendar is established through the CAL_TYPE (Calendar Type) and CI_SEQUENCE_NUMBER (Calendar Instance Sequence Number). A significant functional column is FTE_PROG_PCNT, which holds the Full-Time Equivalent (FTE) program percentage value relevant to the submission for the specified calendar. Standard EBS "Who" columns (CREATED_BY, CREATION_DATE, etc.) track audit information. The table's unique indexes, IGS_HE_SUB_RTN_CAL_U1 and U2, enforce data integrity for the logical combination of submission and calendar and the primary key, respectively.

Common Use Cases and Queries

This table is central to the setup and execution of regulatory returns. A primary use case is during the pre-submission validation phase, where administrators verify that all required academic calendars are correctly associated with a submission. A common reporting query would list all calendars tied to a specific submission, which is essential for auditing and troubleshooting extraction logic.

Sample Query: Find all calendars for a specific submission:

SELECT submission_name,
       return_name,
       cal_type,
       ci_sequence_number,
       fte_prog_pcnt
FROM igs.igs_he_sub_rtn_cal
WHERE submission_name = '&SUBMISSION_NAME'
ORDER BY cal_type, ci_sequence_number;

Another critical use case involves data extraction programs. Batch processes for building a submission will join to this table using the submission name, return subclass, and return name to determine the precise set of calendar instances from which to source student enrollment, financial, or demographic data. The FTE_PROG_PCNT value may be applied directly in calculations for funding or statistical returns.

Related Objects

Based on the provided dependency information, the IGS_HE_SUB_RTN_CAL table is a foundational object referenced by the APPS synonym of the same name (APPS.IGS_HE_SUB_RTN_CAL). This synonym allows other EBS modules and custom code within the APPS schema to access the table without referencing the owning IGS schema directly. While the metadata indicates it does not reference other objects, it is logically and functionally dependent on the core academic calendar structures (likely such as IGS_CA_INST) to resolve the CAL_TYPE and CI_SEQUENCE_NUMBER. Furthermore, it is a key parent table for any submission-specific fact or transaction data tables that require the context of which calendar and submission a record belongs to for accurate reporting.