Search Results alternate_code




Overview
Explore in AI Chat

Overview

IGF_AP_AWARD_YEAR_V is a reporting view in the Oracle E-Business Suite IGF — Financial Aid product, a module now classified as obsolete in the ETRM repository. The view exposes Award Year definitions used by the financial aid processing and disbursement side of the application, specifically the linkage between institutional calendar instances and batch award-year configuration records. Rather than presenting raw calendar data alone, it joins each award year calendar instance to its corresponding award-year mapping record and resolves multiple coded values into their descriptive equivalents through a lookup function.

The object carries the same identity across the 12.1.1 and 12.2.2 documentation sets; the ETRM metadata for 12.2.2 records no separately owned base objects, and implementation notes state that the view is not implemented in the documented database. Consequently it should be treated as a reference definition rather than an active runtime object in a standard installation. Its value is chiefly historical and analytical: it documents the structure that customer-specific or upgraded IGF implementations may still contain.

Underlying Base Objects

The view text is defined over two physical objects, joined on calendar type and sequence number:

IGS_CA_INST is a core Student Systems calendar table, which explains why no IGF-owned table is listed among the documented base objects in the 12.2.2 metadata. The join condition is BM.CI_CAL_TYPE = CI.CAL_TYPE AND BM.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER, meaning only calendar instances that have a matching award-year mapping row are returned — an inner join that filters the calendar population down to designated award years.

Key Columns

The view returns twenty-three columns. The identity columns ROW_ID, CAL_TYPE, and SEQUENCE_NUMBER uniquely describe each award year. START_DT and END_DT bound the award year, while CAL_STATUS and SUP_CAL_STATUS_DIFFER_IND describe its lifecycle state.

The column of particular interest to users searching on PRIOR_CI_SEQUENCE_NUMBER is precisely that column. It is sourced directly from IGS_CA_INST and records the sequence number of the calendar instance that precedes the current award year within the same calendar type. It effectively provides an in-row pointer to the prior award year, allowing chronological ordering and year-over-year comparison without a self-join or window function. Note that because the view performs an inner join against the batch award-year map, a predecessor calendar instance will only be visible as a row if it too carries a mapping record.

The remaining descriptive columns include CAL_DESCRIPTION (from CI.DESCRIPTION) plus six lookup-resolved values derived through IGF_AW_GEN.LOOKUP_DESC: AWARD_YEAR_STATUS_DESC, PELL_PARTICIPANT_DESC, and DL_PARTICIPANT_DESC, each decoded from its underlying code column using the IGF_AWARD_YEAR_STATUS and IGF_COD_PARTICIPANT_TYPE lookup types. PUBLISH_IN_SS_FLAG indicates whether the award year is published to the social services interface.

Common Use Cases and Queries

Typical usage centres on validating award-year setup, sequencing award years, and reporting disbursement eligibility. A representative query listing active award years together with their predecessors is:

  • SELECT cal_type, sequence_number, prior_ci_sequence_number, start_dt, end_dt, award_year_status_desc FROM igf_ap_award_year_v ORDER BY cal_type, sequence_number;
  • SELECT sequence_number, cal_description, pell_participant_desc, dl_participant_desc FROM igf_ap_award_year_v WHERE publish_in_ss_flag = 'Y';
  • SELECT a.sequence_number, a.cal_description, p.sequence_number prior_seq FROM igf_ap_award_year_v a, igf_ap_award_year_v p WHERE a.prior_ci_sequence_number = p.sequence_number AND a.cal_type = p.cal_type;

Given the obsolete status and the absence of documented base objects in 12.2.2, any such query should be preceded by a check of ALL_VIEWS to confirm the view exists in the target instance.