Search Results igs_av_std_unt_basis_all




Overview
Explore in AI Chat

Overview

The table IGS_AV_STD_UNT_BASIS_ALL is a core data object within the Oracle E-Business Suite Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It serves a critical function in the management of academic advanced standing, also known as credit transfer or recognition of prior learning. The table's primary purpose is to store and describe the specific academic basis or rationale upon which a unit of study has been granted as advanced standing to a student. This forms an essential part of the official academic record, documenting the justification for awarding credit, which is vital for audit trails, academic policy compliance, and student advisement.

Key Information Stored

While the full column list is not provided in the metadata, the documented primary and foreign keys reveal the core data structure. The central column is AV_STND_UNIT_ID, which is the table's primary key and uniquely identifies each record describing a basis for advanced standing. This column is a foreign key to the IGS_AV_STND_UNIT_ALL table, linking the basis information directly to a specific granted advanced standing unit record. Another critical column is BASIS_COURSE_TYPE, which is a foreign key to the IGS_PS_TYPE_ALL (Program/Course Type) table. This indicates that the basis for granting credit is often tied to the type of program or course from which the credit originated, such as a specific diploma or certificate type. The table likely contains additional descriptive columns to elaborate on the basis, which may include references to source institutions, specific prior learning assessments, or exemption rule codes.

Common Use Cases and Queries

This table is primarily accessed for detailed reporting and validation of advanced standing awards. A common use case is generating an audit report for a student's transcript that lists not only the units granted as credit but also the official reason for each grant. Administrators may query this table to ensure that all awarded advanced standing has a documented, valid basis as per institutional policy. A typical SQL pattern involves joining to the main advanced standing unit table to get student and unit details.

Sample Query Pattern:
SELECT stu.person_id, avu.unit_cd, basis.basis_course_type, ps_type.description
FROM igs_av_std_unt_basis_all basis,
igs_av_stnd_unit_all avu,
igs_ps_type_all ps_type
WHERE basis.av_stnd_unit_id = avu.av_stnd_unit_id
AND basis.basis_course_type = ps_type.course_type(+);

Related Objects

The table IGS_AV_STD_UNT_BASIS_ALL has defined relationships with two key parent tables, as per the provided metadata:

  • IGS_AV_STND_UNIT_ALL: This is the primary parent table. The relationship is established via the foreign key column IGS_AV_STD_UNT_BASIS_ALL.AV_STND_UNIT_ID referencing IGS_AV_STND_UNIT_ALL. This links each basis record to its corresponding advanced standing unit award.
  • IGS_PS_TYPE_ALL: This table provides context for the type of program used as the basis for credit. The relationship is via the foreign key column IGS_AV_STD_UNT_BASIS_ALL.BASIS_COURSE_TYPE referencing IGS_PS_TYPE_ALL. This validates and describes the course type associated with the credit basis.