Search Results igs_az_students




Overview
Explore in AI Chat

Overview

The IGS_AZ_STUDENTS table is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS). It functions as the central repository for managing the association between students and academic advising groups. Its primary role is to store and maintain the specific details that link a student to an advising group, which is a fundamental construct for organizing academic advising, tracking student progress, and managing advising-related holds within the institution. This table is essential for operational processes in student advising and support services.

Key Information Stored

The table's structure is designed to capture the relationship between a student and an advising entity, along with any associated conditions. While the full column list is not detailed in the provided excerpt, the documented foreign keys and primary key reveal critical data points. The primary key, GROUP_STUDENT_ID, uniquely identifies each student-to-group association record. Crucially, the table stores the STUDENT_PERSON_ID, which links to the core person record in the system. It also holds data related to advising holds, specifically the ADVISING_HOLD_TYPE and the HOLD_START_DATE, indicating this table is instrumental in tracking and enforcing academic advising restrictions or requirements for students within specific groups.

Common Use Cases and Queries

This table is primarily accessed for reporting and operational queries related to student advising. Common use cases include generating rosters of students assigned to a particular advisor or advising group, identifying students with active advising holds, and analyzing advising group composition. A typical query might join IGS_AZ_STUDENTS to the person base table (IGS_PE_PERSON) to retrieve student names and details for a specific group. Another frequent pattern is to query for students with a specific hold type to facilitate outreach or compliance reporting.

  • Sample Query (Students in a Group): SELECT s.STUDENT_PERSON_ID, p.LAST_NAME, p.FIRST_NAME FROM IGS_AZ_STUDENTS s, IGS_PE_PERSON p WHERE s.STUDENT_PERSON_ID = p.PERSON_ID AND s.GROUP_ID = :p_group_id;
  • Sample Query (Active Holds): SELECT * FROM IGS_AZ_STUDENTS WHERE ADVISING_HOLD_TYPE IS NOT NULL AND HOLD_START_DATE > SYSDATE - 365;

Related Objects

The IGS_AZ_STUDENTS table has defined relationships with other key EBS tables, as indicated by its foreign keys. The most significant relationship is with the IGS_PE_PERS_ENCUMB (Person Encumbrance) table, linked via the columns STUDENT_PERSON_ID, ADVISING_HOLD_TYPE, and HOLD_START_DATE. This suggests that advising holds managed in IGS_AZ_STUDENTS are formally implemented as person encumbrances within the broader Student System. The table is also inherently related to the underlying advising group definition table (likely named IGS_AZ_GROUP or similar) via a foreign key for GROUP_ID, though this specific key was not listed in the excerpt. Any custom or standard reports on advising group membership will depend on this table.