Search Results igs_st_govt_semester_u1

Overview

The IGS_ST_GOVT_SEMESTER table is a configuration table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) product under the IGS (iGrants) schema. Its primary role is to define the mapping between an institutional academic semester and the official government reporting semester for higher education data collections. This mapping is critical for regulatory compliance, ensuring student unit attempt data captured in enrollment statistics snapshots is correctly assigned to one of the five standardized government semesters as defined by national higher education reporting requirements, such as Element 353 of the relevant data collection specification.

Key Information Stored

The table stores a unique combination of submission context and semester mapping. The key columns are SUBMISSION_YR (the reference year for the data collection), SUBMISSION_NUMBER (identifying a specific submission instance, typically 1, 2, or 3 for an enrollment statistics snapshot), and GOVT_SEMESTER (the government semester code, 1 through 5, to which the data is assigned). This three-column combination is enforced by the unique index IGS_ST_GOVT_SEMESTER_U1. Standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track audit information for each record. The table does not store descriptive names for the semesters; it holds the essential mapping keys required for accurate reporting.

Common Use Cases and Queries

The primary use case is configuring and validating the setup for government statutory reporting processes within Student Management. Administrators use this table to define which institutional data rolls up into which government reporting period. A common operational query would retrieve the current mapping for a specific submission year and snapshot to verify setup before a data extract. For reporting and integration, a typical query joins this table to enrollment or unit attempt data filtered by the same SUBMISSION_YR and SUBMISSION_NUMBER to assign the correct GOVT_SEMESTER code to each student record for the submission file.

SELECT gs.SUBMISSION_YR,
       gs.SUBMISSION_NUMBER,
       gs.GOVT_SEMESTER,
       gs.CREATION_DATE
FROM IGS.IGS_ST_GOVT_SEMESTER gs
WHERE gs.SUBMISSION_YR = 2024
ORDER BY gs.SUBMISSION_NUMBER, gs.GOVT_SEMESTER;

Related Objects

Based on the provided dependency information, the IGS_ST_GOVT_SEMESTER table is a referenced object, indicating it is likely a parent table in a foreign key relationship. The metadata specifies it "is referenced by" an object named IGS_ST_GOVT_SEMESTER under the APPS synonym. This suggests the existence of another table, view, or interface that uses the unique key (SUBMISSION_YR, SUBMISSION_NUMBER, GOVT_SEMESTER) from this table to validate or categorize student enrollment data for government reporting. This related object would join on these three key columns to pull the correct government semester context for student records.