Results for “accept_delete_flag”

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

Overview

The IGSBV_ADVISING_ADVISORS view is a read-only database object owned by the APPS schema within the Oracle E-Business Suite Student System (IGS) product family. It is classified as a Business View (indicated by the BV prefix in its name) and carries a VALID status in the ETRM repository. The view presents details of all advisors associated with the various advising groups configured in the system, providing a reporting-friendly projection over the underlying advisor configuration data.

The view exposes a denormalized, read-only surface for consumers such as concurrent programs, OAF/Forms-based inquiry pages, and external integration extracts. Because it is defined with the WITH READ ONLY clause, it cannot be used as a DML target — it exists purely for query and reporting purposes. This is consistent with the general EBS design principle that Business Views serve as stable, controlled interfaces that shield downstream consumers from the physical layout of the base tables.

Underlying Base Objects

The view is defined over a single base table, IGS_AZ_ADVISORS, aliased as AZA in the defining query. The view text is:

• SELECT AZA.GROUP_ADVISOR_ID, AZA.GROUP_NAME, AZA.ADVISOR_PERSON_ID, AZA.START_DATE, AZA.END_DATE, AZA.MAX_STUDENTS_NUM, AZA.NOTIFIED_DATE, AZA.ACCEPT_ADD_FLAG, AZA.ACCEPT_DELETE_FLAG, AZA.CREATED_BY, AZA.CREATION_DATE, AZA.LAST_UPDATED_BY, AZA.LAST_UPDATE_DATE FROM IGS_AZ_ADVISORS AZA WITH READ ONLY

The mapping between view columns and base table columns is direct — no joins, aggregations, or transformations are applied. The relationship is strictly one-to-one: each row in IGS_AZ_ADVISORS yields exactly one row in the view, subject to the standard EBS security and Multi-Org access rules applied at the base table level.

Key Columns

• GROUP_ADVISOR_IDENTIFIER — The unique identifier for the advisor assignment record. Note that the underlying base column is named GROUP_ADVISOR_ID; the view exposes it under the _IDENTIFIER naming convention common to EBS Business Views. This is the column most frequently referenced by the search term group_advisor_identifier.
• GROUP_NAME — The name of the advising group to which the advisor is assigned.
• ADVISOR_PERSON_IDENTIFIER — The person identifier of the advisor, linking to the person/party model (PER/HR) for demographic and contact retrieval.
• START_DATE / END_DATE — The effective date range during which the advisor is associated with the group.
• MAX_STUDENTS_NUM — The maximum number of students the advisor may be assigned within the group.
• NOTIFIED_DATE — The date on which the advisor was notified of the assignment.
• ACCEPT_ADD_FLAG / ACCEPT_DELETE_FLAG — Flags controlling whether the advisor may add or remove students from the group.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE provide standard EBS WHO-column auditability.

Common Use Cases and Queries

Typical usage includes advisor roster reporting, group membership validation, and extracting advising configuration for downstream systems. The following query lists active advisors for a given group:

• SELECT group_advisor_identifier, group_name, advisor_person_identifier, start_date, end_date FROM igsbv_advising_advisors WHERE group_name = :p_group AND (end_date IS NULL OR end_date >= SYSDATE);

A second common pattern retrieves advisors permitted to add students:

• SELECT group_advisor_identifier, advisor_person_identifier FROM igsbv_advising_advisors WHERE accept_add_flag = 'Y';

Because the view is read-only and directly mapped, filtering is efficient and can leverage indexes defined on the base table. All queries should be executed against the APPS schema with appropriate grants applied to the querying user.