Search Results igs_ad_pnmembr_dtls_n1

Overview

The IGS_AD_PNMEMBR_DTLS table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Admissions (IGS) module. As defined in the ETRM, this table holds the information about the members assigned to a panel instance. It functions as the transactional repository for details pertaining to individual panel members involved in the admissions evaluation process, such as interviewers or reviewers. Its role is critical for managing the composition, scheduling, and decision inputs of evaluation panels, linking panel definitions (via PANEL_DTLS_ID) to specific person records and their contributions.

Key Information Stored

The table's columns capture the essential data points for panel member management. The primary key is a composite of PANEL_DTLS_ID and MEMBER_PERSON_ID, uniquely identifying a member's assignment to a specific panel. Key operational columns include ROLE_TYPE_CODE, which defines the member's function, and the interrelated MEMBER_DECISION_CODE and MEMBER_DECISION_TYPE fields, which store the member's evaluative decision and its classification. Scheduling details are captured in INTERVIEW_DATE, INTERVIEW_TIME, LOCATION_CD, and ROOM_ID. The MEMBER_DECISION_DATE records when the decision was made. The table also includes a standard set of Descriptive Flexfield (DFF) columns (ATTRIBUTE_CATEGORY through ATTRIBUTE20) for institution-specific extensions.

Common Use Cases and Queries

This table is central to reporting and auditing panel activities. A frequent requirement is to retrieve all decisions made by a specific panel member or for a particular panel instance. The non-unique index IGS_AD_PNMEMBR_DTLS_N1 on MEMBER_DECISION_CODE and MEMBER_DECISION_TYPE is optimized for queries filtering on these decision fields. Common SQL patterns include listing panel members and their decisions for a given application, or identifying scheduled interviews within a date range. For example, to find a member's decision, one might query:

• SELECT MEMBER_DECISION_TYPE, MEMBER_DECISION_CODE FROM IGS.IGS_AD_PNMEMBR_DTLS WHERE PANEL_DTLS_ID = :p_panel_id AND MEMBER_PERSON_ID = :p_person_id;

Reporting use cases often involve joining to person (PER_ALL_PEOPLE_F) and code lookup tables to generate readable panel rosters, decision summaries, or interview schedules.

Related Objects

The IGS_AD_PNMEMBR_DTLS table has defined relationships with other EBS objects. Its primary key is enforced by the unique index IGS_AD_PNMEMBR_DTLS_PK. It is the referenced parent table for any foreign key constraints from other tables that require panel member details. The PANEL_DTLS_ID column likely references a parent panel definition table, such as IGS_AD_PANEL_DTLS. The MEMBER_PERSON_ID column typically joins to the core HR person table (PER_ALL_PEOPLE_F). The LOCATION_CD and ROOM_ID columns may reference location master tables within the IGS or INV schemas. The non-unique indexes (N1, N2, N3) indicate performance-critical access paths for queries filtering on decision codes, decision types, location codes, and room IDs.