Search Results sys_fund_code

Overview

The IGF.IGF_AW_REPKG_PRTY table is a configuration table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Grants Accounting (IGF) module. Its primary function is to define the priority order for re-packaging financial aid funds at the system fund level. During the award packaging process, this table governs the sequence in which different fund sources and system funds are considered or applied when financial aid packages are adjusted or re-evaluated. This ensures a consistent and controlled methodology for allocating institutional and external funds to students according to predefined business rules.

Key Information Stored

The table stores the core configuration for fund repackaging priority alongside standard audit columns. The key business columns are:

• FUND_ORDER_NUM (NUMBER): The numerical priority sequence for the fund. Lower numbers indicate higher priority.
• SYS_FUND_TYPE_CODE (VARCHAR2(30)): A classification code for the type of system fund (e.g., Grant, Loan, Scholarship).
• FUND_SOURCE_CODE (VARCHAR2(30)): A critical code identifying the origin or source of the funds, such as federal, state, or institutional.
• SYS_FUND_CODE (VARCHAR2(30)): The specific identifier for the system fund being prioritized.
• Standard WHO Columns (CREATED_BY, CREATION_DATE, etc.): Audit columns tracking the record's creation and last update details.

The uniqueness of a configuration record is enforced by a composite key on SYS_FUND_TYPE_CODE, FUND_SOURCE_CODE, and SYS_FUND_CODE (via the IGF_AW_REPKG_PRTY_U1 index), while the IGF_AW_REPKG_PRTY_PK index uniquely identifies each priority rule by FUND_ORDER_NUM.

Common Use Cases and Queries

This table is central to financial aid administration operations. A common use case is during the automated re-packaging of a student's financial aid award, where the system consults this table to determine the order for substituting or applying funds based on changing eligibility or available funding. Administrators may query this table to review or audit the current prioritization rules. A typical query to retrieve the full prioritization list, ordered by priority, would be:

SELECT FUND_ORDER_NUM, SYS_FUND_TYPE_CODE, FUND_SOURCE_CODE, SYS_FUND_CODE FROM IGF.IGF_AW_REPKG_PRTY ORDER BY FUND_ORDER_NUM;

To investigate rules for a specific fund source, such as institutional funds, a query would filter on the FUND_SOURCE_CODE column:

SELECT * FROM IGF.IGF_AW_REPKG_PRTY WHERE FUND_SOURCE_CODE = 'INSTITUTIONAL' ORDER BY FUND_ORDER_NUM;

Reporting often involves joining this configuration data with transactional award data from other IGF tables to analyze how priority rules were applied in specific packaging scenarios.

Related Objects

Based on the provided dependency information, the IGF.IGF_AW_REPKG_PRTY table is a referenced object within the EBS schema. The primary relationship is with the APPS.IGF_AW_REPKG_PRTY synonym, which provides a public access point to the underlying IGF table for application code and privileged users. The metadata indicates no foreign key relationships to other tables are documented, suggesting it serves as a standalone reference table. Its data is likely accessed by the core award packaging engine within the IGF module, though those programmatic dependencies are not listed in the provided extract.