Search Results igs_av_stnd_unit_all




Overview
Explore in AI Chat

Overview

The IGS_AV_STND_UNIT_ALL table is a core data structure within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically designed to manage advanced standing (also known as credit transfer or exemptions). It stores detailed records for individual academic units (subjects or courses) that have been granted to a student as advanced standing towards a specific program of study. This table functions as a child entity, linking the broader advanced standing record (IGS_AV_ADV_STANDING_ALL) to the specific unit and version for which credit is awarded. It is critical for auditing the composition of a student's advanced standing and for ensuring accurate academic progression and credential evaluation. Notably, the ETRM metadata classifies the IGS - Student System product as "Obsolete," indicating this table is part of a legacy codebase that may be superseded in later application versions or deployments.

Key Information Stored

The table's primary key (IGS_AV_STND_UNIT_PK) is the surrogate key AV_STND_UNIT_ID. Its unique key (IGS_AV_STND_UNIT_UK) reveals the core business identifiers that define a specific granted unit: PERSON_ID, AS_COURSE_CD, AS_VERSION_NUMBER, S_ADV_STND_TYPE, UNIT_CD, VERSION_NUMBER, and EXEMPTION_INSTITUTION_CD. This combination ensures a student cannot be granted the same unit version for the same course and advanced standing type more than once. Other significant columns include UNIT_DETAILS_ID, which links to specific unit offering details (IGS_AD_TERM_UNITDTLS), and TST_RSLT_DTLS_ID, which links to test result details (IGS_AD_TST_RSLT_DTLS) if the standing was granted based on a standardized test. The table also stores grading information via GRADING_SCHEMA_CD, GRD_SCH_VERSION_NUMBER, and GRADE, linking to IGS_AS_GRD_SCH_GRADE.

Common Use Cases and Queries

This table is central to reporting and operational processes related to credit transfer. A common use case is generating a transcript of advanced standing, detailing all units granted to a student for a particular course. System interfaces for importing external credit recommendations would ultimately populate this table. Administrators query this table to verify unit exemptions before student enrollment or to audit credit compliance. A typical reporting query would join to the parent advanced standing and unit master tables:

  • SELECT iaa.person_id, iaa.as_course_cd, isu.unit_cd, isu.version_number, isu.title, iau.grade FROM igs_av_stnd_unit_all iau JOIN igs_av_adv_standing_all iaa ON iau.person_id = iaa.person_id AND iau.as_course_cd = iaa.as_course_cd JOIN igs_ps_unit_ver_all isu ON iau.unit_cd = isu.unit_cd AND iau.version_number = isu.version_number WHERE iaa.person_id = :p_student_id;

Another critical process is checking for duplicate advanced standing unit grants before inserting a new record, utilizing the unique key constraints.

Related Objects

As indicated by the foreign key relationships, IGS_AV_STND_UNIT_ALL has extensive dependencies. It is a direct child of the IGS_AV_ADV_STANDING_ALL table, which holds the overarching advanced standing application. The granted unit is defined by a link to the IGS_PS_UNIT_VER_ALL (unit catalog) table. Specific details are further referenced via IGS_AD_TERM_UNITDTLS and IGS_AD_TST_RSLT_DTLS. The granted grade references IGS_AS_GRD_SCH_GRADE. Furthermore, IGS_AV_STND_UNIT_ALL acts as a parent table to several supporting entities:

These relationships form a detailed data model for tracking every facet of a student's advanced standing unit credits.