Search Results igs_as_non_enr_stdot_all




Overview
Explore in AI Chat

Overview

The IGS_AS_NON_ENR_STDOT_ALL table is a core data structure within the Oracle E-Business Suite Student System (IGS) module. It serves the critical function of recording academic outcomes for unit attempts where the student was not formally enrolled. This table is essential for managing scenarios such as cross-institutional study, advanced standing, or credit transfers, where a student receives a grade or result for work completed outside the standard enrollment framework of the institution. Its presence ensures a comprehensive academic history is maintained within the system, even for non-standard learning pathways. The table is owned by the IGS schema and is valid for both Oracle EBS releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to uniquely identify a specific unit offering and the associated student, then record the outcome. The primary key is a composite of five columns, ensuring a unique record for each non-enrolled unit attempt per student. Key columns include PERSON_ID, which links to the student's party record in HZ_PARTIES; UNIT_CD and VERSION_NUMBER, which identify the specific unit; and CAL_TYPE and CI_SEQUENCE_NUMBER, which define the academic calendar instance (teaching period) for the attempt. Additional columns, implied by the table's purpose, would typically store the outcome details, such as a final grade, result date, and source information, though these specific column names are not detailed in the provided metadata.

Common Use Cases and Queries

This table is primarily accessed for administrative reporting and student transcript generation. A common use case is compiling a complete academic record for a student that includes both enrolled and non-enrolled outcomes. System processes for calculating academic standing or verifying prerequisite satisfaction may also reference this table. A typical query would join this table to the unit and person tables to produce a readable report.

  • Sample Query: Retrieving non-enrolled outcomes for a specific person.

    SELECT non_enr.*, unit.unit_name
    FROM igs.igs_as_non_enr_stdot_all non_enr,
         igs.igf_aw_fa_base_rec_all party,
         igs.igs_ps_unit_ver_all unit
    WHERE non_enr.person_id = :person_id
    AND non_enr.person_id = party.party_id
    AND non_enr.unit_cd = unit.unit_cd
    AND non_enr.version_number = unit.version_number;

Related Objects

The table maintains critical referential integrity through its foreign key relationships. The primary foreign key links the PERSON_ID column to the HZ_PARTIES table in the Trading Community Architecture (TCA) foundation, which is the central repository for all person and organization entities in Oracle EBS. A second, multi-column foreign key links to the IGS_PS_UNIT_OFR_PAT_ALL table, which describes unit offering patterns. This relationship ties the non-enrolled outcome to a specific offering of a unit within a particular academic calendar and sequence. Consequently, any processes, views, or APIs that interact with student unit attempts or academic outcomes may reference or depend on IGS_AS_NON_ENR_STDOT_ALL to ensure data completeness.