Search Results hold_end_date

Overview

The view IGS_AZ_STUDENTS_V belongs to the IGS — Student System product family within Oracle E-Business Suite. In ETRM documentation it is explicitly flagged as obsolete, and its documented description states that it exists to "display the student information for advising on the SS page." In practical terms, the view was used to surface advising records — students assigned to an advising group, together with associated advising holds and notification data — for presentation on a self-service (SS) advising page. It is a reporting-oriented, denormalized projection that joins student-to-group assignments with party (person) detail and student-group lookup information, so that a page or concurrent program could retrieve advising context in a single query rather than assembling it from multiple base tables.

The ETRM metadata records that this object is not implemented in this database and that no owner is documented for the 12.2.2 metadata set. This indicates the view exists in the reference repository of ETRM rather than being shipped or instantiated in every environment, a common situation for obsolete IGS objects inherited from earlier student system releases. Administrators querying it in EBS 12.1.1 or 12.2.2 should therefore confirm availability before relying on it in custom code.

Underlying Base Objects

Although the ETRM "referenced base objects" section documents none, the view text itself is preserved in the ETRM excerpt and shows the four tables that underlie it:

• IGS_AZ_STUDENTS (alias AZS) — the driving table, holding the advising group assignment, dates, hold type, and accept flags for each student.
• IGS_AZ_GROUPS (alias AG) — supplies the group description and student group identifier; joined on AZS.GROUP_NAME = AG.GROUP_NAME.
• HZ_PARTIES (alias HZ) — supplies the party number and person name elements; joined on AZS.STUDENT_PERSON_ID = HZ.PARTY_ID.
• IGS_PE_PERSID_GROUP_ALL (alias PG) — an outer-joined lookup supplying the student group code and description via PG.GROUP_ID(+) = AG.STUDENT_GROUP_ID.

The view also contains a correlated scalar subquery against IGS_PE_PERS_ENCUMB to derive the hold end date, plus an inline ROWID-based row identifier from the driving table.

Key Columns

• ROW_ID — the ROWID of the IGS_AZ_STUDENTS row, used for row-level addressing.
• GROUP_STUDENT_ID, GROUP_NAME, GROUP_DESC — identify the advising group and its descriptive text.
• STUDENT_PERSON_ID, STUDENT_PERSON_NUMBER, STUDENT_FULL_NAME — the person identifier, HZ party number, and a concatenated last/first/middle name built in the view text.
• START_DATE, END_DATE — the assignment's effective window.
• ADVISING_HOLD_TYPE, HOLD_START_DATE, HOLD_END_DATE — the advising hold and its lifecycle; HOLD_END_DATE is derived from IGS_PE_PERS_ENCUMB by matching person, encumbrance type, and hold start date.
• NOTIFIED_DATE, ACCEPT_ADD_FLAG, ACCEPT_DELETE_FLAG — notification and action flags central to advising workflow.
• STUDENT_GROUP_ID, STUDENT_GROUP_CD, STUDENT_GROUP_DESC, DELIVERY_METHOD_CODE — group classification and delivery attributes.
• Standard audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

The view was intended for advising self-service and related reporting, such as listing active holds for an advisor's students or checking whether a student has acknowledged an advising notification.

SELECT student_person_number,
       student_full_name,
       group_desc,
       advising_hold_type,
       hold_start_date,
       hold_end_date,
       notified_date
  FROM igs_az_students_v
 WHERE TRUNC(SYSDATE) BETWEEN start_date AND end_date;

Because the object is documented as obsolete and not implemented, any dependency should be validated against the target EBS instance and replaced by supported IGS advising tables where possible.