Results for “igs_az_deliv_method”

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

Overview

IGS_AZ_GROUPS_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite, exposed in both 12.1.1 and 12.2.2. It belongs to the Student Systems / Student Records (IGS) product family, specifically the advising component that manages advisor groups and student cohorts used in academic advising workflows. The view presents a denormalized, readable projection of the underlying IGS_AZ_GROUPS table, resolving foreign-key identifiers into descriptive text and decoding lookup values into their human-readable meanings.

The view is significant to integrators and report developers because it performs the join and decode work that would otherwise need to be replicated in every report or interface. Reference to IGS_AZ_DELIV_METHOD as a synonym or lookup term in user searches typically leads to this view, since the view exposes the resolved delivery-method meaning rather than the raw lookup code. The view carries the standard EBS WHO columns, and its inclusion of ROWID and the full ATTRIBUTE1 through ATTRIBUTE20 set makes it suitable for DFF-aware reporting and for tools that need row addressing.

Underlying Base Objects

The view is defined over the base table IGS_AZ_GROUPS, from which every column in the SELECT list originates, either directly or through scalar subqueries. The documented ETRM metadata lists no separate referenced base objects beyond this table, though the view text clearly includes correlated subqueries against several other tables: HZ_PARTIES and IGS_PE_HZ_PARTIES for party and responsible-person names, IGS_LOOKUP_VALUES for delivery-method meaning, and IGS_PE_PERSID_GROUP (referenced twice) for advisor-group and student-group descriptions.

• IGS_AZ_GROUPS — the primary driving table; supplies all group attributes, flags, and WHO columns.
• HZ_PARTIES — provides party_name and the concatenated person name for the responsible person.
• IGS_PE_HZ_PARTIES — correlates OSS org unit to party for name resolution.
• IGS_LOOKUP_VALUES — decodes DELIVERY_METHOD_CODE using lookup type IGS_AZ_DELIV_METHOD.
• IGS_PE_PERSID_GROUP — resolves advisor and student group descriptions.

Key Columns

• GROUP_NAME / GROUP_DESC — the group identifier and free-text description.
• ADVISING_CODE / ADVISING_HOLD_TYPE / ADVISING_SESSIONS_NUM — advising configuration attributes.
• RESP_ORG_UNIT_CD / RESP_PERSON_ID — the responsible organization unit and the resolved person name concatenation.
• DELIVERY_METHOD_CODE — the raw lookup code; the adjacent subquery returns the IGS_AZ_DELIV_METHOD meaning.
• ADVISOR_GROUP_ID / STUDENT_GROUP_ID — person ID group references with resolved descriptions.
• DEFAULT_ADVISOR_LOAD_NUM / MANDATORY_FLAG / CLOSED_FLAG — group capacity and status controls.
• AUTO_* flags and LAST_AUTO_REFRESH_DATE — automation settings for membership and matching.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–20 — DFF support columns.
• CREATED_BY / CREATION_DATE / LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical scenarios include listing active advisor groups with their delivery methods, auditing group automation settings, and driving integration extracts where lookup meanings are required. Because the view resolves meanings, queries remain stable even when lookup codes change.

• Retrieving groups and their delivery-method meaning:
  SELECT group_name, delivery_method_code, (SELECT meaning FROM igs_lookup_values WHERE lookup_type='IGS_AZ_DELIV_METHOD' AND lookup_code=delivery_method_code) dm FROM apps.igs_az_groups_v;
• Filtering open groups assigned to a responsible person.
• Auditing auto-refresh and auto-match configuration for governance reporting.
• Feed queries for advising-session scheduling integrations.

Consumers should apply the appropriate operating-unit security where required and treat the correlated subqueries as single-row lookups, as implied by the view definition.