Results for “fund_order_num”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGF_AW_REPKG_PRTY table resides in the IGF (Financial Aid) product schema of Oracle E-Business Suite and is classified as a VALID base table in both release 12.1.1 and 12.2.2. Its purpose, per the ETRM documentation, is to set up the re-package priority of funds at the System Fund Level. In practice, this table drives the ordering logic used by Oracle's Financial Aid award repackaging routines, which determine how available aid dollars are redistributed across a student's award package when a fund is reduced, cancelled, or when new resources become available. The re-package priority stored here governs the sequence in which system funds are considered for adjustment, ensuring institutional policy is applied consistently during automated repackaging events.

The heuristic Data Vault classification derived from the foreign-key structure is standalone, meaning the mined metadata identified no outbound FK dependencies. From a modeling perspective, this suggests the table functions as a reference or configuration entity rather than a transactional hub or link. A Data Vault practitioner would likely treat the composite business key as the natural key of a hub or as a satellite attached to a system-fund hub, with the ordering attribute carried as descriptive context.

Key Information Stored

The documented physical schema contains nine columns. The most significant include:

• FUND_ORDER_NUM — The single-column surrogate primary key (IGF_AW_REPKG_PRTY_PK) that assigns the numeric priority position to a fund during repackaging. Lower values typically indicate funds processed earlier in the repackaging sequence.
• SYS_FUND_TYPE_CODE, FUND_SOURCE_CODE, and SYS_FUND_CODE — Together these three columns form the unique business-key candidate defined by the unique index IGF_AW_REPKG_PRTY_U1. They identify, respectively, the category of the system fund, the originating source of the funds, and the specific system fund whose priority is being established. This composite uniqueness guarantees that only one priority can be registered for a given fund source combination.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — Standard Oracle EBS WHO-column audit attributes that record user and timestamp provenance for each priority row.

Notably, the ETRM metadata does not document a FK from FUND_ORDER_NUM to any parent table, reinforcing the standalone classification.

Common Use Cases and Queries

Administrators and financial aid analysts query this table to audit or tune the institutional repackaging sequence. A typical read pattern retrieves the ordered priority list for a given fund type or source:

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;

A filtered lookup for a specific fund source supports troubleshooting why a fund repackaged before another:

SELECT fund_order_num
FROM   igf.igf_aw_repkg_prty
WHERE  sys_fund_type_code = :p_type
AND    fund_source_code   = :p_source
AND    sys_fund_code      = :p_fund;

Reporting use cases include generating a "Repackaging Priority Report" for compliance review, validating that no duplicate business keys exist, and connecting the priority sequence to award disbursement logic. Extract/load scripts often reference the composite unique index to perform idempotent upserts into data warehouses.

Related Objects

Because the mined metadata records no foreign keys, related objects are inferred from the shared Financial Aid domain and naming conventions:

• IGF_AW_SYS_FUNDS — The system fund definition table referenced conceptually via SYS_FUND_CODE and SYS_FUND_TYPE_CODE.
• IGF_AW_FUND_SOURCE — Defines the valid values for FUND_SOURCE_CODE.
• IGF_AW_AWARD_PACKAGE — The award package header whose repackaging process consumes this priority setup.
• IGF_AW_DISBURSEMENTS — Disbursement records affected when repackaging changes a fund's award.
• IGF_AW_REPKG_PRTY_U1 / IGF_AW_REPKG_PRTY_PK — The unique and primary key indexes enforcing data integrity.

Together these objects form the configuration backbone that Oracle Financial Aid repackaging processes consult before adjusting a student's aid award.