Search Results end_dt_acad

Overview

The view APPS.IGF_AP_BATCH_AW_MAP_V is a supplementary database view owned by the APPS schema and registered under FND Design Data as IGF.IGF_AP_BATCH_AW_MAP_V. It belongs to the Oracle Financial Aid (IGF) product family and is designated a "supplementary view used to simplify forms coding" — that is, it exists primarily to support the Oracle Forms user interface layer rather than as a public data-access interface. Oracle explicitly warns that this view should not be queried or altered directly by customers, as its definition may change substantially between minor or major releases.

The view specializes in award-year (batch) configuration data used by the ISIR and verification processing engines. It exposes the batch calendar mapping — batch year, alternate code, start and end dates, and the associated academic and admissions calendar attributes — alongside financial-aid configuration parameters such as the Expected Family Contribution (EFC) formula, date-of-birth handling, tolerance limits, and Pell/FFEL/DL/ISIR transaction codes. Because the object is a view rather than a table, it presents a denormalized projection of these attributes and does not itself store data.

Underlying Base Objects

The documented ETRM 12.2.2 metadata for this object lists no referenced base objects. This is a common characteristic of Oracle Forms "supplementary views": the dependency metadata is either not published to the ETRM repository or is resolved only at the FND Design Data level. In practice, a view with this footprint is defined over IGF batch/award-year configuration tables (for example the batch award map and ISIR configuration entities that carry the ROW_ID, BATCH_YEAR, and CI_SEQUENCE_NUMBER columns), joined to lookup/description tables for the _DESC columns. The ROW_ID (ROWID) column is a critical indicator that the view is key-preserving, allowing Oracle Forms to identify and update rows through the view. Because the base objects are undocumented and the view is Forms-private, no reliable join path can be asserted from the metadata alone.

Key Columns

• ROW_ID — ROWID of the underlying row; confirms key-preservation for Forms use.
• BATCH_YEAR, ALTERNATE_CODE, START_DT, END_DT — Award-year batch definition and its date range.
• CI_SEQUENCE_NUMBER, CI_CAL_TYPE — Calendar instance sequence and calendar type for the batch.
• ALTERNATE_CODE_ACAD / _ADM and the corresponding START_DT_ACAD, END_DT_ACAD, CI_SEQUENCE_NUMBER_ACAD, CI_CAL_TYPE_ACAD (and _ADM equivalents) — academic and admissions calendar mappings returned here as VARCHAR2.
• CSS_ACADEMIC_YEAR — Associated academic year identifier.
• EFC_FRML, EFC_FRML_DESC — Expected Family Contribution formula code and its description (desc up to 4000 characters).
• EFC_DOB — DATE column carrying the EFC date-of-birth reference used in need-analysis configuration; this is the column the user searched for as "efc_dob".
• NUM_DAYS_DIVISOR, ROUNDOFF_FACT / _DESC — Rounding and proration controls for award calculations.
• DL_CODE, FFEL_CODE, PELL_CODE, ISIR_CODE, PROFILE_CODE (each with a _DESC) — Transaction and participation codes for the respective aid programs.
• TOLERANCE_LIMIT — Documented as the extent to which a difference between the ISIR amount and the verification amount is ignored.
• SYS_AWARD_YEAR / _MEAN, AWARD_YEAR_STATUS_CODE / _DESC — System award year and status coding.
• PELL_PARTICIPANT_CODE / _DESC — Indicates whether the school is a full participant or phase-in participant for Pell.
• BAM_ID — Batch award map identifier.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Who columns for audit.

Common Use Cases and Queries

Primary usage is through Oracle Forms in the Financial Aid setup and ISIR/verification configuration screens. Read-only diagnostic queries are common when troubleshooting EFC date-of-birth or tolerance behavior. Because the view is Forms-private, any SQL should be treated as diagnostic only.

• Identifying the EFC date-of-birth and formula configured for an award year.
• Reviewing tolerance limits and rounding factors applied during verification.
• Confirming Pell participation status and transaction codes.

Typical query:

SELECT bam_id, batch_year, alternate_code, efc_frml, efc_dob, tolerance_limit, roundoff_fact, pell_participant_code, award_year_status_code
FROM apps.igf_ap_batch_aw_map_v
WHERE batch_year = :batch_year;

Because the underlying tables are not documented in the ETRM metadata, customers should not build production integrations or customizations on this view; use the corresponding public IGF base tables or the supported Financial Aid APIs instead.