Search Results pell_code

Overview

IGF_AP_BATCH_AW_MAP_V is an Oracle EBS Applications (APPS) view owned by the APPS schema and registered under the IGF — Financial Aid product family. Its status is VALID, and it is available in both Oracle EBS 12.1.1 and 12.2.2 environments. The view presents batch award mapping configuration for financial aid processing, combining data from the underlying transaction table IGF_AP_BATCH_AW_MAP with academic calendar instance data from IGS_CA_INST. Its principal role is to expose the award-year and Expected Family Contribution (EFC) formula configuration used by the financial aid award packaging and disbursement engines, while enriching coded lookup values with their descriptive text for reporting and integration consumption.

Underlying Base Objects

The view text documents a join between two base objects:

• IGF_AP_BATCH_AW_MAP BAM — the batch award map table holding award-year, EFC formula, roundoff factor, EFC date-of-birth, system award year, and participant code configuration.
• IGS_CA_INST CA — the academic calendar instance table. The join predicate requires CA.CAL_TYPE = BAM.CI_CAL_TYPE AND CA.SEQUENCE_NUMBER = BAM.CI_SEQUENCE_NUMBER, linking each batch award map row to its academic calendar instance.

Several descriptive columns are derived at runtime through IGF_AW_GEN.LOOKUP_DESC against lookup types such as IGF_AP_EFC_FRML, IGF_AW_SYSTEM_AWARD_YEAR, IGF_AWARD_YEAR_STATUS, and IGF_COD_PARTICIPANT_TYPE. ETRM documents no additional referenced base objects beyond these.

Key Columns

• ROW_ID, BAM_ID — primary identifiers for the batch award map record.
• BATCH_YEAR, CSS_ACADEMIC_YEAR — the award batch year and CSS academic year associated with the configuration.
• ALTERNATE_CODE, START_DT, END_DT — academic calendar instance alternate code and its effective date range, sourced from IGS_CA_INST.
• START_DT_ACAD, END_DT_ACAD, ALTERNATE_CODE_ACAD, CI_SEQUENCE_NUMBER_ACAD, CI_CAL_TYPE_ACAD — academic calendar variants exposed by the view (null in the documented view text, populated for academic term alignment). When users search for start_dt_acad, this is the column they are resolving.
• EFC_FRML / EFC_FRML_DESC — Expected Family Contribution formula code and its lookup description.
• ROUNDOFF_FACT / ROUNDOFF_FACT_DESC, NUM_DAYS_DIVISOR — rounding and proration controls for EFC computation.
• EFC_DOB — the reference date of birth used for EFC calculation.
• DL_CODE, FFEL_CODE, PELL_CODE, ISIR_CODE, PROFILE_CODE — program-specific formula codes, each accompanied by a lookup description.
• SYS_AWARD_YEAR, AWARD_YEAR_STATUS_CODE, PELL_PARTICIPANT_CODE, DL_PARTICIPANT_CODE, PUBLISH_IN_SS_FLAG, TOLERANCE_LIMIT — system award year, status, Title IV participant types, self-service publication flag, and tolerance limit.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

The view is typically used to report award-year configuration alongside academic term boundaries, to validate EFC formula assignments, and to expose participa tion and publication flags to downstream interfaces.

To retrieve configuration for a specific batch year:

• SELECT batch_year, alternate_code, start_dt, end_dt, efc_frml, efc_frml_desc FROM igf_ap_batch_aw_map_v WHERE batch_year = :p_year;

To inspect academic term alignment using the start_dt_acad column:

• SELECT batch_year, alternate_code_acad, start_dt_acad, end_dt_acad, ci_cal_type_acad FROM igf_ap_batch_aw_map_v WHERE start_dt_acad BETWEEN :p_from AND :p_to;

To identify award years published to self-service with their status:

• SELECT sys_award_year, award_year_status_code, publish_in_ss_flag FROM igf_ap_batch_aw_map_v WHERE publish_in_ss_flag = 'Y';

Because the view performs its lookup-description resolution through IGF_AW_GEN, queries benefit from referencing the *_DESC columns rather than resolving lookup codes separately, simplifying reporting joins and improving readability of financial aid extracts.