Search Results igfbv_batch_year_setups

Overview

The view IGFBV_BATCH_YEAR_SETUPS is a base database view belonging to the IGF — Financial Aid product family in Oracle E-Business Suite. Per its Oracle ETRM (E-Business Suite Technical Reference Manual) entry, it is described as the "Base View for the Entity that holds the System Award Year Mapping details." The IGF module is flagged as Obsolete in the documented releases (12.1.1 and 12.2.2), and the ETRM implementation record explicitly notes "Not implemented in this database." This indicates that the view is retained in the data dictionary for historical and documentation continuity but is not active in the current installation.

Functionally, the view exposes the mapping between internal batch processing records and the system award year configuration. It decodes several stored code values into human-readable meanings via the IGF_LOOKUPS_VIEW mechanism — the _LA: prefixed column aliases are the standard EBS translation/lookup substitution tokens. Because the view is read-only (WITH READ ONLY), it is intended strictly for querying and reporting rather than for DML operations, making it suitable as a reporting surface for financial aid award-year setup data.

Underlying Base Objects

The ETRM metadata documents that this view references no additional base objects beyond its direct source table. Its sole underlying table is:

• IGF_AP_BATCH_AW_MAP_ALL — the "all" organization variant of the batch award-year mapping table. The view is defined directly over this table with no joins.

This one-to-one relationship means the view is essentially a presentation and lookup-decoding layer over IGF_AP_BATCH_AW_MAP_ALL, exposing the same rows while transforming coded columns into descriptive meanings. The BAM table alias used throughout the view text indicates the source table's short alias convention.

Key Columns

The view exposes the following documented columns:

• "_LA:SYSTEM_AWARD_YEAR" — The decoded system award year meaning, resolved from BAM.SYS_AWARD_YEAR against the IGF_AW_SYSTEM_AWARD_YEAR lookup.
• AWARD_YEAR_CALENDAR_TYPE and AWARD_YEAR_CAL_SEQ_NUMBER — The calendar type (CI_CAL_TYPE) and sequence number (CI_SEQUENCE_NUMBER) identifying the award year's academic calendar configuration.
• "_LA:AWARD_YEAR_STATUS" — Decoded award year status, resolved from AWARD_YEAR_STATUS_CODE against the IGF_AWARD_YEAR_STATUS lookup.
• NUMBER_OF_DAYS_DIVISOR — The divisor applied in award-year day calculations (mapped from NUM_DAYS_DIVISOR).
• "_LA:ROUND_OFF_FACTOR" — Decoded rounding factor, from ROUNDOFF_FACT against the IGF_AP_EFC_ROUND_FACT lookup.
• "_LA:PUBLISH_IN_SS_FLAG" — Decoded yes/no flag indicating whether the record is published to self-service, resolved via the IGF_AP_YES_NO lookup (from PUBLISH_IN_SS_FLAG).
• BAM_ID — The unique identifier for the batch award-year map record. An external reference in _LA:BAM.BAM_ID appears in the view text, used as the lookup key. This is the column corresponding to the user's search term "bam_id".
• Standard audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE, providing WHO-column auditability.

Common Use Cases and Queries

Because the view is read-only and pre-decodes lookup values, it is best suited for reporting on batch award-year mapping setups without requiring joins to lookup tables. A typical query retrieving all mappings for a given award year would resemble:

• SELECT bam_id, "_LA:SYSTEM_AWARD_YEAR", AWARD_YEAR_CALENDAR_TYPE, AWARD_YEAR_CAL_SEQ_NUMBER, "_LA:AWARD_YEAR_STATUS", NUMBER_OF_DAYS_DIVISOR FROM IGFBV_BATCH_YEAR_SETUPS;
• Filtering by publish flag: SELECT bam_id, "_LA:PUBLISH_IN_SS_FLAG" FROM IGFBV_BATCH_YEAR_SETUPS WHERE "_LA:PUBLISH_IN_SS_FLAG" = 'Yes';
• Award-year resolver query keyed on the search term: SELECT * FROM IGFBV_BATCH_YEAR_SETUPS WHERE bam_id = :bam_id;

Given the module's obsolete status and the "not implemented" note, DBA and integration developers should verify object availability before referencing it in 12.1.1 or 12.2.2 environments; where present, it serves as a convenient, decoded reporting interface over IGF_AP_BATCH_AW_MAP_ALL.