Search Results igf_aw_awd_ltr_v




Overview
Explore in AI Chat

Overview

IGF_AW_AWD_LTR_V is a reporting view within the Oracle E-Business Suite Financial Aid (IGF) module, designated as obsolete in Oracle EBS releases 12.1.1 and 12.2.2. Its purpose is to consolidate the recipient, address, and award-related attributes required to generate the Award Notification Letter sent to a student. The view presents a denormalized, ready-to-print row per award recipient, drawing attributes such as name, correspondence address, contact details, and academic identifiers into a single queryable structure. Because the object is flagged as obsolete and is documented as "Not implemented in this database," it may not exist in a given environment and should not be relied upon for new development. Where present, it functions as a presentation-layer object rather than a transactional entity, and is consumed by letter-generation or correspondence processes rather than by core award processing logic.

Underlying Base Objects

The documented ETRM metadata records no referenced base objects and lists the owner as blank. The view text, however, exposes fully qualified column references prefixed by HZ, which points to the Trading Community Architecture (TCA) registry — the HZ_PARTIES family of tables. Every selected column carries an HZ alias, indicating the view is defined over TCA party and party-site data, joined or wrapped to present letter-ready fields. The view text also invokes the PL/SQL function IGS_CO_GEN_003.GET_PER_ADDR_FOR_CORR, which resolves the correspondence address for a given party. This confirms a dependency on the IGS/IGF student-system packages alongside the TCA registry. No join predicates, filters, or award-table references appear in the excerpted metadata, so the precise relationship to award records is not documented here.

Key Columns

The view exposes a broad set of recipient attributes. Identity columns include PERSON_ID (mapped to HZ.PARTY_ID), PARTY_NAME, PERSON_NUMBER (HZ.PARTY_NUMBER), and PARTY_TYPE. Name components are surfaced separately as GIVEN_NAMES, SURNAME, MIDDLE_NAME, PREFIX, SUFFIX, PREFERRED_GIVEN_NAME (HZ.KNOWN_AS), and PERSON_PREVIOUS_LAST_NAME. Address fields are provided as ADDRESS_LINE1 through ADDRESS_LINE4, plus CITY, COUNTY, POSTAL_CODE, COUNTRY, and the derived PERSON_NAME_ADDRESS produced by the correspondence-address function. Contact and correspondence attributes include EMAIL_ADDRESS, LANGUAGE_NAME, and DO_NOT_MAIL_FLAG, the latter used to suppress mailings. Academic and administrative identifiers include PERSON_ACADEMIC_TITLE, TITLE, PERSON_IDENTIFIER, and PERSON_IDEN_TYPE.

Common Use Cases and Queries

The primary use case is populating award notification letters with recipient name, correspondence address, and contact details. Because the object is obsolete, use of it should be limited to legacy reporting or troubleshooting existing letter templates. A representative query selecting letter fields for a given student is shown below.

  • Retrieving a recipient's mailing block: SELECT party_name, person_number, address_line1, address_line2, city, postal_code, country FROM igf_aw_awd_ltr_v WHERE person_id = :p_person_id;
  • Checking correspondence eligibility: SELECT person_id, party_name, do_not_mail_flag, email_address FROM igf_aw_awd_ltr_v WHERE do_not_mail_flag = 'N';
  • Producing name and address for printing: SELECT person_name_address FROM igf_aw_awd_ltr_v WHERE person_number = :p_number;

Before executing any of these statements, confirm the view exists in the target environment, since the metadata states it is not implemented in the documented database and the Financial Aid module is obsolete in 12.1.1 and 12.2.2.