Search Results igs_av_stnd_unit_lvl_all




Overview
Explore in AI Chat

Overview

The table IGS_AV_STND_UNIT_LVL_ALL is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 Student System (IGS). It serves as a detailed transactional repository for managing and recording advanced standing (also known as credit transfer or exemption) at a granular academic level. Specifically, it stores the number of credit points granted to a student for a specific unit level (e.g., undergraduate, postgraduate) as part of an advanced standing assessment. This table operates within a multi-org architecture, as indicated by the '_ALL' suffix, meaning it can store data for multiple operating units. Its primary role is to break down a student's total advanced standing award into its constituent academic levels, enabling precise academic planning, audit trails, and compliance reporting for credit transfer policies.

Key Information Stored

The table's structure captures the essential dimensions of a leveled credit award. Its primary and unique keys enforce data integrity for a student's advanced standing record. Key columns include AV_STND_UNIT_LVL_ID (the surrogate primary key), PERSON_ID (the student), and AS_COURSE_CD with AS_VERSION_NUMBER (the course version for which credit is granted). The S_ADV_STND_TYPE defines the category of advanced standing, while UNIT_LEVEL specifies the academic level of the exempted credits. The CRS_GROUP_IND likely indicates if the credit applies to a course group. Critical foreign key columns such as UNIT_DETAILS_ID, TST_RSLT_DTLS_ID, and QUAL_DETS_ID link to the specific source details—whether from prior institutional study, standardized test results, or other qualifications—that justified the credit award at this level. The EXEMPTION_INSTITUTION_CD links to the institution that provided the original learning.

Common Use Cases and Queries

This table is central to reporting and processes involving detailed credit analysis. A common use case is generating an audit report of all advanced standing credits granted, broken down by academic level, for a specific student or cohort. Administrators may query it to verify that credit limits per level have not been exceeded for a given course. It is also crucial for producing official academic transcripts that itemize exempted credits by level. A typical reporting query would join this table to the student (IGS_PE_PERSON) and course (IGS_PS_COURSE) tables to summarize granted credit points.

SELECT asul.person_id,
       asul.as_course_cd,
       asul.unit_level,
       SUM(granted_credit_points) -- Assuming a credit point column
FROM   igs_av_stnd_unit_lvl_all asul
WHERE  asul.person_id = :student_id
GROUP BY asul.person_id, asul.as_course_cd, asul.unit_level;

Another critical scenario is during the advanced standing application process, where the system creates or updates records in this table to store the leveled breakdown of an approved credit award.

Related Objects

The table maintains defined foreign key relationships with several other IGS tables, forming a key part of the Student System's data model for advanced standing. These relationships are:

  • IGS_AV_ADV_STANDING_ALL: The parent header table for the advanced standing application. Joined via PERSON_ID, AS_COURSE_CD, AS_VERSION_NUMBER, and EXEMPTION_INSTITUTION_CD.
  • IGS_PS_UNIT_LEVEL_ALL: Provides the valid list of academic UNIT_LEVEL codes.
  • IGS_AD_TST_RSLT_DTLS: Links to detailed test result records (TST_RSLT_DTLS_ID) that form the basis for the credit.
  • IGS_AD_TERM_UNITDTLS: Links to detailed prior unit/term records (UNIT_DETAILS_ID) that form the basis for the credit.
  • IGS_UC_QUAL_DETS: Links to detailed qualification records (QUAL_DETS_ID) that form the basis for the credit.
  • IGS_AV_STD_ULVLBASIS_ALL: A child table that references this table's primary key (AV_STND_UNIT_LVL_ID), likely storing further basis details for the leveled award.