Results for “igs_ad_intvw_pnls”

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

Overview

IGS_AD_INTVW_PNLS is a table within the IGS (Student System) product schema of Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. It stores the master records for screening and interview panels created by an institution, forming the parent object for all panel-level configuration and membership data used in admissions and student recruitment processing. Each row represents a discrete panel that can be composed of one or more members and associated with one or more panel detail attributes. Because the table anchors the referencing relationships from IGS_AD_PANEL_DTLS and IGS_AD_PANEL_MEMBRS, it is best understood as a foundational entity rather than a transactional or historical record.

Heuristic Data Vault classification of this object is hub-leaning. The table carries its own unique business key (PANEL_CODE) and serves as the target of foreign key associations, which is characteristic of a hub entity. No effective-dating or type-2 versioning columns are documented, so the object does not behave as a satellite in the strict sense, although the attribute columns permit limited descriptive extension.

Key Information Stored

The table is documented with 31 columns in ETRM 12.1.1. The most significant of these are described below.

• PANEL_CODE — the surrogate primary key defined by unique index IGS_AD_INTVW_PNLS_PK, and simultaneously the business-key candidate. This is the value propagated into all child panels and membership records.
• PANEL_TYPE_CODE — classifies the panel by its purpose, distinguishing screening panels from interview panels or other institutional categories.
• PANEL_DESC — free-text description of the panel, used in reporting and administrative displays.
• PANEL_LEVEL_CODE — indicates the organizational or programmatic level at which the panel operates.
• CLOSED_FLAG — denotes whether the panel is still active or has been closed to further use.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20 — the standard Oracle EBS descriptive flexfield columns, providing extensible storage for institution-specific data without schema modification.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard auditing columns recording row creation and modification context.

Because PANEL_CODE is the only documented unique index, it functions as the definitive identifier for lookups and joins; no alternate unique business key is recorded in the metadata.

Common Use Cases and Queries

Typical usage centers on identifying open panels, retrieving their composition, and joining membership detail for scheduling and reporting. A common pattern retrieves all active panels with their type and description:

• SELECT panel_code, panel_type_code, panel_desc FROM igs_ad_intvw_pnls WHERE closed_flag = 'N';

Panels and their members are frequently joined for committee listings:

• SELECT p.panel_code, p.panel_desc, m.* FROM igs_ad_intvw_pnls p, igs_ad_panel_membrs m WHERE p.panel_code = m.panel_code;

Reporting scenarios include panel utilization analysis, screening coverage by program level, and audit extracts driven by the LAST_UPDATE_DATE column. Integration extracts commonly key off PANEL_CODE for downstream distribution.

Related Objects

The following objects reference or depend on IGS_AD_INTVW_PNLS through documented foreign key relationships:

• IGS_AD_PANEL_DTLS — references IGS_AD_INTVW_PNLS via the column PANEL_CODE. Holds panel detail attributes.
• IGS_AD_PANEL_MEMBRS — references IGS_AD_INTVW_PNLS via the column PANEL_CODE. Holds the individual members assigned to each panel.

Both child tables cascade from the PANEL_CODE primary key, establishing IGS_AD_INTVW_PNLS as the controlling parent for panel definition and membership data within the IGS Student System.