Search Results igf_aw_pkg_run_all

Overview

The table IGF_AW_PKG_RUN_ALL is a core configuration object within the Oracle E-Business Suite's Financial Aid module (IGF). Its primary function is to establish and manage the execution sequence for student financial aid packaging processes. This includes initial packaging, packaging simulations, and repackaging scenarios. The table acts as a master control record, defining a specific packaging run by a unique code and associating it with an academic calendar instance (a Commitment Item). This setup ensures that aid packaging adheres to institutional rules and processes students in a defined, auditable order.

Key Information Stored

The table's structure is defined by its composite primary key, which consists of three critical columns. The RUN_CODE uniquely identifies a specific packaging run configuration. The CI_CAL_TYPE and CI_SEQUENCE_NUMBER columns together form a foreign key reference to an academic calendar or Commitment Item, contextualizing the packaging run within a specific award year or period. While the provided metadata does not list other columns, typical tables of this nature would include descriptive fields such as a run description, status indicators (e.g., 'Active', 'Inactive'), effective dates, and audit columns like CREATION_DATE and LAST_UPDATE_DATE to track configuration lifecycle.

Common Use Cases and Queries

This table is central to administrative setup and operational reporting for financial aid offices. A common use case involves querying all active packaging run configurations for a given award year to validate setup before a packaging batch process. Administrators may also run queries to audit the sequence of runs. Sample SQL patterns include retrieving basic run information and joining with the related detail table for a comprehensive view.

• SELECT run_code, ci_cal_type, ci_sequence_number FROM igf_aw_pkg_run_all WHERE ci_cal_type = '&AWARD_YEAR';
• SELECT run.run_code, run.ci_cal_type, det.* FROM igf_aw_pkg_run_all run, igf_aw_pkg_run_det_all det WHERE run.run_code = det.run_code AND run.ci_cal_type = det.ci_cal_type;

Related Objects

IGF_AW_PKG_RUN_ALL has a direct parent-child relationship with the detail table IGF_AW_PKG_RUN_DET_ALL, as documented by the foreign key. The detail table stores the specific packaging steps, rules, or fund hierarchies that are executed in the sequence defined by the master record in IGF_AW_PKG_RUN_ALL. The join between these tables is performed on the composite key: (RUN_CODE, CI_CAL_TYPE, CI_SEQUENCE_NUMBER). This table is also fundamentally linked to the base tables defining Commitment Items (CI), which govern the award year calendar, though this specific foreign key relationship is not detailed in the provided excerpt.