Search Results igs_av_adv_standing_all




Overview
Explore in AI Chat

Overview

The IGS_AV_ADV_STANDING_ALL table is a core data structure within the Oracle E-Business Suite (EBS) Student System module, specifically designed to manage advanced standing records. It serves as the master repository for recording exemptions or credits granted to a student (PERSON_ID) for a specific academic program (COURSE_CD and VERSION_NUMBER) based on prior learning or qualifications from an external institution (EXEMPTION_INSTITUTION_CD). This table is critical for tracking the outcome of advanced standing applications, enabling institutions to formally document and apply credit towards a student's degree requirements. It is important to note that the ETRM metadata explicitly labels the IGS - Student System as "Obsolete" and states this specific table is "Not implemented in this database," indicating it may represent a legacy data model from an earlier release or a reference structure not deployed in standard EBS 12.1.1/12.2.2 instances.

Key Information Stored

The table's structure is defined by its composite primary key, which uniquely identifies an advanced standing record. The key columns are PERSON_ID (linking to the student/party), COURSE_CD and VERSION_NUMBER (identifying the program of study), and EXEMPTION_INSTITUTION_CD (identifying the institution where the prior learning occurred). While the full column list is not provided in the excerpt, the primary and foreign key relationships imply the table stores the foundational header information for an advanced standing grant. This likely includes metadata such as the granting date, status, total credit awarded, and audit columns (e.g., CREATION_DATE, LAST_UPDATE_DATE). The table is designed with the "_ALL" suffix, conforming to the EBS multi-organization architecture, suggesting it contains a ORG_ID column for partitioning data by operating unit.

Common Use Cases and Queries

Primary use cases revolve around reporting and validating a student's advanced standing. Common operational queries would retrieve all exemptions for a specific student or program to advise on remaining requirements, or aggregate credits granted by external institution for transfer partnership analysis. A typical reporting query would join to related tables to present a comprehensible record.

  • Sample Query: Retrieving advanced standing header information for a student, joined with descriptive data from related tables.
    SELECT av.person_id, av.course_cd, av.version_number, av.exemption_institution_cd, ps.course_title, party.party_name
    FROM igs_av_adv_standing_all av,
        igs_ps_ver_all ps,
        hz_parties party
    WHERE av.person_id = :student_id
      AND av.course_cd = ps.course_cd
      AND av.version_number = ps.version_number
      AND av.person_id = party.party_id;

Related Objects

The ETRM metadata defines clear foreign key relationships, illustrating this table's position at the top of a hierarchy. It is a parent table to more granular detail tables and a child to master reference tables.

  • Parent Tables: IGS_PS_VER_ALL (Program/Version details) and HZ_PARTIES (Trading Community Person/Organization).
  • Child Tables: IGS_AV_STND_UNIT_LVL_ALL and IGS_AV_STND_UNIT_ALL. These tables hold the detailed unit-level exemptions (specific courses or unit groups) that roll up to the header record in IGS_AV_ADV_STANDING_ALL. Their foreign keys reference all columns of the parent table's primary key.