Search Results pell_code

Overview

IGF_AP_BATCH_AW_MAP is a Financial Aid (IGF) view in Oracle E-Business Suite that exposes award-year mapping and configuration data used to drive the processing of financial aid batches — specifically Pell Grant, Direct Loan (DL), and FFEL award processing. The view is documented in ETRM as belonging to the IGF – Financial Aid product, which carries the "(Obsolete)" designation in Oracle EBS 12.1.1 and 12.2.2. The view presents rows from the underlying table IGF_AP_BATCH_AW_MAP_ALL, filtered by the operating unit (ORG_ID) of the current session, and serves as a read-only, multi-tenant-safe presentation layer for financial aid batch parameters such as EFC (Expected Family Contribution) formula settings, award-year status, and participant codes.

The name "AW_MAP" reflects the view's role as an award-year mapping construct: it associates a batch of aid processing with the applicable academic year, system award year, and the codes that identify the aid programs being processed. The user search term "efc_dob" corresponds directly to the EFC_DOB column exposed by this view, which is a key configuration attribute used in need-analysis calculations.

Underlying Base Objects

Per the ETRM metadata, the view is defined over the base table IGF_AP_BATCH_AW_MAP_ALL with the alias BAM. The SELECT list references BAM.ROWID and a broad set of BAM columns, confirming a straightforward view-over-table relationship with no documented secondary base objects. The metadata notes "Referenced base objects: none documented" for the 12.2.2 layer, meaning the ETRM record for this view does not enumerate any additional joins or dependent objects beyond the referenced table. The view is therefore best understood as a secured projection of the _ALL table.

The WHERE clause implements row-level security by comparing the ORG_ID of the row against the operating unit derived from the session's CLIENT_INFO context (the first 10 characters of USERENV('CLIENT_INFO')). Rows whose ORG_ID is null are matched against the -99 default, implementing the standard multi-org "secured" view pattern used throughout EBS 12.1.1 and 12.2.2. Notably, the view text selects NULL for the CI_SEQUENCE_NUMBER_ACAD, CI_CAL_TYPE_ACAD, CI_SEQUENCE_NUMBER_ADM, and CI_CAL_TYPE_ADM columns, meaning these four columns are declared in the column list but are not populated by the view's query.

Key Columns

• BATCH_YEAR — The processing batch year to which the award mapping applies.
• EFC_FRML — The Expected Family Contribution formula identifier used for need analysis.
• EFC_DOB — The EFC date-of-birth attribute; the column referenced by the user's "efc_dob" search and a configuration input to EFC computation.
• NUM_DAYS_DIVISOR — Divisor used in prorating awards across the enrollment period.
• ROUNDOFF_FACT — The rounding factor applied when calculating award amounts.
• CSS_ACADEMIC_YEAR — The academic year associated with the batch.
• SYS_AWARD_YEAR and AWARD_YEAR_STATUS_CODE — The system award year and its processing status.
• PELL_CODE, DL_CODE, FFEL_CODE, ISIR_CODE, PROFILE_CODE — Program and document identifiers for Pell, Direct Loan, FFEL, ISIR, and PROFILE processing.
• PELL_PARTICIPANT_CODE, DL_PARTICIPANT_CODE — Institution participation codes for the respective aid programs.
• TOLERANCE_LIMIT — Tolerance threshold used when reconciling aid amounts.
• PUBLISH_IN_SS_FLAG — Flag controlling whether the mapping is published to self-service.
• ORG_ID — The operating unit owning the row; drives the view's multi-org filter.
• BAM_ID — Primary key of the underlying mapping record.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS auditing columns.
• ROW_ID — The underlying table ROWID, exposed as the first column.

Common Use Cases and Queries

The view is typically queried to retrieve the award-mapping parameters in effect for a given operating unit and award year, to inspect the EFC formula and DOB settings, or to verify which program and participant codes are active for a batch. Because the view applies ORG_ID security automatically, queries executed through an application session return only rows for the session's operating unit.

To inspect the EFC configuration for a specific award year:

SELECT BATCH_YEAR, EFC_FRML, EFC_DOB, NUM_DAYS_DIVISOR, ROUNDOFF_FACT, SYS_AWARD_YEAR, AWARD_YEAR_STATUS_CODE FROM IGF_AP_BATCH_AW_MAP WHERE SYS_AWARD_YEAR = :award_year;

To review participant and program codes for the current operating unit:

SELECT BAM_ID, PELL_CODE, PELL_PARTICIPANT_CODE, DL_CODE, DL_PARTICIPANT_CODE, FFEL_CODE, TOLERANCE_LIMIT FROM IGF_AP_BATCH_AW_MAP ORDER BY BATCH_YEAR;

To confirm which mappings are published to self-service and their audit history:

SELECT BATCH_YEAR, PUBLISH_IN_SS_FLAG, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM IGF_AP_BATCH_AW_MAP WHERE PUBLISH_IN_SS_FLAG = 'Y';

Because the underlying product area is flagged obsolete, these queries are most relevant to historical data review, migration validation, or support of legacy financial aid implementations rather than to current development.