Search Results panel_dtls_id




Overview
Explore in AI Chat

Overview

The IGS_AD_PNL_HIS_DTLS table is a core audit and history tracking object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Oracle Student Management) product family. It functions as an audit history table designed to capture and persist a chronological record of changes made to panel decision details. Its primary role is to provide a non-volatile audit trail, enabling historical analysis, compliance reporting, and the reconstruction of decision state changes over time for admissions or academic review panels. The table's storage in the APPS_TS_TX_DATA tablespace and its structure underscore its purpose as a transactional history log.

Key Information Stored

The table stores a combination of business data and standard system metadata. The key business columns are PANEL_DTLS_ID, which links each history record to its associated panel details master record; HISTORY_DATE, which records the precise date of the change; and the pair FINAL_DECISION_CODE and FINAL_DECISION_TYPE, which together capture the specific decision state (e.g., "APPROVE", "REJECT") and its classification at the point of logging. The PANEL_DTLS_ID and HISTORY_DATE columns form the unique primary key (IGS_AD_PNL_HIS_DTLS_PK), ensuring a distinct record for each change event per panel detail. The table is also equipped with the full suite of standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) to track system-level audit information for each row's creation and modification.

Common Use Cases and Queries

This table is central to audit reporting and historical trend analysis for panel decisions. A common use case is generating a report showing the complete decision history for a specific application or case, tracing how the panel's final determination evolved. Another critical use is compliance auditing, providing evidence of when and what decisions were recorded. A typical query retrieves the history for a specific panel detail, often joined to master tables for contextual information:

  • Retrieve Full History for a Panel Detail: SELECT * FROM igs.igs_ad_pnl_his_dtls WHERE panel_dtls_id = :p_id ORDER BY history_date;
  • Report on Specific Decision Changes: SELECT panel_dtls_id, history_date, final_decision_code FROM igs.igs_ad_pnl_his_dtls WHERE final_decision_type = 'FINAL' AND TRUNC(history_date) BETWEEN :p_start_date AND :p_end_date;
  • Identify Latest Decision per Detail: SELECT panel_dtls_id, MAX(history_date) KEEP (DENSE_RANK LAST ORDER BY history_date) AS last_change_date FROM igs.igs_ad_pnl_his_dtls GROUP BY panel_dtls_id;

Related Objects

Based on the provided metadata, the IGS_AD_PNL_HIS_DTLS table is referenced by objects within the APPS schema, indicating its integration with the broader EBS application layer. The most significant relationship is implied by the PANEL_DTLS_ID column, which is a foreign key to a master panel details table (likely named IGS_AD_PNL_DTLS or similar), though this parent table is not explicitly listed in the dependencies excerpt. The existence of a non-unique index (IGS_AD_PNL_HIS_DTLS_N1) on FINAL_DECISION_CODE and FINAL_DECISION_TYPE facilitates performance for queries filtering on these decision attributes. Developers and report writers typically join this history table to its parent master table to enrich history records with full application or candidate context.