Search Results igs_av_std_ulvlbasis_all




Overview
Explore in AI Chat

Overview

The IGS_AV_STD_ULVLBASIS_ALL table is a core data structure within the Oracle E-Business Suite Student System (IGS) for releases 12.1.1 and 12.2.2. It functions as a detailed supporting table for the Advanced Standing (Credit Transfer) module. Its primary role is to store and describe the specific academic basis or rationale on which a unit-level credit exemption has been granted to a student. This table provides the granular justification linking a student's prior learning or experience to the specific unit level requirements of their current course of study, enabling accurate audit trails and detailed reporting on credit decisions.

Key Information Stored

The table's central purpose is to define the basis for a granted unit level. Its structure is anchored by a foreign key relationship to the main advanced standing unit level record. The most critical column is AV_STND_UNIT_LVL_ID, which is the table's primary key and links directly to a record in IGS_AV_STND_UNIT_LVL_ALL. Another significant column is BASIS_COURSE_TYPE, a foreign key referencing IGS_PS_TYPE_ALL, which documents the specific course type that formed the basis for the credit award. While the provided metadata specifies these core columns, typical implementations may also include fields for basis details, effective dates, and creation/modification audit information, aligning with the standard Oracle EBS table design pattern.

Common Use Cases and Queries

This table is essential for generating detailed audit reports on advanced standing grants and for supporting administrative reviews of credit transfer decisions. A common operational use case involves querying all justifications for credits granted within a specific academic period or for a particular course type. For example, an administrator might need to list all unit-level credits granted based on a specific prior course type. A typical SQL query would join this table to its parent to retrieve student and unit information.

  • Sample Query Pattern: SELECT basis.*, ulvl.person_id, ulvl.unit_cd FROM igs_av_std_ulvlbasis_all basis JOIN igs_av_stnd_unit_lvl_all ulvl ON basis.av_stnd_unit_lvl_id = ulvl.av_stnd_unit_lvl_id WHERE basis.basis_course_type = '<COURSE_TYPE_CODE>';
  • Reporting Use Case: Analyzing the distribution of credit transfer justifications across different student cohorts or academic programs to inform policy decisions.

Related Objects

The IGS_AV_STD_ULVLBASIS_ALL table exists within a defined hierarchy of Student System tables and has explicit foreign key dependencies as documented in the ETRM.

  • Primary Parent Table (Foreign Key): IGS_AV_STND_UNIT_LVL_ALL. This is the core table for unit-level advanced standing records. The join is made on the column IGS_AV_STD_ULVLBASIS_ALL.AV_STND_UNIT_LVL_ID.
  • Reference Table (Foreign Key): IGS_PS_TYPE_ALL. This table stores valid course/program types. The join is made on the column IGS_AV_STD_ULVLBASIS_ALL.BASIS_COURSE_TYPE to validate and describe the course type used as the basis for credit.