Search Results igs_st_gvt_stdntload_n1

Overview

The IGS_ST_GVT_STDNTLOAD table is a core data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 Student Management module. It serves a critical regulatory reporting function by storing a historical snapshot of a student's academic load as captured on a government-mandated census date for a specific reporting submission. The table acts as the system of record for generating official student load files submitted to government bodies, ensuring compliance with funding and statistical reporting requirements. Each record encapsulates the load details for a single student unit attempt within a specific government semester and submission cycle.

Key Information Stored

The table's structure is defined by a highly granular composite primary key, reflecting the multi-faceted nature of government reporting. Key columns include identifiers for the submission itself (SUBMISSION_YR, SUBMISSION_NUMBER), the student (PERSON_ID), and their program of study (COURSE_CD, CRV_VERSION_NUMBER). Crucially, it details the specific unit attempt, using the combination of UNIT_CD, SUA_CAL_TYPE, and SUA_CI_SEQUENCE_NUMBER to uniquely identify it. The SUA_CI_SEQUENCE_NUMBER, referenced in the user's search, is integral to this identification, denoting the sequence of the teaching calendar instance for that unit attempt. Additional columns capture reporting context such as the GOVT_SEMESTER, teaching responsibility (TR_ORG_UNIT_CD, TR_OU_START_DT), and classified discipline groups (DISCIPLINE_GROUP_CD, GOVT_DISCIPLINE_GROUP_CD).

Common Use Cases and Queries

The primary use case is the generation and audit of government submissions. Administrators query this table to verify the data extracted for a submission, reconcile reported figures, and investigate historical load records. A common query pattern involves filtering by submission parameters and student or unit details. For example, to retrieve all load records for a specific student and unit attempt across submissions, one might use a query leveraging the NONUNIQUE index IGS_ST_GVT_STDNTLOAD_N1:

• SELECT * FROM IGS.IGS_ST_GVT_STDNTLOAD WHERE PERSON_ID = &student_id AND UNIT_CD = '&unit_code' AND SUA_CI_SEQUENCE_NUMBER = &sequence_num;

Another critical reporting use case is analyzing load by discipline group or teaching organization for a given government semester, utilizing indexes N2, N4, or N5.

Related Objects

The table maintains defined relationships with other key EBS objects. Its complex primary key is enforced by the IGS_ST_GVT_STDNTLOAD_PK index. As per the provided dependency information, a foreign key relationship exists where the SUBMISSION_YR column references the IGS_ST_GOVT_SEMESTER table, linking the load record to valid government semester definitions. The table is also the likely target for foreign key references from other government reporting detail or summary tables (not explicitly listed in the provided metadata). The suite of non-unique indexes (N1 through N5) are essential for optimizing performance of queries based on student/unit details, government semester, teaching organization, or discipline groups.