Results for “advising_group_name”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGSBV_ADVISING_GROUPS is a read-only view within the Oracle E-Business Suite Student System (IGS) product family. Per the ETRM metadata, its documented purpose is to store advising group definitions, and the view is flagged as belonging to the IGS - Student System module, which is identified as obsolete in release 12.1.1 and 12.2.2. The "BV" naming convention indicates a business view intended for reporting, inquiry, and integration consumption rather than for transactional data entry.

The view exposes the configuration of advising groups used by academic advising functionality: the group name and description, the advising category, delivery method, advising holds, advising session limits, and a broad set of automation flags that govern how students and advisors are added to or removed from a group. Because the object is documented as not implemented in the provided database, it may be absent or inactive in a given environment; the metadata should be treated as a reference definition rather than confirmation of availability.

The user's search term, auto_stdnt_add_flag, maps directly to a column in this view that controls automatic addition of students to an advising group. This makes the view the natural reference point for understanding and querying that behavior.

Underlying Base Objects

The ETRM documentation states that no base objects are documented for this view and identifies the view text as:

SELECT ... FROM IGS_AZ_GROUPS WITH READ ONLY

Accordingly, the sole documented underlying base object is the table IGS_AZ_GROUPS. The view is defined with a WITH READ ONLY clause, which prevents DML through the view and enforces its use strictly for query and reporting. Since IGS is obsolete, customers on 12.1.1 or 12.2.2 should validate whether IGS_AZ_GROUPS still exists in their schema before relying on the view.

Key Columns

The view text selects physical columns from IGS_AZ_GROUPS while the documented column list includes several derived or aliased labels. Notable columns include:

• AUTO_STDNT_ADD_FLAG — the searched attribute; indicates whether students are automatically added to the advising group.
• AUTO_STDNT_REMOVE_FLAG / AUTO_ADVISOR_ADD_FLAG / AUTO_ADVISOR_REMOVE_FLAG — parallel automation controls for membership maintenance.
• AUTO_REFRESH_FLAG and LAST_AUTO_REFRESH_DATE — govern and record automatic refresh of the group.
• AUTO_MATCH_FLAG and AUTO_APPLY_HOLD_FLAG — control automatic student-to-advisor matching and hold application.
• ADVISING_CODE (advising category), DELIVERY_METHOD_CODE, MANDATORY_FLAG, ADVISING_SESSIONS_NUM, ADVISING_HOLD_TYPE, CLOSED_FLAG — core advising group configuration.
• RESP_ORG_UNIT_CD, RESP_PERSON_ID, LOCATION_CD — organizational responsibility and location context.
• ADVISOR_GROUP_ID, STUDENT_GROUP_ID, DEFAULT_ADVISOR_LOAD_NUM — group linkage and capacity.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Who columns.

Two columns are documented with lookup descriptors (`_LA:...`) that resolve codes to meanings: ADVISING_CATEGORY and DELIVERY_METHOD_CD_DESC.

Common Use Cases and Queries

Typical usage is to audit automation settings across advising groups or to locate groups that auto-add students. For example:

SELECT ADVISING_GROUP_NAME, AUTO_STDNT_ADD_FLAG, AUTO_STDNT_REMOVE_FLAG, AUTO_REFRESH_FLAG, LAST_AUTO_REFRESH_DATE FROM IGSBV_ADVISING_GROUPS WHERE AUTO_STDNT_ADD_FLAG = 'Y';

Other uses include identifying mandatory groups, groups that apply holds, or inactive groups (CLOSED_FLAG = 'Y'), and joining to lookup views via the advising category or delivery method descriptors for reporting.