Search Results pell_amount




Overview
Explore in AI Chat

Overview

APPS.IGF_AW_COA_GRP_ITEM is a multi-org view in the Oracle E-Business Suite 12.1.1 / 12.2.2 environment, owned by the APPS schema and registered under FND Design Data as IGF.IGF_AW_COA_GRP_ITEM. It exposes Chart of Accounts (COA) group item configuration used by the Oracle Financial Aid (IGF) module, specifically the Award (AW) subsystem, which governs the packaging, costing, and disbursement of student financial aid awards. The view presents the line-level detail of COA group items — the components that make up a cost of attendance (COA) group — together with their default values, fixed-cost indicators, and distribution rules.

A defining characteristic of this view, documented explicitly in the ETRM metadata, is that it is a multi-org view: it automatically retrieves data only for the current operating unit and ignores rows belonging to other operating units. The ORG_ID column is the mechanism through which this operating unit security is enforced, filtered against the FND multi-org context established for the session. This makes the view particularly important for reporting and integration in multi-institution deployments, where a single database instance serves multiple schools or campuses. The presence of PELL_AMOUNT and PELL_ALTERNATE_AMT columns connects the view directly to the Federal Pell Grant program, which is central to U.S. Title IV financial aid processing.

Underlying Base Objects

According to the documented dependency metadata, APPS.IGF_AW_COA_GRP_ITEM is defined over the base table APPS.IGF_AW_COA_GRP_ITEM_ALL. This naming pattern is the standard Oracle multi-org convention: the _ALL table stores rows for every operating unit, while the view applies a WHERE ORG_ID = :current_org filter to present only the current organization's rows. The view therefore acts as an operating-unit-secured projection of the base table, and no additional tables are documented as direct sources of the view definition.

The view's dependency list also records downstream consumers. APPS.IGF_AW_COA_GRP_ITEM is referenced by APPS.IGF_AW_COA_CALC, APPS.IGF_AW_COA_GRP_ITEM_V, and APPS.IGF_GR_GEN. IGF_AW_COA_CALC is a costing calculation object, indicating that this view feeds the COA calculation engine that determines award budgets. IGF_GR_GEN relates to grant generation, and IGF_AW_COA_GRP_ITEM_V is a dependent view. Any modification to COA group item data propagates into these consumers.

Key Columns

  • ROW_ID — ROWID pseudo-column providing the physical row identifier for each record.
  • COA_CODE — Code identifying the Chart of Accounts group to which the item belongs; links items into a complete cost-of-attendance group.
  • CI_CAL_TYPE / CI_SEQUENCE_NUMBER — Calendar type and sequence number, binding the item to a specific aid year or period.
  • ITEM_CODE — The code for the individual COA item (for example, a component such as tuition or fees).
  • DEFAULT_VALUE — The numeric default amount applied to the item during COA calculation.
  • FIXED_COST — Indicator controlling whether the item is treated as a fixed cost.
  • ACTIVE — Flag indicating whether the item is currently active and available for calculation.
  • PELL_AMOUNT — The Pell Grant amount associated with the item; the column most relevant to the "pell_amount" search.
  • PELL_ALTERNATE_AMT — Alternative Pell amount, typically used where differing Pell treatment applies.
  • ITEM_DIST — Item distribution code controlling how the item is allocated.
  • LOCK_FLAG — Lock indicator that prevents recalculation or modification of the item.
  • ORG_ID — Operating unit identifier enforcing multi-org access.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns.

Common Use Cases and Queries

A frequent use case is auditing which COA items carry a Pell amount and how those amounts are configured for the current operating unit. A representative query is:

SELECT COA_CODE, ITEM_CODE, DEFAULT_VALUE, PELL_AMOUNT, PELL_ALTERNATE_AMT, ACTIVE FROM APPS.IGF_AW_COA_GRP_ITEM WHERE PELL_AMOUNT IS NOT NULL ORDER BY COA_CODE, ITEM_CODE;

Another scenario reconciles the Pell configuration against active items only, excluding fixed-cost components:

SELECT COA_CODE, ITEM_CODE, PELL_AMOUNT, FIXED_COST, DEFAULT_VALUE FROM APPS.IGF_AW_COA_GRP_ITEM WHERE ACTIVE = 'Y';

Because the view is multi-org secured, these queries return only rows for the operating unit of the current session, so developers should set the correct org context before running reports. For institution-wide analysis across operating units, the underlying _ALL table must be queried instead. Integrations extracting Pell configurations for downstream budgeting systems should join the view to IGF_AW_COA_CALC to trace how Pell amounts influence costing calculations.