Search Results igs_az_advisors




Overview
Explore in AI Chat

Overview

The IGS_AZ_ADVISORS 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 relationship between academic advisors and the advising groups to which they are assigned. In the context of student administration, advising groups are logical collections used to organize and assign academic advising responsibilities. This table, therefore, is critical for configuring and maintaining the advising structure, enabling institutions to define which staff members serve as advisors within specific groups, which in turn supports student advising workflows, appointment scheduling, and academic progress tracking.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary key and description indicate its fundamental structure. The central identifier is the GROUP_ADVISOR_ID, which serves as the unique primary key (IGS_AZ_ADVISORS_PK) for each advisor-to-group assignment record. Each record will logically contain foreign key references to at least two other entities: a specific advisor (likely a person or staff ID from a person or employee table) and a specific advising group (from a related advising group table). Additional columns would typically store metadata such as the effective start and end dates of the assignment, the advisor's role or type within the group, and creation/modification audit information (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE).

Common Use Cases and Queries

This table is primarily accessed for administrative setup and operational reporting within the Student System. Common use cases include generating advisor rosters for advising groups, validating advisor assignments during student appointment booking, and producing reports on advisor workloads. A typical query might join IGS_AZ_ADVISORS to person and advising group tables to list all active advisors within a department. For example:

  • Identifying all advisors in a specific group: SELECT * FROM igs_az_advisors WHERE advising_group_id = :group_id AND SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE);
  • Reporting the advising group structure: SELECT ag.group_name, p.last_name, p.first_name FROM igs_az_advisors a, igs_az_advising_groups ag, per_all_people_f p WHERE a.advising_group_id = ag.group_id AND a.person_id = p.person_id ORDER BY ag.group_name;

Related Objects

As a foundational table in the advising module, IGS_AZ_ADVISORS has key relationships with other IGS objects. It is directly dependent on the table defining advising groups, likely named IGS_AZ_ADVISING_GROUPS, and a core person table, such as PER_ALL_PEOPLE_F. It is also a probable parent table to transactional data, such as student advising session records or appointment bookings, which would store a GROUP_ADVISOR_ID to link a student interaction to a specific advisor assignment. Views or APIs for managing advising functionality, such as IGS_AZ_ADVISOR_PKG, would perform DML operations on this table.