Search Results award_year_cal_seq_number




Overview
Explore in AI Chat

Overview

IGFBV_BATCH_YEAR_SETUPS is an Oracle E-Business Suite business intelligence system view owned by the APPS schema in the Oracle Financial Aid (IGF) module. It is registered in FND Design Data under the identifier IGF.IGFBV_BATCH_YEAR_SETUPS and holds a VALID status in releases 12.1.1 and 12.2.2. The view functions as the base view for the entity that maintains System Award Year Mapping details, presenting the relationship between the system award year and the associated Financial Aid award year, ISIR batch year, and profile year. Unlike conventional transaction tables, this object serves as a read-oriented reporting surface that consolidates award year calendar configuration so that downstream reporting, integration, and student self-service publication logic can consume a stable, denormalized representation of award year setup data.

Underlying Base Objects

Per the ETRM dependency section, APPS.IGFBV_BATCH_YEAR_SETUPS references a single documented base object: APPS.IGF_AP_BATCH_AW_MAP_ALL. That table stores the mapping records between ISIR batch year and award year, and the view exposes its rows in a form suitable for Business Intelligence queries. The view is not referenced by any other database object, confirming that it is a terminal reporting artifact rather than a dependency for further database constructs. The BAM_ID column, described as the identifier for the ISIR batch year and award year mapping, corresponds directly to the primary identifier of the underlying mapping table. Because the view is defined over an "_ALL" table, it may surface records across operating units depending on the security predicate applied to the base object; consumers should therefore validate row-level access expectations when building queries for multi-org deployments.

Key Columns

The view exposes the following columns, several of which are lookup tags resolved through the _LA naming convention for translatable lookup meanings:

  • _LA:SYSTEM_AWARD_YEAR (CHAR, 72) — Lookup tag denoting the system award year to which the Financial Aid award year, ISIR batch year, and profile year map.
  • AWARD_YEAR_CALENDAR_TYPE (VARCHAR2, 10) — Code indicating the award year calendar type.
  • AWARD_YEAR_CAL_SEQ_NUMBER (NUMBER, 15) — Documented as indicating the code for award year calendar type; this is the column returned when users search for "award_year_cal_seq_number".
  • _LA:AWARD_YEAR_STATUS (CHAR, 77) — Lookup tag indicating which award years are open, closed, or contain historical legacy data for Financial Aid.
  • NUMBER_OF_DAYS_DIVISOR (NUMBER) — Permitted values of 28, 29, 30, or 31, used in day-count calculations.
  • _LA:ROUND_OFF_FACTOR (CHAR, 69) — Lookup tag for the round-off factor code.
  • _LA:PUBLISH_IN_SS_FLAG (CHAR, 65) — Indicates whether the award year is published to the student in student self-service.
  • BAM_ID (NUMBER, 15) — Identifier for the ISIR batch year and award year mapping.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard WHO audit columns.

Common Use Cases and Queries

Typical usage involves resolving award year calendar configuration for reporting, validating self-service publication flags, and joining mapping identifiers back to batch processing data. A representative query retrieving the calendar sequence number requested by the user search follows:

SELECT _LA:SYSTEM_AWARD_YEAR, AWARD_YEAR_CALENDAR_TYPE, AWARD_YEAR_CAL_SEQ_NUMBER, _LA:AWARD_YEAR_STATUS FROM APPS.IGFBV_BATCH_YEAR_SETUPS;

Another common pattern filters for published award years: SELECT BAM_ID, _LA:SYSTEM_AWARD_YEAR FROM APPS.IGFBV_BATCH_YEAR_SETUPS WHERE _LA:PUBLISH_IN_SS_FLAG = 'Y';. Because the "_LA" columns are lookup tags, reports should join to FND_LOOKUPS or use the translated meaning rather than displaying raw tag values. Analysts building day-count or proration logic should inspect NUMBER_OF_DAYS_DIVISOR alongside AWARD_YEAR_CAL_SEQ_NUMBER to confirm the correct calendar basis per award year.