Results for “igs_ad_panel_membrs”

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

Overview

The IGS_AD_PANEL_MEMBRS table belongs to the IGS — Student System product family within Oracle E-Business Suite. It is documented as an obsolete component that stored the membership details of individuals assigned to an admission panel. In functional terms, each row records that a specific person served on a specific admissions interview or review panel, together with the role that person played and the sequence in which the panel member was positioned.

The ETRM metadata states that this object is not implemented in the reference database, meaning it exists in the historical data model documentation but is not physically present in the shipped 12.1.1 / 12.2.2 schema. This is a common characteristic of legacy Higher Education modules that were retired or superseded by other Oracle Student System components.

Based on the heuristic Data Vault classification derived from its foreign key structure, the table is best modeled as a link entity. It resolves a many-to-many association between an admission panel and a person (party), and its composite primary key is composed entirely of foreign key columns. This classification is a modeling suggestion rather than a declarative attribute of the physical table.

Key Information Stored

The documented schema contains 30 columns owned by the IGS schema. The most functionally significant columns are:

• PANEL_CODE — Identifies the admission panel to which the member belongs. This column participates in the primary key and carries a foreign key to IGS_AD_INTVW_PNLS.
• MEMBER_PERSON_ID — Identifies the person (party) who is a member of the panel. This column also participates in the primary key and references HZ_PARTIES.
• ROLE_TYPE_CODE — Describes the function or capacity in which the person serves on the panel, such as interviewer, reviewer, or chairperson.
• PANEL_SEQ_NUM — Provides an ordering or ordinal position for the member within the panel, useful for presenting panel rosters in a controlled sequence.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20 — The standard Oracle EBS descriptive flexfield (DFF) column set, allowing implementers to store installation-specific panel membership attributes without schema modification.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — Standard audit columns recording who created and last modified each membership record and when.

The unique index IGS_AD_PANEL_MEMBRS_PK on (PANEL_CODE, MEMBER_PERSON_ID) is the business-key candidate and serves as the table's primary key. Because the primary key is exclusively composed of foreign key columns, there is no separate surrogate key column documented for this object.

Common Use Cases and Queries

Typical reporting and integration scenarios focus on retrieving panel rosters, identifying a person's panel participation, and enumerating panel members with their associated roles.

To list all members of a given panel in sequence order:

• SELECT MEMBER_PERSON_ID, ROLE_TYPE_CODE, PANEL_SEQ_NUM FROM IGS_AD_PANEL_MEMBRS WHERE PANEL_CODE = :panel_code ORDER BY PANEL_SEQ_NUM;

To join panel definitions with their member parties:

• SELECT p.PANEL_CODE, m.MEMBER_PERSON_ID, m.ROLE_TYPE_CODE FROM IGS_AD_INTVW_PNLS p, IGS_AD_PANEL_MEMBRS m WHERE p.PANEL_CODE = m.PANEL_CODE;

To resolve member names, join to HZ_PARTIES:

• SELECT m.PANEL_CODE, hp.PARTY_NAME, m.ROLE_TYPE_CODE FROM IGS_AD_PANEL_MEMBRS m, HZ_PARTIES hp WHERE m.MEMBER_PERSON_ID = hp.PARTY_ID;

Report writers typically exclude the DFF and audit columns from analytical output but may filter on ROLE_TYPE_CODE to isolate, for example, only interviewers. Since the table is obsolete and not implemented, these patterns apply primarily to historical migrations, data archaeology, or legacy-system reconciliation rather than active 12.2.2 production support.

Related Objects

• IGS_AD_INTVW_PNLS — The parent admission interview panel table. Joined on IGS_AD_PANEL_MEMBRS.PANEL_CODE = IGS_AD_INTVW_PNLS.PANEL_CODE.
• HZ_PARTIES — The Trading Community Architecture party table holding person identity. Joined on IGS_AD_PANEL_MEMBRS.MEMBER_PERSON_ID = HZ_PARTIES.PARTY_ID.
• HZ_PERSON_PROFILES — Extends HZ_PARTIES with person-specific attributes and is frequently used alongside HZ_PARTIES when reporting panel member details.
• IGS_AD_APPL_PANELS and other IGS_AD_* admissions tables — Sibling objects in the obsolete admissions panel domain that reference panel definitions.
• FND_USER — Referenced indirectly through the CREATED_BY and LAST_UPDATED_BY audit columns to resolve the application user responsible for each record.