Search Results igs_az_advising_rels_pk

Overview

The IGS_AZ_ADVISING_RELS table is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically in versions 12.1.1 and 12.2.2. It serves as the central repository for managing formal advising relationships within the institution. Its primary role is to store and maintain the defined combinations of students and their assigned advisors, organized within the framework of different advising groups. This table is essential for enabling structured academic guidance, ensuring that each student can be linked to the appropriate faculty or staff member responsible for providing counsel across various academic contexts, such as by major, college, or special program.

Key Information Stored

While the full column list is proprietary, the documented metadata indicates the table's structure is built around a unique identifier for each advising relationship. The primary key, GROUP_ADVISING_REL_ID, is a system-generated sequence that uniquely identifies every student-advisor pairing within a specific advising group. Based on its description and standard EBS design patterns, the table would logically contain foreign key columns to reference the student (likely from IGS_PE_PERSON), the advisor (also from a person or party table), and the specific advising group (likely from a table like IGS_AZ_ADVISING_GROUP). It would also include control columns such as creation date, created by, last update date, and last updated by to support auditing and data integrity.

Common Use Cases and Queries

This table is fundamental for processes related to academic advising. Common use cases include generating advisor assignment reports for departments, providing a data source for student portals to display assigned advisor information, and enforcing business rules during critical student lifecycle events like registration or program changes. A typical query would join this table to person and advising group tables to list all active assignments.

• Sample Query Pattern: Retrieving a student's advisor for a specific group.
  SELECT p1.LAST_NAME as STUDENT_NAME, p2.LAST_NAME as ADVISOR_NAME, ag.GROUP_NAME
FROM IGS_AZ_ADVISING_RELS rel,
IGS_PE_PERSON p1,
IGS_PE_PERSON p2,
IGS_AZ_ADVISING_GROUP ag
WHERE rel.STUDENT_PERSON_ID = p1.PERSON_ID
AND rel.ADVISOR_PERSON_ID = p2.PERSON_ID
AND rel.ADVISING_GROUP_ID = ag.ADVISING_GROUP_ID
AND p1.PERSON_ID = :STUDENT_ID;

Related Objects

The IGS_AZ_ADVISING_RELS table is a central entity within the advising data model. It is directly referenced by the primary key constraint IGS_AZ_ADVISING_RELS_PK. It has a foundational relationship with the IGS_AZ_ADVISING_GROUP table, which defines the groups to which the relationships belong. It also has foreign key dependencies on core person tables, such as IGS_PE_PERSON, to identify both students and advisors. Custom views and standard EBS APIs for the Student System likely query this table to surface advising information for forms and institutional reports.