Search Results role_type_desc




Overview
Explore in AI Chat

Overview

IGS_AD_PANEL_MEMBRS_V is a seeded Oracle E-Business Suite view belonging to the IGS (Student System) product family, which is documented as obsolete in Release 12.1.1 and 12.2.2. The view provides a denormalized, reporting-oriented presentation of the IGS_AD_PANEL_MEMBRS base table, whose purpose is to record the individual members who sit on an admissions interview or screening panel. Each row returned by the view represents one panel member, enriched with the member's person number and full name from the person base view, the human-readable role type description resolved from the lookup values, and the panel type context from the interview panels table.

The view is typically exposed through the Admissions (AD) subsystem's interview and screening functionality, where panels are assembled and their membership maintained. Because it resolves lookup meanings and person attributes at query time, it is convenient for concurrent programs, Oracle Reports, BI Publisher data templates, and inbound/outbound interface extracts that must display panel composition without performing multiple joins manually.

Underlying Base Objects

The view text joins four objects. The driving table is IGS_AD_PANEL_MEMBRS (aliased PNLMBR), which holds the panel membership rows. It is joined to IGS_PE_PERSON_BASE_V (PEBASE) on MEMBER_PERSON_ID = PERSON_ID to retrieve PERSON_NUMBER and FULL_NAME. It is joined to IGS_LOOKUP_VALUES (LKUPS) on ROLE_TYPE_CODE = LOOKUP_CODE to obtain the ROLE_TYPE_DESC meaning. Finally, it is joined to IGS_AD_INTVW_PNLS (PNLTYPE) on PANEL_CODE to determine the panel type.

The join to IGS_LOOKUP_VALUES is constrained by panel type: when the panel type is 'INTERVIEW', the lookup type must be 'INTERVIEW_ROLE_TYPE'; when the panel type is 'SCREENING', the lookup type must be 'SCREEN_ROLE_TYPE'. This conditional predicate ensures role descriptions are drawn from the correct lookup set and prevents cross-type matches. Note that the ETRM 12.2.2 metadata records no owner and no documented referenced base objects, and the view is marked "Not implemented in this database" — that is, it is a seeded definition that may not exist in every environment.

Key Columns

  • ROW_ID — the ROWID of the underlying IGS_AD_PANEL_MEMBRS row, useful for updates or row identification.
  • PANEL_CODE — identifier of the panel to which the member belongs.
  • MEMBER_PERSON_ID — the person identifier of the panel member.
  • PERSON_NUMBER / FULL_NAME — the member's person number and full name from IGS_PE_PERSON_BASE_V.
  • PANEL_SEQ_NUM — the sequence number of the member within the panel; this is the column most directly associated with the user's search term and governs the ordering of members on a panel.
  • ROLE_TYPE_CODE / ROLE_TYPE_DESC — the member's role code and its lookup meaning (for example, chair or member).
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE20 — the standard EBS descriptive flexfield (DFF) columns, exposing any configured member-level attributes.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO columns for audit and concurrency tracking.

Common Use Cases and Queries

Typical uses include listing the members of an interview or screening panel in sequence order, producing panel rosters for admissions committees, and extracting panel composition for interfaces into other systems. Because the view already resolves person names and role descriptions, it is well suited to reporting layers.

  • Retrieve all members of a specific panel, ordered by PANEL_SEQ_NUM:
    SELECT panel_code, panel_seq_num, person_number, full_name, role_type_desc FROM igs_ad_panel_membrs_v WHERE panel_code = :p_panel_code ORDER BY panel_seq_num;
  • Find all panels on which a given person serves:
    SELECT panel_code, panel_seq_num, role_type_desc FROM igs_ad_panel_membrs_v WHERE member_person_id = :p_person_id ORDER BY panel_code, panel_seq_num;
  • List panel membership by role type across panels:
    SELECT panel_code, role_type_desc, full_name FROM igs_ad_panel_membrs_v WHERE role_type_code = :p_role ORDER BY panel_code, panel_seq_num;
  • Inspect configured flexfield attributes for a member:
    SELECT panel_code, panel_seq_num, attribute_category, attribute1, attribute2 FROM igs_ad_panel_membrs_v WHERE attribute_category IS NOT NULL;

Because the IGS product is marked obsolete in 12.1.1 and 12.2.2, implementations still relying on these objects should plan migration to supported Student System equivalents. Consumers should always guard queries against the possibility that the view is not implemented in a given database.