Search Results igs_ad_panel_dtls




Overview
Explore in AI Chat

Overview

The IGS_AD_PANEL_DTLS table is a core data object within the Oracle E-Business Suite's Student System (IGS), specifically in the Admissions module. Its primary function is to manage the detailed assignment of individual application instances to interview or review panels. This table serves as the junction point, linking an applicant's specific course application to a scheduled panel event, thereby enabling the structured evaluation and decision-making process for admissions. It is important to note that the IGS product line is marked as "Obsolete" in the provided ETRM documentation, indicating it is a legacy component. Furthermore, the metadata explicitly states it was "Not implemented in this database," suggesting potential variability in its deployment across different EBS instances or versions.

Key Information Stored

The table stores the critical linkages and outcomes for panel reviews. Its structure is defined by a primary key, PANEL_DTLS_ID, and a series of foreign keys that establish its relationships within the admissions data model. Key columns include identifiers for the application instance (PERSON_ID, ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD, SEQUENCE_NUMBER), which together uniquely identify an applicant's submission for a specific program. It also holds the PANEL_CODE to link to the parent panel definition, and logistical details such as LOCATION_CD and ROOM_ID for the interview venue. Crucially, it records the panel's assessment via FINAL_DECISION_CODE and FINAL_DECISION_TYPE, which classify the outcome of the review (e.g., Accept, Reject, Waitlist).

Common Use Cases and Queries

This table is central to operational reporting and process tracking for admissions panels. Common use cases include generating schedules of which applicants are assigned to which panels, tracking the status and final decisions of panel reviews, and auditing the panel assignment history. A typical query might join IGS_AD_PANEL_DTLS with IGS_AD_PS_APPL_INST_ALL to list all applicants assigned to a specific panel, including their personal and application details, along with the panel's location and decision.

SELECT pad.PANEL_CODE, pad.LOCATION_CD, ai.PERSON_ID, ai.NOMINATED_COURSE_CD, pad.FINAL_DECISION_CODE
FROM IGS_AD_PANEL_DTLS pad
JOIN IGS_AD_PS_APPL_INST_ALL ai
  ON pad.PERSON_ID = ai.PERSON_ID
 AND pad.ADMISSION_APPL_NUMBER = ai.ADMISSION_APPL_NUMBER
 AND pad.NOMINATED_COURSE_CD = ai.NOMINATED_COURSE_CD
 AND pad.SEQUENCE_NUMBER = ai.SEQUENCE_NUMBER
WHERE pad.PANEL_CODE = '&PANEL_CODE';

Another critical report would aggregate final decision statistics by panel or by course to evaluate panel outcomes.

Related Objects

As indicated by its foreign keys, IGS_AD_PANEL_DTLS is a central hub connected to several key tables in the Admissions schema: