Search Results aw_sequence_number




Overview
Explore in AI Chat

Overview

The view APPS.IGF_AW_AWD_LD_CAL_V is a public Oracle application dictionary view within the Financial Aid (IGF) module of Oracle E-Business Suite. It is registered under the FND Design Data namespace IGF.IGF_AW_AWD_LD_CAL_V and holds a VALID status in both the 12.1.1 and 12.2.2 releases. According to the documented object details, the view is intended as a reporting and integration resource, and the documentation explicitly notes that it is "a public view which may be useful for custom reporting or other data requirements."

Its stated functional purpose is to "retrieve all the load calendars that fall within an award year." In practice, this makes the view the canonical join between the award year calendar (identified by the AW_ prefixed columns) and the load calendar (identified by the LD_ prefixed columns). This relationship is central to financial aid processing, where award-year definitions must be mapped to the load periods used for disbursement and registration validation. The presence of the AW_SEQUENCE_NUMBER column, which the searching user requested, reflects the view's reliance on the calendar instance structure defined in the underlying IGS calendar tables, where sequence numbers uniquely identify calendar instances.

Underlying Base Objects

The documented dependencies show that IGF_AW_AWD_LD_CAL_V is defined over the following base objects:

  • APPS.IGS_CA_INST — the calendar instance table holding individual calendar instance records, including the sequence numbers exposed as AW_SEQUENCE_NUMBER and LD_SEQUENCE_NUMBER.
  • APPS.IGS_CA_INST_REL — the calendar instance relationship table that establishes the parent-child linkage between an award year calendar instance and its associated load calendar instances.
  • APPS.IGS_CA_TYPE — the calendar type table that supplies the calendar type codes surfaced as AW_CAL_TYPE and LD_CAL_TYPE.

The view therefore materialises a two-level calendar hierarchy: the award year calendar instance at the top, and each load calendar instance that falls within that award year beneath it. The relationship rows in IGS_CA_INST_REL drive the "falls within" constraint that filters the results.

Key Columns

The view exposes eleven columns, each documented as follows:

  • ROW_ID (ROWID) — row identifier for the view record.
  • AW_CAL_TYPE (VARCHAR2, 10) — code for the award year calendar type, used within the operating unit.
  • AW_SEQUENCE_NUMBER (NUMBER) — a unique identifier for the award year calendar instance.
  • AW_ALTERNATE_CODE (VARCHAR2, 10) — alternate short reference code identifying the award year calendar instance.
  • AW_START_DT and AW_END_DT (DATE) — the award year calendar start and end dates.
  • LD_CAL_TYPE (VARCHAR2, 10) — code for the load calendar type, used within the operating unit.
  • LD_SEQUENCE_NUMBER (NUMBER) — a unique identifier for the load calendar instance.
  • LD_ALTERNATE_CODE (VARCHAR2, 10) — alternate short reference code identifying the load calendar instance.
  • LD_START_DT and LD_END_DT (DATE) — the load calendar start and end dates.

Together, the AW_ and LD_ column pairs provide a complete picture of the award-year-to-load-calendar mapping, including the sequence numbers that the searching user identified as the key attribute for joining calendar instances.

Common Use Cases and Queries

This view is referenced by several downstream objects, including IGF_AP_APPL_SETUPDTL_V, IGF_AW_ANTICIPATED_DATA, IGF_DB_SF_INTEGRATION, IGF_GR_PELL_CALC, and IGF_SL_GEN. It is therefore a foundational dependency for anticipated data extraction, integration, Pell calculation, and loan generation logic. Common uses include validating that a load calendar sits correctly inside its award year, and joining award-year data to load-calendar data for reporting.

A straightforward query returning all mapped calendars is:

  • SELECT ROW_ID, AW_CAL_TYPE, AW_SEQUENCE_NUMBER, AW_ALTERNATE_CODE, AW_START_DT, AW_END_DT, LD_CAL_TYPE, LD_SEQUENCE_NUMBER, LD_ALTERNATE_CODE, LD_START_DT, LD_END_DT FROM APPS.IGF_AW_AWD_LD_CAL_V;

To locate the load calendars under a specific award year instance, a filtered query on AW_SEQUENCE_NUMBER is typical:

  • SELECT LD_CAL_TYPE, LD_SEQUENCE_NUMBER, LD_START_DT, LD_END_DT FROM APPS.IGF_AW_AWD_LD_CAL_V WHERE AW_SEQUENCE_NUMBER = :p_aw_sequence_number;

Because the view is a public reporting view and not a business API, it should be treated as read-only. All queries should be scoped by the caller's operating unit context, since the calendar type codes are documented as being used within the operating unit.