Results for “adplans_id”

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

Overview

IGF_AW_AWD_FRML_DET_ALL is an Oracle E-Business Suite table in the IGF (Financial Aid) product schema. It stores the detail sequence of funds that must be applied for a given award formula. In practical terms, it is the rule-detail table that drives how the Financial Aid award engine distributes available funds to a student for a given formula, and in what order. Each row represents one fund within one formula step, together with the sequencing and cap information that governs its application.

Under a heuristic Data Vault classification mined from the foreign-key structure, this object is best modeled as a link — it resolves the many-to-many relationships between award formulas, funds, person-identification groups, and distribution plans. It is not a pure reference hub, because it carries its own descriptive attributes such as minimum and maximum award amounts.

Key Information Stored

The physical schema documents 17 columns. The most important are:

• FORMULA_CODE, CI_CAL_TYPE, CI_SEQUENCE_NUMBER, SEQ_NO — the composite business key, exposed by the unique index IGF_AW_AWD_FRML_DET_ALL_PK. Together they identify the formula, its calendar type and sequence context, and the ordered step within the formula.
• FUND_ID — the fund to be applied at this sequence step; foreign key to IGF_AW_FUND_MAST_ALL.
• MIN_AWARD_AMT / MAX_AWARD_AMT — the floor and ceiling applied to the fund amount at this step.
• REPLACE_FC — governs whether the fund replaces a previously calculated fund contribution.
• PE_GROUP_ID — the person-identification group to which this detail applies; foreign key to IGS_PE_PERSID_GROUP_ALL.
• ADPLANS_ID — the associated award distribution plan; foreign key to IGF_AW_AWD_DIST_PLANS.
• LOCK_AWARD_FLAG — indicates whether the award resulting from this step is locked from further recalculation.
• ORG_ID — the multi-org operating unit discriminator.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Note that there is no single surrogate numeric key; the primary key is a natural composite key. Application logic should treat FORMULA_CODE, CI_CAL_TYPE, CI_SEQUENCE_NUMBER, and SEQ_NO as the unique row identifier.

Common Use Cases and Queries

The primary use case is resolving the ordered fund application sequence for a formula, commonly joined to the fund master and the person-identification group so that reporting can show which population receives which fund in what order.

• Listing the ordered funds for a formula:

SELECT d.SEQ_NO, d.FUND_ID, f.FUND_CODE, d.MIN_AWARD_AMT, d.MAX_AWARD_AMT
FROM   IGF.IGF_AW_AWD_FRML_DET_ALL d,
       IGF.IGF_AW_FUND_MAST_ALL f
WHERE  d.FUND_ID = f.FUND_ID
AND    d.FORMULA_CODE = :formula_code
ORDER BY d.SEQ_NO;

• Identifying which person-identification groups consume a given fund.
• Auditing award caps and floors for compliance review.
• Reconciling distributions against the referenced distribution plan (ADPLANS_ID).

Because the table is multi-org aware, queries in a multi-org environment should generally be filtered on ORG_ID.

Related Objects

• IGF_AW_FUND_MAST_ALL — joined on FUND_ID; provides the fund definition applied at each detail step.
• IGS_PE_PERSID_GROUP_ALL — joined on PE_GROUP_ID; this is the object the user searched for, supplying the person-identification group that qualifies the detail row.
• IGF_AW_AWD_DIST_PLANS — joined on ADPLANS_ID; defines the distribution plan for the award detail.
• IGF_AW_AWD_FRML_DET_ALL (self) — the FK metadata also references the composite business key back to the formula header context.
• IGF.IGF_AW_AWD_FRML_DET_ALL_PK — the unique index enforcing the composite business key, essential for direct row lookups.

Together these relationships establish the table as the operational link between formulas, funds, person groups, and distribution plans in the Financial Aid award process.