Search Results igs_he_ext_run_prms_pk

Overview

The IGS_HE_EXT_RUN_PRMS table is a core data repository within the Oracle E-Business Suite's Student System (IGS) module. Its primary function is to store the specific parameters used for each execution of a data extraction process. In the context of higher education administrative operations, these extracts are critical for generating standardized reports, interfacing with external agencies, or populating data warehouses. The table acts as a detailed audit and configuration log, ensuring that every data extraction run is documented with the precise criteria and settings that defined its scope, enabling traceability and reproducibility of the extracted datasets.

Key Information Stored

While the full column list is not detailed in the provided metadata, the documented structure reveals its essential components. The table's primary key is the RUN_PRMS_ID column, which uniquely identifies each set of parameters. A critical foreign key column is EXTRACT_RUN_ID, which links each parameter set to a master record in the IGS_HE_EXT_RUN_DTLS table, thereby associating parameters with a specific extract execution instance. Typically, such a table would store parameter names and their corresponding values used for the extract—for example, academic period, institution code, report type, output format, or specific selection criteria that filtered the student data during the extraction process.

Common Use Cases and Queries

This table is central to auditing and troubleshooting data extraction jobs. Common operational scenarios include reviewing the parameters for a past extract to reconcile data discrepancies or to re-run a historical report with identical criteria. System administrators may query it to analyze extraction patterns. A typical SQL query would join this table to the run details table to get a complete picture of an extract job.

• Finding Parameters for a Specific Run: SELECT * FROM igs.igs_he_ext_run_prms WHERE extract_run_id = <RUN_ID>;
• Auditing All Runs for a Parameter Value: SELECT r.*, p.* FROM igs.igs_he_ext_run_dtls r, igs.igs_he_ext_run_prms p WHERE r.extract_run_id = p.extract_run_id AND p.parameter_name = 'ACADEMIC_PERIOD' AND p.parameter_value = '2024-01';

Related Objects

The table maintains a direct and documented foreign key relationship with the master extract run table. This relationship is fundamental to the data model.

• IGS_HE_EXT_RUN_DTLS: This is the primary parent table. The relationship is defined by the foreign key column IGS_HE_EXT_RUN_PRMS.EXTRACT_RUN_ID, which references the IGS_HE_EXT_RUN_DTLS table. Every parameter record must be associated with one extract run detail record, forming a one-to-many relationship where a single run can have multiple parameters.