Search Results tr_org_unit_cd

Overview

The IGS_ST_GVT_STDNTLOAD table is a core data entity within the Oracle E-Business Suite Student System (IGS) module. It serves a critical regulatory reporting function by storing a historical snapshot of a student's academic load details as captured on a specific census date. This data is essential for generating government submissions, specifically the Student Load File, which is used for official reporting and funding purposes in jurisdictions like Australia. The table acts as an audit trail and transactional repository, ensuring that the precise load information submitted to government bodies is permanently recorded and can be reconciled within the system.

Key Information Stored

The table's structure is defined by a complex composite primary key that uniquely identifies a single student unit attempt record within a specific government submission cycle. Key columns include identifiers for the submission itself (SUBMISSION_YR, SUBMISSION_NUMBER), the student (PERSON_ID), their course (COURSE_CD), and the specific unit attempt. The unit attempt is detailed by the unit code (UNIT_CD), calendar instance (SUA_CAL_TYPE, SUA_CI_SEQUENCE_NUMBER), and location (SUA_LOCATION_CD). Academic classification fields are crucial for reporting, including the UNIT_CLASS, the institution's internal DISCIPLINE_GROUP_CD, and the government-mapped GOVT_DISCIPLINE_GROUP_CD. The GOVT_SEMESTER indicates the reporting period, and the teaching responsibility organization (TR_ORG_UNIT_CD, TR_OU_START_DT) is also captured.

Common Use Cases and Queries

The primary use case is the generation, validation, and audit of mandatory government student load reports. Administrators query this table to verify past submissions, investigate data discrepancies, and support funding audits. Common SQL patterns involve filtering by submission parameters and joining to person or course tables for detailed reporting.

• Retrieving a Full Submission: SELECT * FROM igs.igs_st_gvt_stdntload WHERE submission_yr = '2024' AND submission_number = 1;
• Auditing Student Load by Discipline: Queries often group by GOVT_DISCIPLINE_GROUP_CD and UNIT_CLASS to summarize load for funding models.
• Reconciliation Reporting: Comparing live system data against the frozen census snapshot in this table to ensure submission accuracy.

Related Objects

The table maintains a direct foreign key relationship to the IGS_ST_GOVT_SEMESTER table, which defines the valid government reporting periods. The join is made on the combination of SUBMISSION_YR, SUBMISSION_NUMBER, and GOVT_SEMESTER. This ensures every student load record is associated with an approved submission period. The table is also fundamentally related to core student system tables such as IGS_PE_PERSON (for PERSON_ID), IGS_PS_UNIT (for UNIT_CD), and IGS_PS_COURSE (for COURSE_CD), though these are typically accessed via the underlying transactional data that was snapshotted, rather than through direct foreign keys in this historical table.