Search Results igs_ad_intvw_pnls_n1

Overview

The IGS_AD_INTVW_PNLS table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Admissions module (IGS). It functions as the master repository for screening or interview panels created during the admissions process. These panels are groups of individuals, such as faculty or staff, responsible for evaluating applicants. The table's primary role is to define and maintain the configuration of these panels, enabling the systematic assignment of evaluators to applicant interviews or screenings. Its status is VALID, and it resides in the APPS_TS_TX_DATA tablespace under the IGS schema.

Key Information Stored

The table's columns store the defining attributes of an admissions panel. The PANEL_CODE (VARCHAR2(30)) is the mandatory unique identifier for each panel, serving as the primary key. The PANEL_TYPE_CODE and PANEL_LEVEL_CODE classify the panel's purpose and hierarchical level, respectively. A PANEL_DESC provides a descriptive name. The CLOSED_FLAG indicates whether the panel is active or inactive for new assignments. Furthermore, the table includes a standard Descriptive Flexfield (DFF) structure, comprising ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE13, allowing for institution-specific customization to capture additional panel details not covered by the standard columns.

Common Use Cases and Queries

This table is central to configuring and querying the interview process. Common operational use cases include setting up new evaluation panels for an intake cycle, closing panels after a recruitment round, and generating lists of active panels for administrative reporting. A frequent query pattern involves joining this table with related assignment or member tables to list panel details. For example, to find all active panels of a specific type, one might use:

• SELECT panel_code, panel_desc FROM igs.igs_ad_intvw_pnls WHERE panel_type_code = 'FINAL_INTERVIEW' AND NVL(closed_flag, 'N') = 'N';

Another critical use case is validating the PANEL_CODE during data entry in other admissions forms or interfaces, ensuring referential integrity. Reporting often leverages this table as a dimension for analyzing interview scheduling and evaluator workload.

Related Objects

The table has defined relationships with other EBS objects, primarily through its indexes and foreign key dependencies. The unique IGS_AD_INTVW_PNLS_PK index enforces the primary key constraint on the PANEL_CODE column. The non-unique IGS_AD_INTVW_PNLS_N1 index on PANEL_TYPE_CODE and PANEL_CODE supports performance for queries filtered by panel type. While the provided metadata does not list foreign key constraints, in a typical EBS configuration, the PANEL_CODE is referenced by child tables that store panel member assignments (e.g., IGS_AD_PANEL_MEMBERS) and interview schedules. The table is also referenced by the FND Design Data object IGS.IGS_AD_INTVW_PNLS, which manages its registration within the Oracle Application Framework.