Search Results screen_role_type




Overview
Explore in AI Chat

Overview

APPS.IGS_AD_PANEL_MEMBRS_V is a reporting and integration view in the Oracle EBS Admissions (IGS) product family. It presents the composition of admissions panels — specifically interview and screening panels — by resolving panel member records into a single denormalized rowset that joins member assignments, person biographical data, and role-type lookup descriptions. The view is read-only by construction and is intended for inquiry, reporting, and interface extraction rather than for direct DML.

In the context of the user's search term, panel_seq_num is a first-class column of this view. It exposes the sequence number assigned to a member within a given panel, allowing consumers to order panel members deterministically and to reconstruct the intended roster ordering used during interview or screening scheduling.

Underlying Base Objects

The view is defined over four sources, joined as follows:

  • IGS_AD_PANEL_MEMBRS (aliased pnlmbr) — the driving table holding panel member rows, person identifiers, role type codes, sequence numbers, and the DFF attribute columns.
  • IGS_PE_PERSON_BASE_V (aliased pebase) — supplies person_number and full_name, joined on member_person_id = person_id.
  • IGS_LOOKUP_VALUES (aliased lkups) — supplies meaning as role_type_desc, joined on role_type_code = lookup_code.
  • IGS_AD_INTVW_PNLS (aliased pnltype) — supplies the panel type context, joined on panel_code.

The join predicate on the lookup is conditional: the lookup type must be INTERVIEW_ROLE_TYPE when the associated panel is of type INTERVIEW, or SCREEN_ROLE_TYPE when the panel is of type SCREENING. This ensures the role description is drawn from the correct lookup set for each panel category, and that only members of interview or screening panels are returned.

Key Columns

  • row_id — the ROWID of the underlying panel member row; useful as a stable surrogate for the row.
  • panel_code — identifies the panel to which the member belongs.
  • member_person_id / person_number / full_name — the member's internal party identifier, business-facing person number, and display name.
  • panel_seq_num — the ordinal position of the member within the panel; the primary ordering attribute for roster reporting.
  • role_type_code / role_type_desc — the member's role on the panel and its translated meaning from the appropriate lookup type.
  • attribute_category and attribute1–attribute20 — the descriptive flexfield context and segments carried from the base member table.
  • created_by, creation_date, last_updated_by, last_update_date, last_update_login — standard audit columns.

Common Use Cases and Queries

Typical uses include printing panel rosters in sequence order, feeding interview scheduling interfaces, and validating that each panel has the expected roles assigned. A representative query listing members in sequence order is:

  • SELECT panel_code, panel_seq_num, person_number, full_name, role_type_desc FROM apps.igs_ad_panel_membrs_v WHERE panel_code = :p_panel_code ORDER BY panel_seq_num;
  • SELECT panel_code, panel_seq_num, full_name, role_type_code FROM apps.igs_ad_panel_membrs_v WHERE role_type_code = :p_role ORDER BY panel_code, panel_seq_num;
  • SELECT person_number, full_name, COUNT(*) panels FROM apps.igs_ad_panel_membrs_v GROUP BY person_number, full_name ORDER BY panels DESC;

Because the view enforces the interview/screening panel type restriction, queries against it never return members of other panel classifications, which simplifies downstream reporting logic.