Search Results igs_ad_pnl_his_dtls




Overview
Explore in AI Chat

Overview

The IGS_AD_PNL_HIS_DTLS table is a core audit and history table within the Oracle E-Business Suite Student System (IGS), specifically for the Admissions module. Its primary function is to provide a historical audit trail for changes made to panel decisions during the application review process. This object is critical for maintaining data integrity, enabling compliance reporting, and tracking the evolution of an admissions panel's evaluation over time. As a history table, it supports operational transparency and facilitates troubleshooting by preserving a record of all modifications to key decision attributes.

Key Information Stored

The table's structure is designed to capture the state of a panel decision at a specific point in time. Its composite primary key, consisting of PANEL_DTLS_ID and HISTORY_DATE, uniquely identifies each historical snapshot. The PANEL_DTLS_ID column is a foreign key linking the record to its source entry in the IGS_AD_PANEL_DTLS table. The HISTORY_DATE column records the timestamp when the change was captured. Other significant columns include FINAL_DECISION_CODE and FINAL_DECISION_TYPE, which store the specific decision code and its classification at that historical moment, forming a foreign key relationship to the IGS_AD_CODE_CLASSES table. This design ensures a complete audit record of decision state changes.

Common Use Cases and Queries

This table is primarily used for audit reporting, compliance verification, and analyzing decision-making trends within admissions panels. A common operational query involves retrieving the complete change history for a specific panel to understand the progression of its final decision. For example:

  • Audit Trail Report: SELECT * FROM igs.igs_ad_pnl_his_dtls WHERE panel_dtls_id = :1 ORDER BY history_date DESC;
  • Decision Change Analysis: Analysts may run queries to identify applications where the panel's final decision was altered, which is valuable for process reviews.
  • Point-in-Time Reporting: The table allows reconstruction of the panel decision data as it existed on any given date for historical reporting purposes.

Related Objects

The IGS_AD_PNL_HIS_DTLS table has defined relationships with other key entities in the Admissions module, as documented in the ETRM metadata.

  • IGS_AD_PANEL_DTLS: This is the primary transactional table for panel details. The history table references it via the foreign key column PANEL_DTLS_ID. This relationship ties each historical snapshot to its originating panel record.
  • IGS_AD_CODE_CLASSES: This lookup table validates and provides context for the decision codes stored in the history. The history table references it through the combined foreign key columns FINAL_DECISION_CODE and FINAL_DECISION_TYPE.

The table itself is referenced by its primary key constraint, IGS_AD_PNL_HIS_DTLS_PK, ensuring the uniqueness of each historical entry.