Search Results run_code

Overview

The table IGF_AW_PKG_RUN_DET_ALL is a core data object within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). It is central to the automated packaging process, which determines the types and amounts of financial aid awards for which a student is eligible. This table functions as the detailed execution plan for a packaging run, storing the specific target groups of students and the precise sequence in which these groups must be processed. By defining this order, it ensures that packaging logic is applied consistently and according to institutional policies across different student cohorts within an award year.

Key Information Stored

The table's structure is defined by its primary and foreign keys, which establish its critical relationships. The primary key, IGF_AW_PKG_RUN_DET_ALL_PK, is a composite of four columns: RUN_CODE, CI_CAL_TYPE, CI_SEQUENCE_NUMBER, and GROUP_CD. This combination uniquely identifies each target group assignment within a packaging run for a specific award year (defined by the calendar type and sequence). The RUN_CODE links to the parent packaging run definition in IGF_AW_PKG_RUN_ALL. The GROUP_CD identifies the specific student cohort or target group to be packaged. An additional unique key (IGF_AW_PKG_RUN_DET_ALL_UK) on RUN_CODE, CI_CAL_TYPE, CI_SEQUENCE_NUMBER, and SEQ_NO enforces the order of processing, where SEQ_NO column dictates the sequence in which the target groups are evaluated.

Common Use Cases and Queries

The primary use case is the execution and audit of the financial aid packaging engine. Administrators can query this table to review or validate the packaging workflow for a specific run. A common reporting requirement is to list all target groups included in a packaging run along with their processing order. A typical query would join to the parent run table to provide context. For example, to find the sequence of groups for a run code 'FALL2024_AID':

• SELECT det.run_code, det.seq_no, det.group_cd FROM igf_aw_pkg_run_det_all det WHERE det.run_code = 'FALL2024_AID' ORDER BY det.seq_no;

Technical support or custom integrations may also query this table to understand dependencies before modifying or deleting a packaging run definition, as the details are child records of the main run.

Related Objects

IGF_AW_PKG_RUN_DET_ALL maintains defined foreign key relationships with other critical Financial Aid tables. The primary relationship is with the parent table IGF_AW_PKG_RUN_ALL, which stores the master definition of the packaging run. The join is performed on the columns RUN_CODE, CI_CAL_TYPE, and CI_SEQUENCE_NUMBER. This ensures every detail record is associated with a valid, higher-level run. A second foreign key relationship exists on the GROUP_CD column, linking each detail record to the table that defines the target group criteria (the referenced table name is indicated as '%' in the provided metadata, suggesting it may be a dynamic reference within the product code). The ORG_ID column supports the multi-organization architecture standard in Oracle EBS.