Search Results igs_ad_panel_membrs




Overview
Explore in AI Chat

Overview

The IGS_AD_PANEL_MEMBRS table is a core data structure within the Oracle E-Business Suite Student System (IGS) module, specifically supporting the admissions functionality. It serves as the master repository for defining the composition of admission panels. An admission panel is a group of individuals responsible for evaluating applicants, often for interviews or application reviews. This table establishes the critical link between a defined panel (IGS_AD_INTVW_PNLS) and the specific persons (HZ_PARTIES) who are appointed as its members. Its role is to maintain the authoritative membership roster, which is essential for routing applications, scheduling interviews, and recording evaluation outcomes within the admissions workflow in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to uniquely identify a panel member within a specific panel. The primary key is a composite of two columns, underscoring their fundamental importance. The PANEL_CODE column stores the unique identifier for the admission panel, as defined in the IGS_AD_INTVW_PNLS table. The MEMBER_PERSON_ID column holds the unique identifier (PARTY_ID) for the person who is a member of that panel, linking to the HZ_PARTIES table in the Trading Community Architecture (TCA) model. While the provided metadata highlights these core columns, typical implementations of such a junction table may also include attributes like a sequence number for ordering members, an active/inactive flag, creation dates, and who created the record, though these are not explicitly listed in the excerpt.

Common Use Cases and Queries

This table is central to operations involving panel-based admissions processes. Common functional use cases include configuring panels for specific admission terms or programs, assigning applications to panel members for review, and generating member schedules for interview days. From a reporting and query perspective, typical SQL patterns involve joining to related tables to produce meaningful lists. For example, to retrieve all members for a given panel:

  • SELECT hp.party_name, hp.person_first_name, hp.person_last_name FROM igs_ad_panel_membrs pm, hz_parties hp WHERE pm.panel_code = '&PANEL_CODE' AND pm.member_person_id = hp.party_id ORDER BY hp.person_last_name;

Another common query is to list all panels a specific person belongs to, joining with IGS_AD_INTVW_PNLS for panel details.

Related Objects

As indicated by the foreign key constraints, IGS_AD_PANEL_MEMBRS has direct and essential relationships with two key tables. It is a child table of IGS_AD_INTVW_PNLS (via PANEL_CODE), which defines the panel header information such as description and effective dates. It is also a child table of HZ_PARTIES (via MEMBER_PERSON_ID), which provides all biographical and contact details for the member. This table is likely referenced by other admissions transactional tables, such as those recording interview schedules or application evaluations, where the specific panel member involved in an action needs to be recorded. Any APIs or forms within the Student System that manage panel setup or assignment will fundamentally interact with this table.