Search Results igs_st_gvtsemload_ca




Overview
Explore in AI Chat

Overview

The table IGS_ST_GVTSEMLOAD_CA is a data structure within the Oracle E-Business Suite (EBS) Student System (IGS), specifically noted as obsolete in the provided documentation for versions 12.1.1 and 12.2.2. Its core function is to model the relationship between academic calendars and government reporting periods. It defines which specific Load Calendars (academic calendar instances) contribute to and are aggregated within a defined government semester for official reporting purposes. This table acts as a critical junction, linking the configuration of academic terms with the structured reporting requirements mandated by governmental education bodies.

Key Information Stored

The table's structure is defined by composite primary and foreign keys that enforce data integrity for these relationships. The primary data points stored are identifiers that link records across related tables. Key columns include SUBMISSION_YR and SUBMISSION_NUMBER, which uniquely identify a government submission cycle. The GOVT_SEMESTER column specifies the semester within that submission period. Crucially, the CAL_TYPE and CI_SEQUENCE_NUMBER columns together identify the exact calendar instance (e.g., "SEM-1 2024") that is considered part of the load for the specified government semester. The existence of two documented primary key constraints (GSLC_UK and IGS_ST_GVTSEMLOAD_CA_PK) suggests an evolution in the table's design, with the latter including GOVT_SEMESTER for a more granular unique identifier.

Common Use Cases and Queries

The primary use case for this table is supporting the generation of government-compliant reports on student enrollment load and activity per semester. A typical query would retrieve all contributing calendar instances for a specific reporting period to aggregate student unit attempt records. For example, to list all load calendars for a given submission year and semester, one might use:

  • SELECT cal_type, ci_sequence_number FROM igs_st_gvtsemload_ca WHERE submission_yr = :p_year AND govt_semester = :p_sem;

Conversely, to identify the government semester to which a specific academic calendar belongs for reporting, a join to IGS_ST_GOVT_SEMESTER would be necessary. Given the module's obsolete status, direct interaction with this table is typically limited to legacy data validation, migration projects, or supporting historical reports.

Related Objects

IGS_ST_GVTSEMLOAD_CA does not exist in isolation; it is defined by its relationships to core calendar and government reporting tables, as documented by its foreign keys.

  • IGS_CA_INST_ALL: The table references this calendar instance table via the columns CAL_TYPE and CI_SEQUENCE_NUMBER. This join retrieves the detailed start/end dates and description of the contributing academic period.
  • IGS_ST_GOVT_SEMESTER: The table references this government semester definition table via the columns SUBMISSION_YR, SUBMISSION_NUMBER, and GOVT_SEMESTER. This join provides the context and official parameters of the government reporting period to which the calendars are mapped.

These relationships are essential for any query or report that needs to traverse from a specific academic calendar to its government reporting context or vice versa.