Results for “alt_loan_code”

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

Overview

IGF_AW_FUND_CAT_ALL is a Financial Aid (IGF) application table in Oracle E-Business Suite, holding the master definition of aid funds and their category assignments. The description in the ETRM metadata states that it "stores different funds and categorizes them," which positions the table as the authoritative catalog of fund records used by the Oracle Financial Aid award-processing and disbursement flows. Each row represents a single fund, identified by a fund code and scoped to an operating unit through ORG_ID, establishing the multi-org security boundary characteristic of EBS data models.

From a modeling perspective, the relationship metadata classifies this table heuristically as hub-leaning within a Data Vault interpretation. That classification is consistent with the object's behavior: the table acts as a stable business-key registry for funds, while dependent tables (IGF_AW_FUND_INCL_ALL, IGF_AW_FUND_EXCL_ALL, and IGF_AW_FUND_MAST_ALL) behave like satellites and link-adjacent structures that record participation, exclusion, and master-fund relationships around each fund. The surrogate key, FCAT_ID, provides the immutable hub identifier, whereas FUND_CODE plus ORG_ID form the durable business key.

Key Information Stored

The documented physical schema contains sixteen columns. The most significant are:

• FCAT_ID — the surrogate primary key, defined by index IGF_AW_FUND_CAT_ALL_PK. This value is system-generated and should be used for joins where referential stability is required.
• FUND_CODE — the business identifier for the fund. Along with ORG_ID, it forms the unique index IGF_AW_FUND_CAT_ALL_U1, making it the primary business-key candidate.
• ORG_ID — the operating unit (multi-org) identifier. It participates in the fund business key and appears in every foreign-key relationship documented for this table.
• ALT_LOAN_CODE — an alternate loan code, uniquely indexed by IGF_AW_FUND_CAT_ALL_U2, typically used to map the fund to external or alternate loan-processing references.
• FUND_TYPE — a foreign key to IGF_AW_FUND_TYPE_ALL, partitioning funds into categories such as grant, loan, or work-study.
• ALT_REL_CODE — a foreign key to IGF_SL_CL_RECIPIENT, tying the fund to an alternate recipient or relationship definition.
• DESCRIPTION — the human-readable fund name used in reports and inquiry screens.
• FUND_SOURCE and FED_FUND_CODE — the source designation of the fund and its federal fund code, both essential for federal reporting and reconciliation.
• SYS_FUND_TYPE — a system-derived fund-type classification, generally used internally to drive processing logic.
• ACTIVE — the enablement flag controlling whether the fund is available for use in award and disbursement processing.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS audit columns, maintained automatically by the application.

Common Use Cases and Queries

Reporting on active funds for a given operating unit is the most frequent use case. A typical query lists funds with their category and source:

• SELECT fc.fund_code, fc.description, fc.fund_type, fc.active FROM igf.igf_aw_fund_cat_all fc WHERE fc.org_id = :p_org_id AND fc.active = 'Y'
• Joining to the fund type table to resolve categories: SELECT fc.fund_code, ft.description FROM igf.igf_aw_fund_cat_all fc, igf.igf_aw_fund_type_all ft WHERE fc.fund_type = ft.fund_type AND fc.org_id = ft.org_id
• Identifying funds included or excluded from a given processing run by joining through fund_code and org_id to IGF_AW_FUND_INCL_ALL or IGF_AW_FUND_EXCL_ALL.
• Auditing recently maintained fund records using last_update_date, a standard EBS change-tracking pattern.
• Resolving alternate loan codes to funds for reconciliation with external loan systems via ALT_LOAN_CODE or ALT_REL_CODE.

All queries should filter on ORG_ID because the table is multi-org enabled and the business key is scoped by operating unit.

Related Objects

The FK metadata identifies several dependent and referenced objects that are central to fund processing:

• IGF_AW_FUND_TYPE_ALL — referenced by IGF_AW_FUND_CAT_ALL.FUND_TYPE (and ORG_ID), providing the fund category definition.
• IGF_SL_CL_RECIPIENT — referenced via ALT_REL_CODE, supplying the alternate recipient or relationship record.
• IGF_AW_FUND_INCL_ALL — references this table through FUND_CODE and ORG_ID, recording funds included in a processing scope.
• IGF_AW_FUND_EXCL_ALL — references this table through FUND_CODE and ORG_ID, recording excluded funds.
• IGF_AW_FUND_MAST_ALL — references this table through FUND_CODE and ORG_ID, holding master-fund level attributes.

Together these objects form the fund configuration cluster within the IGF schema, with IGF_AW_FUND_CAT_ALL serving as the central hub from which inclusion, exclusion, and master detail records derive their context.