Search Results igf_cod_participant_type




Overview
Explore in AI Chat

Overview

APPS.IGF_AP_AWARD_YEAR_V is a reporting and integration view in the Oracle E-Business Suite financial aid module (IGF — the Student Aid / Financial Aid application family). It presents a consolidated picture of an award year by joining the institution's calendar instance definition to the batch award-year mapping record. The award year is modelled as a calendar instance (a row in IGS_CA_INST), while the award-year-specific attributes — such as award year status, Pell participant code, Direct Loan participant code, and the publishing flag — are carried on IGF_AP_BATCH_AW_MAP_ALL.

The view is primarily consumed by financial aid administrators, reporting extracts, and downstream integrations that need to determine the status and Federal participation codes associated with each award year. Notably, the view resolves the coded participant-type values into their descriptive meanings through calls to IGF_AW_GEN.LOOKUP_DESC, using the lookup type IGF_COD_PARTICIPANT_TYPE — the exact lookup referenced in the user's search — for both the Pell and Direct Loan participant codes, and the lookup type IGF_AWARD_YEAR_STATUS for the award year status code. By exposing descriptions alongside raw codes, the view removes the need for callers to perform their own lookup joins.

Underlying Base Objects

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

The join predicate is BM.CI_CAL_TYPE = CI.CAL_TYPE AND BM.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER, so each row represents one award year as defined by a calendar instance, enriched with its batch mapping attributes. The view also invokes the stored function IGF_AW_GEN.LOOKUP_DESC to translate three coded values into their descriptions.

Key Columns

  • ROW_ID / CAL_TYPE / SEQUENCE_NUMBER — the unique identity of the award year calendar instance.
  • START_DT / END_DT — the start and end dates of the award year.
  • CAL_STATUS / SUP_CAL_STATUS_DIFFER_IND — the calendar status and the indicator that the superior calendar status differs.
  • CAL_DESCRIPTION — the description of the calendar instance (the award year).
  • AWARD_YEAR_STATUS_CODE and its lookup description — the award year's status, decoded via lookup type IGF_AWARD_YEAR_STATUS.
  • PELL_PARTICIPANT_CODE and its lookup description — the Federal Pell participant type, decoded via lookup type IGF_COD_PARTICIPANT_TYPE.
  • DL_PARTICIPANT_CODE and its lookup description — the Direct Loan participant type, decoded via lookup type IGF_COD_PARTICIPANT_TYPE.
  • PUBLISH_IN_SS_FLAG — indicates whether the award year is published to self-service.

Common Use Cases and Queries

The most common use is determining the participant-type descriptions for an award year's Pell and Direct Loan programs, which is precisely where the IGF_COD_PARTICIPANT_TYPE lookup is applied. A typical query lists award years and their decoded participation:

SELECT cal_type, sequence_number, start_dt, end_dt, cal_description, award_year_status_code, pell_participant_code, dl_participant_code, publish_in_ss_flag FROM apps.igf_ap_award_year_v ORDER BY start_dt DESC;

A filtered query locating a specific year's Federal participation:

SELECT cal_type, sequence_number, cal_description, pell_participant_code, dl_participant_code FROM apps.igf_ap_award_year_v WHERE sequence_number = :seq AND cal_type = :ctype;

Reporting extracts frequently filter on the publishing flag, for example WHERE publish_in_ss_flag = 'Y', to build the set of award years exposed to student self-service. Developers integrating with the view should note that the participant-type description columns are unnamed function-call expressions in the underlying SELECT, so callers should reference them by positional alias or select only the coded columns and resolve descriptions separately where column naming is required.