Search Results igf_ap_batch_aw_map_all_pk

Overview

The IGF_AP_BATCH_AW_MAP_ALL table resides in the IGF (Financial Aid) product schema and stores the mapping between Integrated Student Information System (ISIR) batch years and award years within Oracle E-Business Suite releases 12.1.1 and 12.2.2. Its purpose is to associate a specific incoming ISIR batch with the corresponding academic and award year calendars, enabling the Financial Aid module to determine which award year configuration applies when processing a batch of federal student aid records.

Under the Data Vault classification heuristic mined from its foreign key structure, this table is best modeled as a link entity. It does not function as a standalone hub of business concepts but rather as an associative table connecting batch-year context, calendar instances, and award-year attributes. Each row carries descriptive configuration parameters in addition to its linking role, giving it a hybrid link-and-satellite character. The table is registered as VALID in the IGF schema and is documented with thirty physical columns in ETRM 12.1.1.

Key Information Stored

The surrogate primary key is BAM_ID, defined by the constraint IGF_AP_BATCH_AW_MAP_ALL_PK. This column uniquely identifies each mapping row and should be treated strictly as a system-generated identifier rather than a business identifier.

The documented unique indexes reveal the genuine business-key candidates. IGF_AP_BATCH_AW_MAP_ALL_UK1 covers BATCH_YEAR combined with ORG_ID, establishing that a batch year is unique within an operating unit. IGF_AP_BATCH_AW_MAP_ALL_UK2 covers CI_CAL_TYPE and CI_SEQUENCE_NUMBER. UK3 covers CI_CAL_TYPE_ACAD and CI_SEQUENCE_NUMBER_ACAD; UK4 covers CI_CAL_TYPE_ADM and CI_SEQUENCE_NUMBER_ADM. UK5 covers CSS_ACADEMIC_YEAR, and UK6 covers SYS_AWARD_YEAR.

Among the most significant descriptive columns are SYS_AWARD_YEAR, the system award year associated with the batch; CSS_ACADEMIC_YEAR, the academic year used by the CSS profile process; and the calendar-instance identifiers CI_CAL_TYPE, CI_SEQUENCE_NUMBER, CI_CAL_TYPE_ACAD, CI_SEQUENCE_NUMBER_ACAD, CI_CAL_TYPE_ADM, and CI_SEQUENCE_NUMBER_ADM, which bind the mapping to institutional calendar instances for general, academic, and admissions purposes.

Program-specific codes include PELL_CODE, DL_CODE, FFEL_CODE, ISIR_CODE, PROFILE_CODE, PELL_PARTICIPANT_CODE, and DL_PARTICIPANT_CODE, identifying the aid programs to which the mapping applies. Calculation parameters such as EFC_FRML, EFC_DOB, NUM_DAYS_DIVISOR, ROUNDOFF_FACT, and TOLERANCE_LIMIT control Expected Family Contribution processing behavior for the mapped batch. The AWARD_YEAR_STATUS_CODE and PUBLISH_IN_SS_FLAG columns govern lifecycle state and self-service visibility. Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) provide audit tracking.

Common Use Cases and Queries

The most frequent access pattern resolves the award-year configuration for a given ISIR batch. A representative query joins the table to calendar instances and filters by operating unit:

• SELECT b.bam_id, b.batch_year, b.sys_award_year, b.css_academic_year, b.award_year_status_code FROM igf.igf_ap_batch_aw_map_all b WHERE b.batch_year = :p_batch_year AND b.org_id = :p_org_id;
• Validation of program participation codes: SELECT b.batch_year, b.pell_code, b.dl_code, b.ffel_code, b.isir_code, b.profile_code FROM igf.igf_ap_batch_aw_map_all b WHERE b.award_year_status_code = 'ACTIVE';
• Joins to IGS_CA_INST_ALL to retrieve calendar instance details for a mapped academic year, using CI_CAL_TYPE and CI_SEQUENCE_NUMBER as the join predicates.

Reporting typically surfaces award-year status distribution, mapping coverage by batch year, and EFC calculation parameter audits. Because several candidate keys are enforced as unique indexes, inserts and updates must respect batch-year and award-year uniqueness within an operating unit; ad-hoc maintenance should target the surrogate BAM_ID and avoid touching business-key columns without validating against the unique constraints.

Related Objects

The documented foreign keys establish the primary dependencies of this table:

• IGS_CA_INST_ALL — referenced twice, via (CI_CAL_TYPE, CI_SEQUENCE_NUMBER) and via (CI_CAL_TYPE_ACAD, CI_SEQUENCE_NUMBER_ACAD), supplying calendar instance definitions for general and academic mappings. The admissions pair (CI_CAL_TYPE_ADM, CI_SEQUENCE_NUMBER_ADM) is modeled in the same pattern.
• IGF_AP_BATCH_AW_MAP_ALL_PK — the primary key constraint object on BAM_ID, which dependent child tables would reference.
• Associated unique index objects (UK1 through UK6) act as the business-key enforcement layer and are consulted during concurrent batch-load processing.

Beyond these documented relationships, Financial Aid ISIR batch processing and award-year setup components within the IGF module reference this table to resolve processing parameters at batch load time. Any modification to the mapping rows should be coordinated with those batch processes, since downstream EFC calculations and program eligibility determinations depend on the values stored here.